-
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…
-
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…
-
Business Central Upgrade V21 to V24
Hi I need to upgrade a V21 on prem database to V24 CU2 onPrem I have around 20 extensions with various levels of dependency. I am using a PowerShell script that interrogates all the extensions which have been placed in a folder, builds a dependency tree then installs and publishes the extensions in least dependency order.…
-
Error When Publishing to a BC Docker Environment
Hi, I am encontering a strange error when trying to publish to a local Docker environment. Does anyone know what this means? Please note: * I have published other .app files, in the same way, to the same Docker, without error. * The .app file is functional. I have published it, successfully, to another Docker. Thanks in…
-
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…
-
Cost Amount Actual (ACY) Remaining Balance
Hello Folks, I have a situation where there are some items with 0 inventory and sum all cost amount actual is also 0 but there is a balance of Cost Amount Actual (ACY). basically, what happened is these items are very old and were zeroed before the company started using ACY.