-
PageNo in Reportbody
Hi, does anybody know a solution to get the page number in the body section? (NAV2018 RDLC Reports) Thank you.
-
[BC15] How to check entire (long) SQL statement in Visual Studio Code
Hello everyone, I can't check entire SQL statement and I'm thinking it's a bug, but I'm not sure. I want to see entire SQL statement like this: So I try to copy value: When I paste clipboard I see this: The same result I get when I use add to watch: This is probably caused by the same "variable name" because it is always…
-
How to configure Role Center based on the user's department?
Hi friends, [Version: NAV 2018] Requirement: When a user from Sales department opens NAV, then he should open only Sales related stuffs. What I did? 1. Created AD groups based on the departments say Sales, Purchase etc., (Each AD group contains one or more users.) 2. Users group added in Users (in NAV 2018), and selected…
-
Dynamics BC Webclient https can access but http not accessible
Dear Friends Recently i faced one issue while configure godaddy certificate, able to connect the webclient by https using domain name. But unable to connect by http using domain name or public ip. http can be accessible using localhost and local ip. I clear browser cache and added to trusted site. This can be accessible…
-
Business Central: Direct Printing attachments
Hey, I am fairly new with AL/Business Central and have a question regarding printing. Our company has a system in which you can add attachments to an order. These attachments used to be txt, xlsx and docx or pdf. Now we managed to get it to work that when you send an email these items will be send using the in-and…
-
Missing COGS account message
Hi We are on Dynamics 365 US version, 14.6 ON PREM. We enter a resource on a sales line and get a warning saying that COGS is missing from General Posting Setup. We could easily set an account there, but our client does not want to if it's not necessary. The issue is some of the users do NOT get that message when entering…
-
RDCL mismatch pages between Word and PDF
Hello, I have a problem with a custom report. The customer wants to print 4 labels on a label printer. I created a report with the dataset and a RDLC layout. Everything is fine so far. When I print the report as PDF, I got 4 pages. But when I print the report as a Word document, I only got 2 pages. Each page has 2 labels…
-
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?