-
SQL Server Database Growth Under Business Central 14 / NAV 2018
Hi, We converted our sql server database to 14.0.3391.2, then we did a NAV upgrade from NAV 2016 to BC14/NAV 2018. Now, our database size is increasing much faster than it did before. In addition, our differential backup is increasing at 5 or 10 times the rate it did before. Has anyone noted this condition? Does BC14 tend…
-
Staying with classic NAV
We are on the NAV 2009 R2, SQL, Classic client. And we are perfectly happy with it. With the customization we've done over the years, it's an very practical tool for our users. But not being current on the enhancement plan means we can not purchase new granules or objects. And recently we are trying to implement a mobile…
-
CUE : Pass param to page
Hello, I have a lot of sales cue in my Navision. All these cues have Page Sales Order List in the Drilldown Option, so that the Sales Order List opens when I click on a cue. In my Sales Order List, I have a lot of actions. I want to enable or not those actions in the Sales Order List regarding the selected sales cue.…
-
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…
-
Append Body with MailMessage - Body longer than 1024 characters
We are using NAVISION 2009 R2. Our partner have modified the way NAV sends SMTP emails, thus we are now sending mail via a new CodeUnit using the DotNet variable MailMessage: 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.Mail.MailMessage In this CU, our partner created a AppendBody…
-
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…
-
How do I get the Control Add-in Drag and Drop to work ?
I have the MS Dynamics 365 BC running on the server and the drag and drop feature isn't showing or working (shown on attached imaged) but on having the same company run on the local machine win 10 the feature is available and works. Anyone know how I can get this to work?
-
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?
-
Basic v Advanced Inventory & Warehouse
Hi all, can anyone help with the above, I want to see what the difference is between both?
-
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…
-
Is there a forum for Business Central
Hi, Is there a forum for Business Central? I have a BC14/NAV 2018 question. Thanks!
-
Can't update profile
I have tried to update my profile fields (like email address - it is out-of-date), but after several attempts with various browsers, it always comes back to the original settings. When I edit the fields I am at this URL: https://mibuso.com/account/user-profile And when I click save the fields revert back to the original…
-
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…