-
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…
-
How to Generate .XLF file for Caption Translation from NAV 2018?
Hello, i want to try Microsoft's new LCS Translation Service, but it requires to me upload .xlf files to proceed. I could not find how to acquire proper .xlf file from NAV 2018. I can get all the ENU captions from Development Environment-->Translate Export but i do now know how to convert that .txt file .xlf file in order…
-
Error while converting BC14 to BC21
Hello Experts, I have trouble converting my BC14-OnPrem-DB (only CAL-Code) to BC21-OnPrem. When I try to publish the "BASE Application" from Microsoft I get the following error: PS C:\WINDOWS\system32> publish-navapp bc210 -path "T:\Microsoft_Base Application.app" -SkipVerification publish-navapp : Extension compilation…
-
BC creates strange date filters
In an environment we get a strange filter when we use a filter shortcut. When entering Y, we get the year 2023 to 2024. When entering P1, 01.01.23..31.01.23 appears. We could not find a setting to correct this. Do you know what the problem is?
-
Dropdown field width
Is there any way to customize or handle wide fields in the drop down list ? Have a client that made their no series very wide... so the fill number isn't visible on the drop down window. Would love to make the 1st column wider.. but not sure its possible ?
-
Posted No. Series
Hello everyone. we use dynamics BC14 and we have a requirement to have different posted sales invoice no series than the originally defined one in sales & receivable setup. we can do this manually buy changing the posting no. series in the sales invoice, but we are looking to automate it by validating the no series…
-
Changes to record cannot be saved because some information on the page is not up-to-date
When i try to change the unit of measure code in the sales line it always throws me this error and i dont know how to fix it?
-
How to configure the system so that invoices are sent in XML format?
I know that this should be done via the Electronic Document Format (363) site. Unfortunately, I don't know how to go about it. The instructions on Microsoft's website are very complicated.
-
How to handle the visible property of an actiongroup
hello, i need help to handle the visible property of an actiongroup in a role center, i created a boolean variable and then when i try to assign a false value i receive an error message : No trigger code is allowed on page of type Role Center. Thank you
-
Can I forcefully remove tenant app?
I have been asked to update a BC13 database to cloud. Going therough the motions, it stops already at trying to uninstall-navapp as there seems to be some remnant of an old app registered as a tenant app. At least it says Scope: Tenant. The customer runs an OnPrem solution as a singletenant, so there are no tenants where…
-
How can FINDSET fail after NOT ISEMPTY
I've been seeing a very weird issue in our BC14 CU19 code where the following fails: [...]
IF NOT ItemAnalysisView2.ISEMPTY THEN BEGIN ItemAnalysisView2.LOCKTABLE; ItemAnalysisView2.FINDSET(TRUE, TRUE); [...]
END; ItemAnalysisView2.FINDSET(TRUE, TRUE); fails with the error that no record has been found within the filter.…