-
CANNOT DELETE FIELDS FROM TABLE EXTENSIONS (Onprem)
Leaving this here for those banging their head. You cannot delete table fields from table extensions in BC23 (cu0). The workaround is to change the field to flowfilter, build, then delete the field and build again
-
Upgrade to BC21 (OnPrem) - error when syncing TableMigration
Has anyone come across this issue below, all the tables cannot be located. I can see them in SQL. This occurs when syncing the table migration app (the empty one): - Task 14 of upgrade to BC21 Sync-NAVApp -ServerInstance $ServiceBC21 -Name "TableMigration" -Version 1.0.0.1 (this is the empty version) I then get the…
-
NAV 2016 Outlook Synchronization error with connection
Hello, I have a problem with synchronization between NAV 2016 and Outlook. When I press button Synchronize in outlook I get the error. Does anyone have any idea how to fix this? Thanks in advance!
-
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);…
-
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…
-
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…
-
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…
-
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…
-
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.
-
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?