-
Item where Inventory Value Zero = True, but Unit Cost has a value
So Inventory Value Zero is rightfully true, and the postings are as expected on the value entries side (zero cost being posted). I suspect that when the item was set-up, it was created with a manually defined Unit Cost. Now that ledger entries exist, I cannot change the Unit Cost. I cannot revalue the item either, as there…
-
Problem with "Word Handler"
Hello, At one of our customers, a single employee receives the following error message on his laptop when trying to create a Word document from NAV in the Version BC14 and Office 21 (sorry for the ridiculous size, but I really do NOT have the time to find out where to resize; in the MSDynamics-Forum it worked): The…
-
I can't complete the connection between the tables
HELLO! Can someone please advise on how to now link to the purchase invoice? How to complete this chain? SELECT * FROM [Training$Sales Invoice Header$437] AS sih LEFT JOIN [Training$Sales Invoice Line$437] AS sil ON sil.[Document No_] = sih.[No_] JOIN [Training$Value Entry$437] AS ve ON ve.[Document No_] = sih.[No_] AND…
-
Relationships between tables Purch_ Inv_ + Sales Inv
Please, help me. I need information on the sales invoice regarding quantity, price, etc., but in the report, I want to see the price at which the item was purchased, the currency used, and the purchase date. How can I track this or combine sales invoice and purchase invoice?
-
Hyperlink in NAV 2013 Web Client
Hi, I've searched everywhere but I can't find the solution for my problem. I want to create a PDF button that opens a specific PDF file. I have my PDF files in a specific server, the path is like: \\myserver\myfolder\myfile.pdf I'm using the Function Hyperlink and I can get the file with RTC but when I try to run the web…
-
Blob to Stream to Text Issue
Hello, When testing the following code for the first time, it successfully worked, but after a few attempts it began to give only empty blank messages. Could anyone tell me what could be the issue? Thank you. //minutes changed to hours for testing purposes FiveMinAgo := CURRENTDATETIME - (5 * 60 * 60 * 1000);…
-
Suggest Vendor Payments - skip payments that have already been exported
Hello, I'm using NAV 2016, I have a question about payment journals and the "Suggest Vendor Payments" action. When I export a payment and check "Mark as Exported" in the vendor ledger entries, the field called "Exported to Payment File" is not checked. Does anyone know if I'm going in the right direction and what exactly…
-
Calculate Depreciation Batch Job Error
I am trying to run the "calculate depreciation batch job" but getting error that " It was not possible to find a starting date in Accounting period". Note:- Accounting period is already created, FA accounting period is also created. How can I resolve this error???
-
How to insert multiple rows in a Business Central API with a single call?
I'm trying to insert a json with multiple records into Business Central via Web Services page 60000 "Sales Order Inserts MIM API"
{ PageType = API; SourceTable = "Sales Order Inserts MIM"; Caption = 'Sales Order Inserts MIM API'; EntitySetName = 'SalesOrderInserts'; EntityName = 'SalesOrderInsert'; APIPublisher =…
-
How can I reload current page with a temporary table records?
I'm in page "Assembly Orders" 902 trying to filter out some records and display only the assembly orders that the user is allowed. Basically, trying to populate a temporary table to reload the current page with the records of the temporary table: pageextension 60008 "Assembly Orders PL" extends "Assembly Orders"//902
{…
-
Reservation Entry table
Hello, please help me. There is a table called /reservation entry./ For some reason, I always see [Item Ledger Entry No_] as zero. I can't understand which table is best to join it to correctly track it to location and item? And what does positive 0 and 1 mean? Does 1 indicate the reserved quantity? And what is…
-
Connect Posted Approval Entry with G/L Registers
I have been struggling with this for a while now, Any help or suggestions would be highly appreciated. How can I connect Posted Approval Entry to G/L Registers Tables? I'm trying to add "Approver ID" to the G/L Registers page. From what I was able to find, the only field that has some sort of common information with the…
-
Error when trying to install Microsoft_System Application Test Library.app on BC22
I'm trying to get some unit tests going, so need to install the test libraries. I installed most (Any, Library Assert, Variable storage) without problems, but when trying to install System Application Test Library I get this error: The error message seems clear enough but the issue is that I have placed the dll files…
-
How to get name of database server in AL w/o dll usage?
Hi community, is there a way to determine the name of the sql database server in AL without using dlls? I need the database name which I should get from the active session, but I have no clue how to get the database server name - the active session only carries the name of the BC server. Thanks in advance and best regards…
-
Implementation and upgrade - Business central (BC)
Please connect us.
-
Finance and accounting USA
Hi, has anybody done any NAV implementation in USA. Finance and accounting in USA are totally different then in EU and UK, especially if the nature of business is construction services. I'll get my hands on standard NAV version with USA localization, but I'd really appreciate for any practical experiences. Thank you BR…
-
is it possible to modify the "Correct Dimension" functionality in BC 22
Hi All, As we know the "Correct Dimension" functionality is working only G/L entries. but one of customer wants to also change the related Customer Ledger Entry, Detail Customer Ledger Entry and Posted Invoice or Posted Credit Memo. is it possible? thanks Advance
-
enable / disable options on report request page
Hi, I want to enable or disable options on a report request page regarding to values coming from record objet, the fact is this options are only handled in OnIntReport trigger and in this stage the record objects are not yet loaded. please to help me to perform this task. This is the options i' m talking about :
-
Values are not shown in RDLC Report
Hello, It seems to be very simple, but for some reason that I don't know, the values of the variables are not shown in the report. The process enters the condition and assigns value to the variables, in fact I added a Message so that it would be displayed on the screen, which it does. Variables:…
-
Different db, tier and client versions possible?
Hi All, I have a Nav 2017 CU14 instance that we are migrating to new kit. Due to complex nature of our customisations, we can't upgrade the DB. Can we still upgrade the service tiers and/or the client pc applications to newer versions while leaving the DB unchanged? Seen something a while back about upgrading the schema…
-
Attribute 'processPath' is required
Has anybody come across this, and knows how to fix it? I've just installed the new BC24 on my local machine. Just a clean installation without specifying anything. But when I try to run the site from the IIS, I get an error saying that localhost can't handle the request. Looking in the event log, it's just a simple error…
-
Find the Codeunit of a button in LS Retail
I'm developing some changes for a client whose system is a NAV11 with the LS Retail app installed. I need to change the behaviour for some buttons, and I'm looking for a way to guess which is the codeunit associated to a button. For example, I have this button in the POS, and I can do right clic and choose some options,…
-
Relationships between tables Purch_ Inv_ Line + Item Ledger Entry
Hello! I'm having trouble with two questions, please help: 1. How to find relationships between tables? How to join them? Purch_ Inv_ Header + Purch_ Inv_ Line + Item Ledger Entry I am joining them on document_no But for some reason, not all Purch_ Inv entries are appearing in the Item Ledger Entry Documents in Purch_ Inv…
-
NAV 2013 R2 - Absolute Drop-Dead Date
Hi All, I know it's a vague question, but I'm trying to draw a line under the "we absolutely positively MUST be off NAV 2013 R2 by.." conversation. We've passed 'out of extended support', and the sky hasn't fallen. What's the 'next thing that will kill us'? Assuming we want to remain reasonably current on hardware/OS; is…
-
Production Order Component - Unit Cost
Good day, We use standard cost and the unit cost for some of the items of the production order component lines is $0. These components (purchased items) have a standard cost in the item card. Does anyone know where it is getting the unit cost of the items in the production order component lines? Thank you, Rudy
-
Dynamics NAV (on-prem) to Infor WMS (cloud) integration
Has anyone integrated Dynamics NAV to Infor WMS? We're looking at the possibility of doing this and was wondering how other people have done it.
-
O Data URL - From Dynamics NAV 2018 to Business Central-
Our company will update from Dymanics NAV 2018 to Business Central. Currently we import in excel several Queries from O Data URL. After the system changes I need to change all sources with the new URL for each query. My question is : Will it work? Or tables , formats and contents will be different? In that case it will…
-
Publishing Extension from VS Code for BC 2024 wave 1
Hello experts. I recently updated my environment to BC 2024 wave 1 and I am having a weird error when publishing from VS Code. Can someone help me fix this because I am just publishing the sample extension provided in AL: Go! Here's the error message: The request for path…
-
Power BI Hyperlink to NAV Page
I'm trying to allow our Power BI users quick access to pages in NAV 2013 from a hyperlink in a table, the same as if there is a shortcut on a desktop; e.g. dynamicsnav://navserver:portnumber/service/company/runpage?page=42&$filter=%27No.%27%20IS%20%27SO-107070%27 However, even though the power bi field data category is Web…
-
Open page with new record
Hi, I am working on a Nav 2009 3 tier environment. I have a list page and two card pages CardA and CardB. Based on the value of some column, the system needs to open either CardA or CardB. First question: Is it possible to overrule the double click action? So when the user double clicks, it opens PageA or PageB ? Second…