-
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????
-
I am customizing a cue on Roll Center Page. will it get refreshed each time how does it work
I am customizing a cue on Roll Center Page. will it get refreshed each time how does it work I am associating a conditional statement on how color should change based on data so any leads on this?
-
NAV 2009 R2 - Classic Client - Adding Table Boxes On Reports?
I'll preface this with the fact that I have basically zero knowledge of NAV but I'm fluent in C#/SQL Server/SSRS/Power BI. We are using NAV 2009 R2 (classic client) and we have a custom report that we use for generating Bills of Lading. One issue with the report is that it is designed with many textboxes using hardcoded…
-
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
-
installation BC on prem
aktuelle BC version
-
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…
-
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…
-
Points system
I have noticed that when your answer is being chosen as an accepted answer to a question by user who has asked the question, you do not get any point. I am not after points here , I just like to help and answer the questions but I think will be fair to get a point if your answer has been chosen as accepted answer. What…
-
Invalid user after BC upgrade (configurations not modified) [BC20 to BC24]
Hi all, i had a BC20 OnPrem envinronment with Windows Authentication that used Kerberos. I upgraded it to BC24 keeping the same configurations (also for Kerberos) but now i cannot sign in to the web client because BC tell me that my user is an invalid user. I am sure that the upgrade was succesfull because if i change the…
-
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
-
How to find all references (or occurrences) of a certain field in the code of an .app
I'm working with the .app LS Retail, it's open source (but readonly) so I can click in the .app file in Visual Studio Code and navigate through all its code files (tables, extensions, codeunits...). Let's say I'm working with a certain field of a table extension, and I need to know how this file is used in the .app, so I'd…
-
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…
-
How to change the the InnerText of an XMLNode
I am replicating some old business central code and I'm trying to find the updated methods for the old DotNet variables. How can I correct the Inner Text assignation.
-
Convert CaptionML to new syntax.
Hi all, Is there any way (tool) to convert existing CaptionML syntax CaptionML = ENU = 'Caption in ENU', DE = 'Caption in DE'; to new syntax Caption + translation in xlf file. I have lots of *.al files with translation in ML but in future "The multilanguage syntax is being deprecated. Please update to the new syntax.", new…
-
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.…
-
CODEUNIT 1854 : MS - SALES FORECAST NOTIFIER
hello guys. the debugger point me to the object with error. but when I search the Said codeunit, it doesn't show me anything. I mean the Codeunit does not exist in my current database. Codeunit 1854 (please see attached Photo)
-
Adjust Cost Post to G/L Posting Date Issue
Dear NAV Expert; I'm desperately seeking for solution. My client system NAV 2009 (R1) All Items Costing Method setup as Average Adjust cost Post to G/L setup to run every night (Nav Job Queue) The issue is, user have posted Negetive Inventory Adjustment on March 2023, on the same night Cost Adjustment was partilly posted…
-
How do we migrate Table Extension from older extension to V23 ?
Hi All, does anyone know how to migrate from Table extension version 22 (or before) to version 23 ? Thanks.
-
Statical Prism for C/AL 3.2.0 Community Edition (CE)
Statical Prism 1.0.3 Community Edition (CE) Prism is an intuitive and interactive C/AL code viewer with both "go-to declaration" and "find usages" functionality. The user can open an object text file (exported from Dynamics NAV) and begin browsing the code in a very readable format with search features. Prism processes a…
-
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…
-
Business Central
Hi, We are doing a project and would like to ask to questions 1. Is there any functionality or add ins that will allow a process flow of approving a vendor invoice to post the invoice and the payment once approved 2. Is there any workflows or setups that you can do to setup a workflow to go to an approver, if the approver…
-
[BC24] Trouble with advanced Deep Insert using an API page
Hello all, I had this customer requirement to implement in BC24 OnCloud: Create a new sales order + sales lines using the same API call. This works and the response returns all the information that was created successfully (Both information about the Header and the lines). I used the REST API URL to deep insert this…
-
Changing Posting Date to Work Date during posting
hello all, Is there any setting that can overwrite the posting date to Work date at the time of posting sales invoice? issue is when sales order is shipped,(setting on sales & receivables for Default posting Date is 'No Date'), user enter the posting date but if finance user post the invoice for that Order and forget to…
-
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…