-
NAV 2016 - Debugger crashed when try to debug a session
Hi I am facing an issue on our NAV 2016 version. Each time we want to debug a session on a specific break point the debugger crash and throw the following message: The Server 'instanceName' was unable to process the request. The application will close. Hence both the RTC and the debugger crash. Note that only the debugger…
-
What is the best way to get the count of selected records when a list page closes
I'm guessing it has something to do with Marks, but I find them confusing and have not found a comprehensive example of how to use them. For purposes of discussion, let's say the list page had 25 records and the user selected 5. How would I accomplish getting the 5 selected keys for further processing. Thanks! As an aside,…
-
Adding new AD user as NAV user automatically [WS?]
Hello, I have this issue where I need to add new NAV user when new user is added to AD. Have anyone done something like this before or you have some clues how to approach this kind of issue? Would that be even possible?
-
Coding standards
Hi all, I'm interested if anyone has either read any coding standard documentation (I've checked the NAV coding guidelines), found any references in any "Clean Code" documents, training, videos or blogs, etc. to state that either one of the following examples is "better". Certainly one is more "compact", but in a more…
-
How do I download symbols for Business Central on-premise?
Hi experts, Our customer uses Business Central version 13.11 op-premise. (13.0.35820.0.) When I log on the NAV-server, I cannot download symbols in Visual Studio Code, even though I am on the same server as BC. I get this output: [2020-03-25 10:30:50.25] Using reference symbols cache path:…
-
UTF-8BOM to UTF-8
hI, I am calling a Xmlport in a report to get the output via job queue: Code in Report: ILE.RESET; ILE.SETRANGE("Posting Date",TODAY-1); ILE.SETRANGE("Entry Type",ILE."Entry Type"::Purchase); ILE.SETRANGE("Document Type",ILE."Document Type"::"Purchase Receipt"); IF ILE.FINDFIRST THEN BEGIN Xmlp.CREATE('E:\ERP\' +…
-
[Business Central 15] How to check publisher parameters
Hi everyone, I've question about checking publisher parameters. For me it don't make sense, so I probably do something wrong. For example: When I create subscriber for OnResolveTextFilterToken publisher (Codeunit "Filter Tokens", BC15) I don't know how to check it's parameters: 1) IntelliSense in Visual Studio Code doesn't…
-
NavContainerHelper Extensions folder location
Hi, Is there a way to change the location of the NavContainerHelper/Extensions folder? It's currently on the C: drive and we would like to move it to the E: drive where the Docker containers are kept. Thanks -Julie
-
How to change To Approve and Details value in Approval Entries page during sent approval Request?
Dear All, I want to flow customise value (To Approve and Details) in the Approval Entries page on the time of sent approval request. I want to show Document Type+ OrderNo+ Status+Vendor No. & Name in the To Approve field. and In details I want to show Vendor Address. For your reference please see below attached screenshot.
-
How to colorize lines in the report?
I have the report "Employee - Vendor" connection and I need to mark lines where "Employee Name" <> "Vendor Name" by another color. Does anybody know how I can do it? May be it can be done by report layout?
-
How to run NAV2018 Job Queue in specific service?
Hi, We are upgrading from nav2013 to nav2018, and in nav2018 we cannot find NAS setting to run Job Queue in specific service, does anyone advise on this issue?
-
copy data from one location to another?
hi expert's I need some help in on issue. i want copy data from one table to another three table header Table line Table copytable Header Table have added one field amend of type option optionstring pending approved we created from Header and line table Document Page & on click of action when amend::approved then line…
-
How to Invoice Ressource for time spend for a customer - Consultant Activities company only
Hi, I have'nt find out how to deal with this need : I have consultant ( Ressource ) , how spend time working for different client in the TMA ( Tierce Maintenance Application ) contexte . So we have a contract for each client , for exemple , any hour spend helping you will be charge for 100 Dollards. Ok, great. So all the…
-
Unable to connect to server using Dynamics NAV mobile app
Hello all, I have successfully installed Microsoft Dynamics NAV 2016 and also web client (http://localhost:8081/DynamicsNAV90/WebClient) on my computer. Now, I want to use this URL for web client on the Dynamics NAV App that I have downloaded from PlayStore. When trying to add 'http://computername:8081/DynamicsNAV90' as…
-
Can I implement Business Central NAV using its any existing Codeunits or Procudures?
Given a date, return an array of last 13 months. Example 1, given date is 10th of April 2020 (10/04/2020) Array Returned with 01/04/2020 10/04/2020 01/03/2020 31/03/2020 01/02/2020 29/02/2020 01/01/2020 31/01/2020 ....... 01/04/2019 30/04/2019 Example 2, given date is 18th of Feb 2018 (18/02/2018) Array Returned with…
-
HttpWebRequest Cookies
Hello, I am currently in the process of building an interface to Shopify. With my POST request it is important that no cookies are passed, because Shopify blocks this in my case. In Postman you can see this nicely. With cookies it does not work, without it works without problems. But in my code I do not have any cookies…
-
Totaling with dimensions - Financial Reporting
I'm re-doing a dimension setup right now, but I think I'm going to have to get a bit creative for some of my reporting (or at least to make it as easy as possible for the end user). Essentially, this dimension represents two things: A business unit and a cost center. Yes, we could theoretically have two separate dimensions…
-
Arabic Letter convert to Junk when importing Translation File(Business Central 14.0.4114-On Premise)
When i am trying to import the Translation file from development environment by going to Tools->Translate->Import. The caption in the translation file is in Arabic but when i import them it changes to Junk characters. I have changed the System Locale to Arabic. This problem happens in the Windows Server 2012R2. The same…
-
how create chart on three fields on PARTICULAR Field (record)
how create chart on three fields on PARTICULAR Field (record) on table record. example I have three fields, estimated cost, Usage cost, estimated revenue, billed
-
How to use Custom Report Layout in Extension Development
Hi, we are currently preparing our solution in Micorosoft Dynamics NAV 2018 for a BC 14 AL convertion. One problem we are facing is our usage of the ImportLayout, ExportLayout, UpdateLayout and CopyRecord methods from table Custom Report Layout. These methods are not supported in extension development.action(ImportLayout)…
-
"G/L Total-Balance" in BC16 gone?
I could not find "G/L Total-Balance" in BC16. Any Ideas which report this is now? or why did they delete it? BTW we "upgraded" the current customer app in BC16 and from that I could start the "old" report?! I'm a little bit confused.
-
Making changes to a table that is included in SQL Replication
We have a NAV 2016 database, on SQL 2016 Enterprise, and we may be adding a (normal) field to a table. The table is included in (transactional) SQL Replication. We know that there are SQL commands to make changes to replicated tables, but can these be used with Dynamics NAV?…
-
The table definition is invalid and cannot be validated.
I've opened an NAV 2013 database in an NAV 2013 R2 and it was succesfully converted. Now I'm trying to import the R2-objects in the converted database. I'm receiving the following message "The table definition is invalid and cannot be validated.". Anybody else encountered this?
-
Upload data from BC150 to SaaS
Good morning all. I am trying to upload my data from a BC150 to SaaS with all the tools that BC has. But I can not. I have some errors when trying to conect from SaaS to my local BBDD in SQL. By the look of things it is because of the server and DDBB. I use this format: SQLSERVERNAME\DATABASENAME and the diferent process…
-
How to Create Sales Lines in Test CodeUnit
Hi All We're and end user developing some of our own extensions, so we can't use the test tool or test libraries. I need to write tests that insert lines (which will update other items based on an event subscription) I got as far as opening the sales order in edit mode (hard-coding the sales order no for now), but I'm…
-
Blog Series Part 1: Customer Requirement for AL Development MSDYN365BC
Hi Reader, Lets take a deep dive into AL and consider customer requirement.We will develop the functionality using Vs Code as an Extension for Microsoft Dynamics 365 Business Central.Lets consider this example as this capture all object types. Pre-requisites Download Microsoft Dynamics Business Central (on-prem) or you…
-
FILE CREATE
I try to use "File.CREATE(FileName)" instruction in RTC but same code work in FORM not in page.. Why this?
-
Data synchronization with user feedback
Hello, On BC cloud I have to build a synchronization between companies. To keep it simple let's just say I have a Customer record that needs to be replicated in the other company that is triggered by an action "Sync". The tricky part is that this should tell the user whether it was successful or failed with an error…
-
Problem with printing large word documents
I have a problem with NAV 2018 and large word documents, build with it's own word layout. My customers wants to print about 5'000 pages from a report with word layout. The report runs a long time until the client crashes. There are only one small jpeg in the layout. Is it possible to print such large documents from NAV? Or…
-
Fail in running NAV BC on Prem & CRM on Prem integration
Hi all, Have an installation of Dyn CRM on Prem and BC 13 on Prem and I'm trying to configure the connection between the two of them to replicate data from one to the other. I'm configuring the D365 Connection Setup with user pass and everything goes through well, the standard table/field mappings are created, jobs are…