-
BC in Remote app (AVD) focus problem: new pages windows appear minimized
Hi, We are moving an installation (BC14 on premises) from Citrix to using AVD remote desktop app. During the testing, one of the users has reported that in some screens when he opens a record (for example, if he tries to open a purchase invoice from the purchase invoice list), the new page opens in a separate window as it…
-
How to have new Source Documents(Warehouse Request) Fields flow from Sales Header?
Hi Nav noob here, and I simply am at a loss as to how the Source Documents Page/Warehouse Request Table is populating. I need to have some fields on a Sales Order appear on the Source Documents page as new custom fields but can't understand the data flow of how Codeunit 5752 (Get Source Doc. Outbound) is populating…
-
Report with barcode - export to excel error
If I export the report to excel (Send to / Microsoft Excel Document (data and layout)) then the qr code will be ugly and unusable: How could I fix this? Preview or sending to PDF/Word works just fine. Thanks
-
Upgrade error BC18 to BC23 Table Sales & Receivables Setup
I am running into an error when upgrading BC18.6 to BC23.3 when executing: Start-NAVAppDataUpgrade -ServerInstance $NewBcServerInstance -Name "Base Application" -Version $NewVersion Event log mentions an error with table ‘Sales & Receivables Setup’: 'The target table 'CLNL_BC230_TEST.dbo.COMPANYNAME$Sales & Receivables…
-
Getting Error in HTTP Post Request in NAV 2016
Hello! I am trying to make an http post request with content type = 'application/x-www-form-urlencoded' but it's giving the Bad Request error. On postman the same request is working fine. Please have a look at my code below and suggest what i am doing wrong. GetAccessToken(var AccessToken): Boolean CLEAR(ContentTxt);…
-
The call to member SuretaxserviceRequest failed. mscorlib - Nav 2009
I am currently running Microsoft Dynamics Nav 2009 v US Dyanmics 6.0 and was running (2) different RDP servers for users to access, then open Navision. After retiring ONE of those RDP servers and setting up a new RDP server with Navision installed, any time I have a user try to verify an address in Navision on the new…
-
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…