-
Regarding Performance issue
Hi I have Written a code Line in the OnAction on the page object, In the second case I have commented the Object and created the Codeunit, Will there be any performance Related Issue. Which is the suggestable method of writing the code.
-
Regarding customer number and balance.
Hi, I have created a card which has customer number and balance. When we select customer number then we need to get the balance of the customer. By default it is taking first customer and giving the balance. But when we select other customers then it is showing an error. Can anyone suggest on this.
-
Setting up a Control AddIn as a DotNet Variable in a codeunit, is it possible?
I am testing the TinyMCEEditor Control AddIn (https://github.com/navaddins/TinyMCEEditor-AL) and I have done some modifications, so that I can have several configuration settings (i.e. Inside NAV Mail Client Page should be differently set up as a Requestpage of different reports, etc.). I am trying to make it as easy as…
-
Regarding sales order post/cust.ledger entry
Hi, I want to create two fields in sales header and sales line and i need to transfer it to customer ledger entry can anyone help me the flow of table in microsoft dynamics. please suggest how the data is transferred from sales header and sales line to customer ledger entry table by codeunit.
-
Time limit for permission recorder?
Hello everyone. I'm close to starting to define clear and concise permission sets in our NAV 2015 install. Up until now the company hasn't placed any emphasis on tracking/controlling the necessary permissions so i'm basically starting from scratch. I would like to use the recorder to capture the necessary permissions of a…
-
Customer/Vendor Invoice Load
Hi all, what is the best way to load open customer/vendor invoices into the system prior to Go-Live?
-
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…
-
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;…