-
TableSync 'move' fails
In an updated 2013 (to 2016) database I'm having issues with a table sync upgrade. I've copied the original table to a new temporary table. Removed all code and variables from the new table. All fields are the same and so is the PK (even ran a text compare to confirm). By my upgrade CU is throwing this error:Sync-NAVTenant…
-
Importing a xml with external DTD (NAV 2015)
Hi all, I am trying to import an xml file with an external DTD into NAV 2015. We are migrating from 4.03, in this version it was runnig well. Now I am getting: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the…
-
How do I download and use DotNet Packages in BC25
I need to transliterate non-latin characters and found a DotNet package in the package manager NuGet. I don't know how to download it from the command line and make a proper dotnet project yet, but I can download it manually, which gets me a ".nupkg" file. Is this usable in my AL project? Do I just put the it in the…
-
BC (SaaS) Webhook for invoice fully paid (closed)
Hi, I'm looking to implement a webhook in Business Central (SaaS) to trigger a notification whenever a vendor invoice is fully paid (closed). However I've listed the supported webhooks using the /webhookSupportedResources endpoint, and I can't see any that are suitable. I tried using the "v2.0/vendorPayments" resource, but…
-
Sessions are not closed on SQL server
We are running BC20 cu7 OnPrem. We are having some issues with locks in our solution and we have discovered that many sessions are not "deleted" from SQL server even though it is several days since their connection were closed. If we go into Database locks in BC sometimes a user is shown and sometimes there is no session…
-
Save file to Server BC25 OnPrem
Is it still possible to save a file to a server location within Business Central 25 on-premise? Is anyone able to share a working example? Thank you. The current solution doesn't appear to save to the file path: FilePath := \\SomeServer\SomeFolder\File.txt
FileMgt.BLOBExport(TempBlob, FilePath, true);
-
Business Central chocolatey docker install
Hi All, I've spent a while trying to make this work but unfortunately it's a dead end. As you may know docker desktop requires a licence if you are going to develop with it, most likely everyone is ignoring this... Following microsoft's help:…
-
Issue with default user e-mail from Outlook - BC14
Good morning everyone, In the past few days, we have been experiencing an issue with the email associated with a BC14 user account. Specifically, there has been a domain change in the email address associated with the Windows/Microsoft account: for example, from test@XXXX.com to test@YYYY.com. The Windows account settings…
-
How to Disable table trigger in Business Central with AL extension
Hi, I want to disable table trigger on item category table for Parent Category field(2; "Parent Category"; Code[20]) { Caption = 'Parent Category'; TableRelation = "Item Category"; trigger OnValidate() var ItemCategory: Record "Item Category"; ItemAttributeManagement: Codeunit "Item Attribute Management"; ParentCategory:…
-
How can we create a zip archive with several files in business central, wave 2, cloud extension?
I'm downloading four xml files generated in nav. I'm working with bc15. Does anyone know how to create a zip archive with several files in bc15 cloud extension?
-
Weird NAV2017 behaviour in XMLport with Reserve characters
In XML, the characters &, <, > and % are XML reserve characters, and is supposed to be "escaped". I observer different behaviors on the same version of NAV2017 10.0.30172, that some instance escapes XML reserved characters, and some instances do not. They are of the same version and build. What gives?
-
Remove Bulk Assembly Orders
A client is requesting the ability to remove bulk Assembly orders at once via selection. Would that be possible?
-
[RESOLVED] Job Queue times
I've been working with NAV for over 20 years but have little experience with setting up recurring Job Queue jobs. I'm running into an issue and am trying to understand how the different times should be set. Here's my current situation. I'm not sure why the Default Time Zones were set different.* Dynamics NAV is running as…
-
VS Code debugger not working suddenly
Good morning, Hope someone can help. I'm running a local container and suddenly the debugger session attach doesn't work. It just stays there. I've tried to debug using username and sessionID. I've tried disabling firewall just in case. Any ideas? thanks. [2024-12-12 11:36:36.14] Starting a debug session using launch…
-
Monitored field log entries is not working
I am making the change log setup by selecting some fields for the Vendor table (23) and marking it as Notfiy via the Monitored Fields Worksheet. Then when I make a change field on the Vendor card, records are created in the change log entries, but no records are created in the monitored field log entries. Could it be…
-
Change Log Entries on BC19
Hi, Are there any known weaknesses with the change log? I have a client that has indicated some fields are blank when they have completed them, these fields are set up to record in the change log. When I check the change log entries they fields have not been logged - apart from the correcting entries they keyed in later…
-
Issue with Postman Request to BC250: Error Using Client Credentials Grant Type
Hello everyone, I am currently facing an issue with my Postman request to a BC250 environment. Environment Details:* BC250: On-premises installation * ClientServicesCredentialType: AccessControlService * Authentication Setup: OpenID Connect with OAuth, successfully configured When using Postman with the Authorization Code…
-
BC14 RTC Service crash casually
Hi all, i need some advice from you regarding a particular situation we are in. Client - BC14 with RTC services (no web client) Until recently everything was fine, but for a few months now the service crashes sometimes casually, throwing all users out of production. Then the other services also crash in turn. Initially we…
-
Object of type Query with ID # could not be found.
Hi! I'am trying to publish 7 Queries (Object ID 70540-70546) of type API but I get the following error message as soon as the client opens up. The strange thing is that it is Query number two it complains about, deleting that one and publishing just ends up with an error for the next query. help with a solution or thoughts…
-
Code Unit used to check existing transaction while pos loading?
Hi, I am using Dynamics NAV 2018. Which code unit is checking the existing records available or not in pos transaction & pos trans line for a particular pos terminal while loading.
-
Identify Computer Client
In Business Central, Is there anyway we can identify on which computer the user log on (using web client)? The Idea is, I want to add some business processes when the user log on on certain computer (define by setup). Thanks.
-
Why does an Item standard cost change when Routing Line - Unit Cost Per change?
Hi there, We use standard cost for all inventory. The strange thing is that whenever there is a change in the ‘Unit Cost Per' of the routing line then the standard cost (Rolled-up Subcontracted Cost) changes as well right away. Is there way to prevent this from happening so the standard cost stays static? Thank you! Rudy
-
Regarding dimensions in sales Document(Sales order)
In business central When we give a dimension on salesHeader it automatically updates the dimension of salesLine , In which event or procedure has the code been written backend for this functionality????
-
How to copy existing attachments into a new document?
I have the procedure to duplicate an existing document into a new one, but I am unable to copy the attachments to the new document. I have done some tests, but some attachments are duplicated. What is the way to do this? OriginalDocAttach.SetRange("Table ID", 38); OriginalDocAttach.SetRange("No.",…
-
SecurityProtocol.Tls12
We made integration for one of our clients and everything was great 😊 But recently the integration stopped working, as it turned out on the other side they changed the Tls protocol. They changed 1.2 and added 1.3. NAV2017 - ServicePointManager.SecurityProtocol(SecurityProtocol.Tls12); The client's operating system is…
-
How to update Dimension set entry based on field value
How to update Dimension set entry based on field value Need to update the Dimension for corresponding sales order based on field value of sales order
-
NAV2018 Extensions OnPrem - Same field no.
Hello, I published two extensions for the same table (User Setup) with two separate additional fields, both using the same field number. No errors were initially given, but now, whenever I try to open the User Setup table or any tables related to it, NAV crashes. I have since renumbered the field numbers in both extensions…
-
FlowField not updating immediately in Purchase Header
I am trying to calculate the sum of the "Purchase Line Total Weight" from the Purchase Line table and display it in the Purchase Header using a FlowField. However, the FlowField only updates when I insert a new line or when I close and reopen the page. What I want to achieve is for the Purchase Header field to update…
-
Sales Order Item Assembly BOM
I've set up a simple BOM containing 2 items. When I add the parent item to a Sales Order, I'm not able to explode the BOM. It always reserves the entry and then gives an error saying you can't explode the BOM if the item is reserved. If I set the Reserve status to Never it's automatically changing it to Optional and then…
-
In business central I see that BLOB Data Type is being deprecated
In business central I see that BLOB Data Type is being deprecated in coming versions , How to use Media Data Type . Please provide me with code of how to write in table and page