-
How to rename a primary key
I'm trying to rename a primary key in a table by creating a new batch report. For instance, the original name of the first Entry No. is 10, I want to make it 1. Can anyone help me how to achieve that? Thanks in advance.
-
'Record' Entry No. '1000' does not exist.
Hi I'm trying to get Entry No. (The only Primary Key) in a table and divide each one of them by 10 due to a memory issue as Entry No. reached the limit of 32 bits I created a report and I wrote the following code as the screenshot below The first record is 10000 so by dividing it by 10 it should be 1000. But when I'm…
-
Devide Existing entry Nos by 10
Hi everyone, I'm trying to divide all the EXISTING Entry Nos by 10 as it reached the maximum limit(The range for 32bits is 2,147,483,648). So by dividing all the existing Entry No. and by changing the incrementation from 10,000 to 1000, I would extend how many more lines I can add, which is about 10x. My question is how…
-
Enum Question
Hello, Hypothetically, I have a table (50000) with 20 different enums on it (fields numbered 50001..50020 using enums numbered 70001..70019) I am trying to add a flow field to a different table so that that when I validate 50002 on this table it would lookup somewhere and give me the 'object no.' of the enum (70002) that…
-
Dimension on gain and loss currency account
Dear all, is it possible to insert a mandatory value dimension code on a gain or loss account and make it mandatory when BC365 automatically post the gain or the loss on that account?
-
Sales Invoice Report
Hello How can do to sorting By Id Dimensi code value using RDL report sales invoice , it's means to replease Item with ID dimension Value and grouping all sales invoice line between the same value to 1 line and qutantity must be calculated it . thank you
-
Is this the most stupid thing in AL coding?
Well, I've been pulling my hair out trying to figure out how to pass a parameter to a code unit and the way NAV/BC does this is not intuitive at all. here's an example from Github https://github.com/microsoft/AL/issues/3845 Quote "Teaching AL development to an experienced outside developer is an many aspects interesting.…
-
Start-NavDataUpgrade during upgrade to v17/18 - how to detec when it is finished?
I am running upgrade to V17 according to this MS guideline Upgrading Customized C/AL Application to Microsoft Base Application Version 17 . Everything is fine but... Task 10 point 1 when I run Start-NavDataUpgrade is asynchronous :( In next point they say: "To view the progress of the data upgrade, you can run…
-
Nav 2016 CU 28 - Development Environment Crashes
Hello NAV 2016 CU28 crashes when I try to open Menusuite 1090 "Dept - Company". I was able to open it in Design mode until Added 1 Simple report in menu suite. Application: finsql.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info:…
-
Record insert stops after first error - and GETLASTERRORTEXT
Hi Guys I have been trying to insert a batch of records (quotes copied to orders) using a codeunit and see if anyone can help. This is just a proof of concept and if it works I want to import an excel file to a user table and run similar code to create orders. In a nutshell, what I want is the system to continue after the…
-
NAV client crashes without any error message
Hi All, our customer has some strange issue that NAV 2013 R2 client crashes for unknown reason. I think the issue is with Page: "Interaction Log Entries" because it is opened from Page: "Contact List" where filtering is set on Table: "Interaction Log Entry", so page: Interaction Log Entries is opened with set filters as…
-
How do service workers see what jobs they should work on?
Hi Guys, I have a customer who has some 20 service engineers visiting customers every day to perform service on different equipment. But how would a service engineer get an overview of the service orders he needs to go to? For example, have not been able to find a calendar that would give a service engineers an overview of…
-
BC14 CU16 Web Client Stops Working
Client is using BC14 CU16 Platform CU11 Application. Web Client stops working with error (picture 1) and event viewer is recorded as picture 2. Any help or suggestion is appriciated.
-
NAV 2017 connection to Dynamics 365 (CRM) just stopped working
Hi all, not sure if anything has changed in the last day or two but our connection from NAV2017 to Dynamics 365 has stopped working. It's been working fine for a few years and just stopped working yesterday. The error we get when we try the 'test connection' is "Unable to login to Dynamics CRM". I have checked the login…
-
How can I add a keyboard shortcut to buttons in Business Central cloud?
Hi experts, I have made an extension for Business Central cloud. I would like to add a shortcut key to the "Print Confirmatiton" on the sales order page, but when I try to add the shortcut key "Shift-Ctrl-B", it shows or removes the favourites toolbar in Google Chrome, that I use, when I press it. As I understand…
-
BC - Handling Software Sales
Was wondering how people manage software sales? For example, a business buys and sells software from 3rd parties. It does not develop it in-house. Within the Item, there is a "Type" which allows "Service" and "Non-Inventory". This to me appears to be designed for software companies which develop their own software, not…
-
OCR error when modify Vendor, how to fix this ?
Does anyone know how to fix this error? I have commented on all codes in a trigger OnModify of Vendor table but still got this error.
-
Insert(true) vs Insert() - Using TRUE what's the difference and use cases
Hi Guys I have seen both codes where some people use for Insert and Modify: true. Apparently from what I understand true invokes triggers but what I don't understand is when to use and when not to. For example, creating new order standard code is below, what's the benefit of true here on Insert/Modify?: SalesHeader.INIT;…
-
IIF instead of IF on standard RDLC reports
Hi, does anyone know if there is a reason why IIF expression is used instead of IF expression on standard RDLC reports? E.g.: The difference between these two is that "IIF is a function and evaluates all of its arguments prior to returning a value, while IF is an operator that executes like a short-circuiting conditional,…
-
How to configure a workflow for two different approval limits with the same users?
Hi Friends, [Version: NAV 2018] There are 4 users who are approvers of a workflow. User01 (Approval limit: 5000) User02 (Approval limit: 10000) User03 (Approval limit: 15000) User04 (Approval limit: 20000) The above users are defined a Workflow User Group with sequence no. and same WUG is assigned in its corresponding…
-
How to use Data Exchange Definition for Generic Import?
Hi, I have created a Data Exchange Definition (DED) for importing a file into a General Journal. The DED is of type "Generic Import". How do I use my definition for importing my file? See image above: In the General Journal there is an action "Import Payroll File" which imports a file using the DED defined in "Payroll…
-
Requestpagehandler cannot address variables in report extension requestpage
Hi there, We have created a report extension on "Create Reminders": - added two variables to the request page - added some code to the OnPostReport() trigger For automated testing purposes, I now want to use this report in a test codeunit: fill these two variables from code and then proceed with OK. My expectation was that…
-
Delete user ID from "user page list"
Hi people, On BC 14 (c/al still on premises) i am trying to delete a user from the list. It doesn't allow me me to saying the following error: "Microsoft Dynamics 365 Business Central The user "XXXXX" cannot be deleted because the user has been logged on to the system. To deactivate a user, set the user's state to…
-
EventViewer Warning: ResultSetEnumerator and FieldLoadInfo
Hi, recently (after updating from BC 13 to BC 17) we’ve had lots of Warning in our EventViewer which has me stumped and trying to find answers via web-search has practically zero hits. The Warnings are thus: “Message Invalidation of ResultSetEnumerator on record with id: X because of updating the FieldLoadInfo on the…
-
D365BC multiple companies to one CRM
Can a D365BC with multiple companies be connected to one D365 CRM
-
Posted Sales invoice Line Insert Field - which trigger
Hi All I have created an UDF on posted sales invoice line table to record total shipped quantity on each line (from sales shipment line table). Trying to update this field via a code unit and not sure which code unit and trigger to use. Someone else mentioned to use OnAfterInitFromSalesLine but could not find it on…
-
Date in Json array
Hi, Can anyone give me some advice regarding Google Chats Calendar Charts. In this connection you must have a Json array with the date and a number value like this: [new Date (2012, 3, 13), 37032] How to make this Json array element? Thank in advance PRLI
-
Download Location for Report add-in for Visual Web Developer Express 2008 - Any ideas??
Hello, I have been tasked with looking at some RDLC reports from NAV2009R2 but, although I have managed to download and install VS Web developer Edition 2008 for the life of me I cannot find a valid download link for Report add-in for Visual Web Developer Express 2008.. Can anyone point me in the right direction please??…
-
LinkedObjecs in BC14
We are in the process of upgrading NAV2009 to on-prem BC14 and we came across a problem with LinkedObject tables. We have a number of such tables that we use to read data from other databases. Although the table property LinkedInTtransation is set to No, when we run the table in BC we get an error that "....linked server…
-
Automated Testing for BC365
Hello :) Good day. Is there any applications for automated testing for BC365 ? and where can I get it too? thanks and God Bless :) Regards, Jhan