-
1099 report for year ending 12/31/2021 for NAV2016
Hi all, As formal support for NAV2016 has ended, Microsoft has said it will not be issuing 1099 updates for NAV2016. I'm wondering if it's possible to "downgrade" the version from NAV2016? I'm fairly certain that the database hasn't changed, but I do know that the 1099 report layout has significantly changed, and the 1099…
-
Warehouse Class Codes on Released Production Orders
I am currently using directed put away and pick for my location and have recently started testing transactions with warehouse class codes. While I can get the initial inbound flow to work (Purchase Order receipt and Put Away) with warehouse class codes, FYI you need a bin for receiving and storage that match the warehouse…
-
Is developing in a remote-container possible?
Following the Concept of developing inside a container https://code.visualstudio.com/docs/remote/containers i try to attach VSC to a BCxx Container that i've created with New-BcContainer. unfortunately i can't get it to work. if i click "Attach to running container" i'll get: [68 ms] Remote-Containers 0.209.6 in VS Code…
-
G/L Account lines add on sales line in Posted Sales Invoice
In NAV, fetch sales order from webshop in Microsoft dynamic NAV and posted right away by using standard codeunit 80.In posted sale invoice, G/L account type line will be created automatically. Please guide me about that how to overcome this problem.
-
Drag and drop functionality in NAV/BC
Hi all We have developed a function Drag&Drop on NAV standard fuctionality. You can find the code below: 1. On a page on the field choose attribute Control addin - WebPageViewer 2. This Control addin allows to display websites through the function SetContent. This function could have 2 parameters - HTML Code and Script on…
-
Word-Layout repeating DataItem OPNo_ProdOrderRtngLine - Report 99000762 Manufacturing Job Card
Hi all, I am trying to adjust the Word layout for report 99000762 to achieve a similar behaviour compared to the integrated RDLC layout: one page per production order routing line. Therefore I placed my report layout inside a 1x1 table with the following XML mapping:* 'OPNo_ProdOrderRtngLine' as a text-element inside the…
-
Dynamics 365 Business Central Email and Email Message
If you are interested, how to use the functionality of Dynamics 365 Business Central for sending emails, check Simplanova's latest blog post in which our developer Raimund reviews specific settings that enable additional functionality, such as adding attachments and recipients in a letter. Have a read here:…
-
Read Windows Registry from NAV2016 C/AL
Hi all, I'm trying to read a registry value in NAV2016. I've defined a DotNetVariable as ProcessFileName Microsoft.Win32.Registry.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' If I look in Regedit, I see a registry key I'm looking for. I exported it to a .reg file and here is the contents:…
-
I am retired, pleas remove or disable my account
Dear administrators, I am retired, please remove or disable my account. Regards, Rudolf Stammis.
-
Job market in Mexico
Hi, I might move to Mexico, how are job or freelance opportunities there in the NAV sector? I have to admit my spanish is more on a toddler level and this has to improve, obviously. But may be english is sufficient at first? Thanks!
-
The server failed to resume the transaction
Hi, A user is on NAV2017 and Microsoft SQL Server 2016 Enterprise Edition. The error log for the NAV Service tier contains various rows with the error message "The server failed to resume the transaction". Does anyone have experience with this error and experience regarding how to solve it? Thanks in advance for any help
-
How to use OData URL and consume it.
Hi everyone, I want to share data of shipment method table using OData. I made a page of shipment method table for this and added it to web services and got the URL. If I am accessing this OData URL then I am seeing table data in XML format on the browser. [Please check below] <?xml version="1.0" encoding="utf-8"?><feed…
-
How to access my BC Instance from different computer?
Hi all, Am new here and trust all is well with you, I have created a new VM(Window server 19) on Azure and I have installed Business central 18 on it and I configured IIS as well as AD DS, I tried to access my service through localhost/bc180 and it runs well. Now I want to access my services from other computers using URL…
-
Problem with delegation...
Hi, I have a three tier setup: BCWEB1 - Running the webclient. BCWEB2 - Running the webclient. BCSER - Running the BC service tier BCSQL - Running the SQL server. dom\ser_bc - Is the service account, running both the BC Service tier, and the application pool. BCWEB is the internal DNS name pointing to the internal Azure…
-
Media to text
Dear All good day. I'm on BC on cloud (accordingly I can't use any on-prem procedure) I have to convert a media file to text in order to push it on out API. local procedure MEDIAasTXT(): Text var DocumentAttachment: Record "Document Attachment"; MediaAsOutStream: OutStream; begin DocumentAttachment.SetRange("Table ID",…
-
BC 18+: Use implicit Drill Down behavior of Global-Records'-field in Page Field
Hi, I'm optimizing/cleaning up a page where there are two related records shown next to each other. One of the records is defined as the SourceTable, the other one is from a different table with a 1:1 relation. It is defined as a global variable which is retrieved in the OnAfterGetRecord-trigger with some conditional…
-
Approver cannot see record to approve upon clicking Open Record in Request to Approve page.
I created a workflow from scratch for Store Requisition. Everything works fine except that no entries are being created on table 454 ( Approval Entries). The Approver receives the request but cannot review the record. see attached screenshot.
-
Powershell Invoke-RestMethod to insert a new customer
Hi, I am trying to insert a new customer using PowerShell via Odata. #Create new Customer
$Credential = [System.Management.Automation.PSCredential]::new('USERNAME',(ConvertTo-SecureString 'PASSWORD' -AsPlainText -Force))
$Payload = "{ ""No"" : ""TEST10001"", ""Name"" : ""Test asdfgh"" }" $obj1 = Invoke-RestMethod ` -uri…
-
TableRelation with extensions
Hello, I have a problem with this table extension and I want to change it. This is the standar code of the table 1208 in field "Applies-to Entry No." TableRelation = "Cust. Ledger Entry" WHERE("Customer No." = FIELD("Customer No."), "Document Type" = FILTER(Invoice | "Finance Charge Memo" | Reminder | Bill), Open =…
-
QRCode support for BC Online
Hi, Barcode is supported natively in Dynamics BC 2021 wave 1 onwards. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-add-barcodes Question is, is QRcode supported in Dynamics BC online? Or It only works with using a 3rd party qr code generator service?
-
Upgrade Windows OS version NAvision 2009 R2 Application
Hello, My navision 2009 r2 application is installed on windows server 2008 R2, I would like to know if it's possible do direct upgrade to 2012 R2. I'm not telling create a new machine. Thank you.
-
NAV 2016 in Docker Container returns "Could not create SSL/TLS secure channel" on web request
Hi all, We do our in-house development in local Docker containers. We have a shipping solution that communicates with Fedex web services. Since the last update of the NAV2016 Docker image artifacts (approx Nov 1, 2021 - perhaps a week earlier), when running a Fedex web service request, we receive an error "Could not create…
-
Cloud BC Integration to WooCommerce
Hi All, any recommended app that can integrate Cloud BC to WooCommerce? Some of the Sync features we need : From Business Central: Business Central products (Item card + Item Attributes) to WooCommerce Products Business Central Stock Level real time sync to WooCommerce Business Central Prices to WooCommerce Business…
-
SQL Profiler with Business Central
Has anyone successfully used SQL Profiler with Business Central? I'm working with a BC15 On-Premise installation. I'm trying to user SQL Profiler to trace some locking sequences. Something I've done countless times with NAV. The problem I'm having is SQL Profiler seems to lock up BC. My BC process will not end unless I…
-
NAV2009 on Server/SQL 2016+
Does anyone know of a solution still running NAV2009 but on a newer MS Server OS (2016+) and MS SQL solution (2016+)? Or alternatively stopped an update of Server/SQL from doing this for any reason, bug etc?
-
Pillars from Directions EMEA 2021 by Microsoft MVP for Business Applications Stefano Demiliani
Pillars from Directions EMEA 2021 by Microsoft MVP for Business Applications Stefano Demiliani: Dynamics 365 Business Central growth on adoption and its improvements in all aspects. Have a look at Simplanova's latest blog post and find important messages that were given to partners and customers during the…
-
What’s Coming to Business Central? [Directions EMEA 2021 Reflections]
Founder of Simplanova Petras Butenas is sharing his reflections on the main announcements made at Directions 4 Partners conference in Milan. If you could not join Directions EMEA this year or if you missed some pieces, please find the recoupment of the main points in our latest blog post:…
-
Microsoft Validation Error, While I changed field's data type from Option to Enum in BC V-19.1
Hi, I have a table with one of it's field is "Document type" as option. it has option members 'Quote,Order,Invoice,"Credit Memo","Blanket Order","Return Order",,,,"Add/Remove"'. Then I have changed this field's data type as Enum "Sales Document type". This Enum is Microsoft's standard and has all the option members except…
-
Business Central 180 crashes when user try to rename Item
Hi guys, When I try to rename Item WebClient crashes. The error that I found in event viewer looks like this. When I try to debug Base app I get that client crashes when GlobalTrigger GetGlobalTableTriggerMask parameter TableID=7326. Any help would be appreciated. Message: Specified method is not supported. StackTrace: at…
-
Intercompany Posting from A to B, and then cant post it back from B to A.
Hi all, I have an issue with intercompany. I am using cloud BC. previously my scenario is : Company A, create PO and then post it.. it will create SO in Company B and then company B , post this PO then it will create PI in Company A. now since 15 october 2021, after Microsoft update. Company B cant send it back to Company…