-
Creating Sales Order Lines gets error "Standard Code Text does not exist...."
Hello, I exposed page Sales Order (id 36) as web service, I'm following some guides to create Sales Order Header and Sales Order Lines, the Header can be created successfully, but the Sales Lines always get error "Standard Code Text does not exist..." SOWS.Sales_Order_VS_Service testcreateSO = new…
-
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.
-
In standard NAV, is approving an Approval Request supposed to send an email to the requestor?
Hi Can't quite figure out this one, so decided it's easier to ask the community! Looking at the code in Codeunit 439 "Approvals Management", function ApproveApprovalRequest(), I don't think it is programmed to do it. Anyone here able to confirm or otherwise?
-
'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…
-
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…
-
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…
-
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
-
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…
-
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…
-
Having trouble moving to AL with an unsual database
So I'm doing work with a client that had previously decided they didn't want anything to do with extensions so someone before me literally removed everything from the Nav App table. Without some form of the base application existing in the database, Application symbols aren't generated no matter what I've tried and I'm not…
-
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.
-
BC 14 Cumulative Update Issue
ello everyone, i am doing BC14 Cumulative update from CU 16 to CU23. It is only platform update. When I try to convert database then I am getting below error 1 and is not able to proceed. SQL Server is Azure managed instance and I am trying make database single user from within Business Central and using SQL Query but get…
-
upgrade from BE 3.70A to latest online Dynamics 365 Business Central version
Hi all, I want to upgrade our current Microsoft Business Solutions Navision BE 3.70A (4.0 SP3) to the latest online BC. Our 3.70 version is practically standard. Who can assist me? What are the steps to take? Do there exist scripts for this?
-
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;…
-
Downolad file from SharePoint
Hi All, I am trying to download file from SharePoint Online to NAV 365 BC 130 and if run following code I get an error. Upload file to SharePoint works fine but download file not. Please, Does anyone have experience with this, or could someone advise what is wrong and how to fix it? I'm really helpless now :( Thanks a lot,…
-
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…
-
How to overwrite/change Danish OIOUBL extension?
I'm working on Business Central version 13.11 (13.0.35820.0) on-premise. Most of the code is C/SIDE but some is in extensions. I need to make some changes to the Danish OIOUBL extension that exports an XML file. Is it possible to get the code and make changes there or overwrite their extension with my own? (I need their…
-
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.
-
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…
-
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,…
-
Solved: Opening Item Card Page 30 non-editable depending on user-rights
Hello, one of our customers has had the article card changed in version R2 in the Nav so that it can be edited or not depending on a code in the user equipment. This is ultimately possible with a simple CurrForm.EDITABLE ( identifier from the user setup ). Unfortunately, this does not work in the NAV 2018; You can open the…
-
Flowing Custom field from Sales Documents to Value Entries
I have 2 custom fields made on the headers of Sales Order, Sales Invoice, Sales Credit Memo, Posted Sales Credit Memo, and Posted Sales Invoice. And they are also on lines as a flowfield Lookup just in case I want to refer to them on the line in any future customization (saves time going finding header). The fields are;…
-
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…
-
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…
-
Logout session using ACS login and Windows Client
Hi, does anyone know, where the windows client store the session token while logging in via access control service? We have the problem that the user cannot log out once he has successfully logged in via ACS Login. There does not seem to be a logout function. The client never ask again for credentials before the token is…
-
D365BC multiple companies to one CRM
Can a D365BC with multiple companies be connected to one D365 CRM
-
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…