-
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…
-
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?
-
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…
-
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????
-
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.
-
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
-
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.",…
-
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…
-
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…
-
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…
-
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…
-
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
-
How to Prevent Deletion Of Sales Order - Only if by end user?
I'm trying to impement an event driven validation to prevent SO deletion however it also block base app deleting sales order after invoicing. How do I exclude system deleting? The event:[EventSubscriber(ObjectType::Table, Database::"Sales Header", 'OnBeforeDeleteEvent', '', false, false)] local procedure OnBeforeDelete(var…
-
Copy Word layout in Business Central
Hi experts, In Business Central cloud, our customer has a Word layout in report 1306. Is it possible to copy this layout into a new Word file that can be used for report 1303? Hope you can help. Morten
-
Malaysia MyInvois Certificate Signature
Hi All, I am using cloud BC. by the way , does anyone know how to generate certificate signature in Myinvois Malaysia? https://sdk.myinvois.hasil.gov.my/signature/#document-signed-data i saw someone share for other language https://github.com/mokth/einvoice/blob/main/Step to Generate Signature (updated ).pdf but not sure…
-
I want Code Snippet for
SO , i am extending standard purchase order report and i added three columns 1.SalesorderName 2.SalesorderEmail 3.SalesorderPhoneNo. Now into these columns i want the data to be flowed from "SalesPeople/Purchaser" Base table. In purchase order card page there is an action called dimension which is linked to "Dimension set…
-
Odd SETRANGE and Boolean behavior
I came across an odd behavior with SETRANGE and booleans and I can't figure it out. I have 2 boolean filters that when run don't do anything. All records are returned. When I add the 3rd SETRANGE below (for testing) it then works as expected. I've tried using SETFILTER as well with no luck.…
-
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…
-
Sales Header record cannot be saved because some information on the page is not up-to-date. PostCode
Hi All I'm trying to find a way use the shipto address postcode to lookup a custom table to get the dimensions. The post code field doesnot trigger OnAfterValidate. So I use below event subscriber{ [EventSubscriber(ObjectType::Table, Database::"Sales Header", OnAfterLookupShipToPostCode, '', false, false)] local procedure…
-
Upgrade from v14 to v25 error
I'm currently trying to upgrade one of our older databases from v14 to v25 using the MS cookbook and I ended up with following error in Task 17 during the upgrade of Microsoft Base Application v25: Could not upgrade the extension 'Base Application' by 'Microsoft' from version '14.0.0.0' to '25.0.23364.25445' for tenant…
-
Error while Financially Voiding a Check in BC23.1 On-premise
Recently one client of us migrated from NAV2017 to BC23.1 On-premise version. In the new System they tried to financially void a check for one of its vendor, but could not do it due to an error. The error is due to New Code and New Field in BC. In BC they have introduced a new field "Posting Group" in "Detailed Vendor…
-
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…
-
Non Calendar Month Accounting Periods
Hi Guys Has anyone implemented non calendar month accounting periods like 5-4-4 or any config where start and end date does not fall month start/end? What are the gotchas and considerations? I looked at the accounting periods table and it does not have a field for the month as a unique identifier which means reporting is a…
-
BC Upgrade from v14 to v22
Hi All, I am doing BC upgrade on premise v14 to v22. but during this step Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15 AU\Applications\System Application\Source\Microsoft_System Application.app" Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15…
-
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 =…
-
Javascript Error Handling in BC21 control addin (on prem)
Hi, (I accidentally posted this question in Dynamics CRM, maybe here is a better place to get replies.) i am developing a control addin in BC21 on prem (Version 21.0.46384.46844), which is running Javascript internally. My problem is, whenever an error occurs inside the Javascript, like a "TypeError: Cannot read properties…
-
Best method to Add field validation in BC SaaS
Hi, There are 2 ways to add a validation trigger to an existing field in BC. 1) Subscriber codeunit that subscribes to the table OnAfterValidate Event 2) A TableExtension that Modifies the field OnAfterValidate trigger Which is best and what is the pros and cons of each method? All this while I have been using the…
-
Accounting series 4 to 5 characters
Hello, The customer accounting series currently has 4 digits, with a maximum of 9999. This range has become insufficient, and we would like to expand it to 99999. What process should I follow to modify the series so that all customers have the same numbering?