-
Change field name in table
I need to change field name in custom table in BC OnPrem. ID remain same. When I try to install the new version of the app, the system tells me that removing a field is not allowed (even though the ID has remained the same). If I force the schema by synchronizing, the field is renamed, and the data remains in the table…
-
Help needed for research on Data migration
Hi, I am doing research on data migration with Dublin City University. If you're a consultant involved in data migration or a business user who implemented D365 Business Central please help me by filling the research survey. Thank you very much for your help…
-
ScreenDisplay Dialog Customization
Hi, I'm trying to customize the pop-up dialog in Microsoft Dynamics NAV 2018 - LS Retail POS. I've attempted to debug the session, but I'm unable to determine the specific profile it's using in the POS Panel. Could you please guide me on where I can modify this pop-up? ScreenDisplay(pText : Text[250]) IF PosType =…
-
OnPrem-to-SaaS Cloud Migration Tool
Hi, I am trying to run the Cloud Migration Tool. However, I am getting the following error for a bespoke table: "Could not get the target table count.;Some records failed to be copied, most likely due to mismatch in the source and destination table schemas. Please make sure that fields in your on-premise table do not…
-
Edit custom field on Sales Invoice Header easy way?
Hi All To edit a field I have to follow how MS done with codeunit 1409 "Sales Inv. Header - Edit" and special page (update) . I'm wondering if there is an easier way to create a field that can be edited from front or back end like in sales order
-
Event for on before entering sales line
Hi I have a requirement to check sales header fields entred before any line is inserted for example location on sale sheader bfore a user enters any lines. There is an event on the sales header - onBeforecreatesalesline but I cannot get it to work. Is there any better event or method to achieve this
-
Could not load file or assembly StreamJsonRpc
Happy new year to all. Today is my first day back from leave and I won an environment that doesn't allow users to connect. BC 25.1 - OnPrem When opening the web client, user is presented with: Event Log:Category: Microsoft.Dynamics.Framework.UI.WebBase.ClientExceptionStateProcessingStrategy
EventId: 0
ConnectionId:…
-
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…
-
Net Invoiced Quantity and ACIE
Dear All, I need some clariffication on Net invoiced qty in the item card and how it is releated to Adjust Cost item Entries. Today, I had an item having "NET INVOICED QTY" as -194. There were some Released production orders for that item. Then I have finished the production orders except for 10 Nos.i.e, I have 10 Nos…
-
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…
-
Freight, Item Charges and Expected Cost Posting
I'm working with Nav5.0 but this may apply to all versions that support expected cost posting and item charges. A company bases their selling price on a markup from acquisition cost. Part of this cost is freight. In the past they have had trouble with using an overhead rate for freight because is varies widely by product.…
-
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.
-
Can Dateformula calculate hours?
Do anyone know if it is possible to enhance dateformula fields to not only calculate days, weeks, months, etc., but also for it to calculate hours? E.g., Syntax: 12H, description 12 hours. Thanks in adavnce.