-
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…
-
Item Charge Assignment
Hi all, We all know how to do Item Charge Assignment from a purchase order/invoice. However, I have a different scenario with a customer, where the customer wish to assign charges a different way. My customer receives a statement from Customs when the items has been controlled at port. First 1 month later my customer…
-
Dissertation Help
Hi everyone, I am currently doing my Msc Dissertation and I would have been very interested to relate my topic to Microsoft Navision, but the problem is that I should prove whatever I am recommending in my thesis i.e implement whatever is suggested. Therefore I got lost and I do not know which topic to choose and where to…
-
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?
-
Enabling Item tracking line in Item Reclassification Journal
Hello Everyone, I would like to enable item tracking lines in the Item Reclassification Journal batch to track items, but I’ve noticed that the standard functionality only allows tracking for the "Item" type. If I proceed with customizing the system to allow item tracking for other types, could there be any concerns with…
-
Make a Phone Call using URL
Version : DYNAMICS NAV 2009 R2 - 6.00.32012 - Not using RTC Client Hi, I want to make a basic phone call using URL. Wether it opens the navigator or not doesn't matter. The way I think could be possible is to call this type of URL :tel:+33102030405 When I type this in my navigator, it opens my default phone app, so this…
-
Upgrade BC14 to BC19: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX)
Hi, I'm getting "Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong" when running Sync-NAVApp as follows: - I'm upgrading a modified base app to a modified base app + extension. I've been able to track the error in the event log but as it stops and reports each table individually it is…
-
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…