-
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.
-
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.
-
NAV 2009 - Where to find the original Microsoft documentation?
My employer wants to buy a book for me to help with learning the native functionality of NAV 2009 classic client. I've been looking at the book "Microsoft Dynamics NAV 2009 Application Design" by Marije Brummel and I'm only looking at the preview's from Amazon/Google so I can only see a limited number of pages but at the…
-
Passing a Var to a Codeunit
I am trying to pass a page variable from the page onqueryclose to the codeunit. I am running the code unit from an action, in the codeunit I run IF PAGE.RUNMODAL(50324,T50037) = ACTION::LookupOK THEN MESSAGE('%1',SEapprovalCommentField); Pretty much opens a page with an extra box to type in and I want to send whatever you…
-
Identify Computer Client
In Business Central, Is there anyway we can identify on which computer the user log on (using web client)? The Idea is, I want to add some business processes when the user log on on certain computer (define by setup). Thanks.
-
nav 5.0 SP1 standard db
Hi all, I need nav5.0 sp1 standard db. Someone, please, share your precious \:D/ . Amaraa
-
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????
-
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…