-
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?
-
BC: Change fields displayed on pages
Hi I have difficulties changing the displayed fields: "No.", "Sell-To Customer Name" o Page ID 41 - "Sales Quote" How to hide any of those fields Thanks
-
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.
-
Methods of this automation are not listed in Navision.
Please Help Me I added the dll ( WinSCP for SFTP) to windows. I created a new automation. But the methods of this automaition are not listed. Don't see metod list.
-
The configuration could not be loaded.
I am having difficulty installing NAV Classic Client using a configuration file. I get the following error: The configuration could not be loaded. There is no other error message and the installation then continues as if no config file were designated. I want to use the config file for a remote installation.
-
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?
-
Cannot create an instance of the following .NET...Microsoft.Office.Interop.Excel Version=15.0.0.0
I have to use an excel file as a template, compile it and return it to the user. With previous versions (BC14) I took advantage of "Microsoft.Office.Interop.Excel.dll". With the BC 17 version, running the same report, I get this error: "Cannot create an instance of the following .NET Framework object: assembly…
-
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…
-
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…