NAV Three Tier

All versions starting from "7.0" - Only new technologies (RTC, Webservices, Reporting Services, Query, OData, ...) Use this forum to discuss topics related to RTC (Role Tailored Client), Reporting Services, Web Services. All new technologies which were introduced with NAV 2009 (SP1) can be discussed here, but NOT the classic client, native DB-server, NAS. Those topics belong to the general NAV/Navision Classic Client forum.

Uploading attachments in Bulk - Limitation
Brief; I am uploading files in bulk to our custom table's headers and I am getting the following error; Specs; Business Central (SaaS) Version: W1 18.4 (Platform 18.0.28593.30086 + Application 18.4.28601.29160) Details; I have created Header, Lines, and a table to store attachments. a)Manufacturing Job Header…
Procedure in SOAP webservice not present BC17
For an assignment, I'm trying to make a new SOAP webservice of a pageextension that shows a method of a codeunit in Business Central version 17. For this, I made a different SOAP webservice for the codeunit where the method is. According to the textbook, there should now be a line in the XML response of the webservice of…
cant delete company in BC 14 (upgraded from NAV 2015)
Hi All, I have upgraded Nav 2015 to BC 14 all feature is ok, user can open to this BC 14 but I cant delete company in BC 14 after around 30-45 seconds click delete company, then it will immediately closed. I tested using powershell also failed. any idea what happen? Thanks
Upgrade NAV to BC cloud
I have done some upgrades from different versions of NAV to Cloud BC (if going from 1 pre-RTC NAV version to another pre-RTC NAV version was difficult, upgrading from NAV to BC cloud is HELL! At least once in the BC cloud, upgrading has been smooth sailing). The last step is using the Microsoft Integration Runtime…
How to integrate PGP or WS_FTP in Nav 2013 R2 ?
Hi, I am exploring to encrypt and decrypt file in Nav 2013 R3 version by calling PGP or WS_FTP, does anyone manage to use either one this 2 program in NAV and it's work?
RDLC report - image in body of report does not increase with text
Hi, I need to insert an image that is added as background on the report, but the image is stretched to fill entire page. How should I insert an image that starts from footer and ends at the middle part of report? I tried to use rectangle and it does not work as expected. I placed rectangle1 and inside that rectangle I set…
Running Purchase Page 9307, the server was unable to process the request. The application will close
Hi, I'm having this issue for one user that happens to be a super user when running the purchase order list. Another super user is able to access that page without the error. I've deleted the pages from user metadata and also user page metadata. Regards & Thanks Roddy
Barcode font not showing in Report
I need to print labels containing the entry no. of a record. I followed this guide and in Report Builder, added a text field with the font "Code-39-Logitogo" displaying the encoded number. On the preview PDF, however, the code is in the default Arial font. I then found this article explaining that the instance of BC needs…
JSON Best Way to read them on Dynamics NAV
According to NAVTechDays 2017 Json Meets NAV thre are several ways to Read a JSON file I followed this article https://kauffmann.nl/2015/12/03/web-services-examples-part-2-verify-e-mail-address/ but my JSON has a more complex structure similar with the following example{ "firstName": "Oscar", "lastName": "Smith", "gender":…
Pass a value to codeunit from a page
Hi I'm getting the first baby steps in nav... I want to pass one value from Customer Card Page, No. for example, to a codeunit with a button, but without RUNMODAL. Can someone help me? thanks
What is an "NSRecord" ???
NAS is refusing to start and continuously advises the below, but what is an NS record ? or an NCLRecord ? Any help appreciated Server instance: LIVE_NAS Tenant ID: <ii>User: Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLRecordAlreadyExistsException SuppressMessage: False SuppressExceptionCreatedEvent: False…
how to add menu in BC?
Hi all, how to show menu in BC? I want to group all the pages from my extension
NAVHttp Client Request Failed
Hi Team, While processing an external API in Business Central SaaS Environment, I get the status code 0 and response "NavHttp Client Request Failed". But while I am calling same uri in Postman, I get a proper response and status code is 200. Can you please advise on this, Thank you for your help! Thank you for your help!…
How to inherit values in fields
Hi all, On Clients page I added three fields, field A is the main one, field B depends on field A and field C depends on field A and B, so if field A is empty if fields B and C have any value, it should be cleared automatically or if the selection of field B and C does not correspond to field A and they have information,…
HOW TO ALIGNN ROWS
How do i make a listing report from different tables (data item) appear on the same row? NB;The report has column groupings.Any clues?
Adding Worksheet in Home items
Hi All, I'm designing a Role Center page for Sales & Purchase department users. When i tag Worksheet page in Home items, it shows error as below. Is it possible to tag worksheet page in Role Center Home items .? or any solution for this? Microsoft Dynamics NAV Development EnvironmentAction 'Purchase Requisition', which is…
How do I validate fields?
Hi experts, In my Business Central cloud extension, I have made my own table and a matching page. I have 3 fields: - Code - Description - MyNumber (integer) The user must enter a value in all 3 fields and the field "MyNumber" must be between 1 and 99 and it must be unique. After the record is created, the user is not…
Collation - Report to display Slovakian characters where server code page is set to German
Hi All, What is the best solution to design the report that displays both languages (Slovakian and German) as expected? I have to have default language set to German on the server, since my HQ company is in Germany and a lot of software uses German characters. I have to create a report that displays text constants in…
report optimization
hello, when writing reports what is the better option in regards to optimization time and space to run reports - use rdlc hardcoded captions or labels?
Half year rule for fixed asset additions
Hello, I have several fixed asset cards where I need to record additions monthly. I need the additions to follow the half year convention/rule, while the original book value of the asset depreciates normally. Does anyone know how I can make this work? The half year rule works during the first year of the fixed asset card,…
NAV2009 RTC: URL parameters to open specific page with filters
Hi, I am using an URL to open a NAV2009 RTC page from a third party application. The syntax is like this: DynamicsNAV://MYSERVER:PORT/INSTANCE/CompanyName/runpage?page=9305 This works like a charm. However, I would like to send a filter on a specific Sell-to Customer No. in this url. I have found this syntax for newer NAV…
convert text to time type
hello nav experts, hwat is the best way to convert text to time currently using this, obviously not best, hence why I am asking TimeTxt := '90623'; EVALUATE(ToTime,COPYSTR(Timetext,1,6));
Migrate to Business Central on-premises from online
Hi All, In there any MS Blog regarding Migrate to Business Central on-premises from online. Also, can you suggest the best way to merge data of two Business Central online DB into one, apps are same on both the DB. Basically, a way out to "Export the Data" and "Import the Data" as we do in On-prim version to backup and…
Generating the encryption key with AL
Hello, how can I generate 256 bits sized encryption key with AL code? I need this for AES encryption.
Calling API from Dynamics 2016
In currently ruuning Dynamics 2016 and I would like to call an API, do you have any code or object to do it?
Read a JSON file within the projects in VS Code.
Hi all, Is it possible in Visual Studio Code to read a JSON file within the projects? Example: I got a Codeunit called ImportJSON under the Codeunit folder, and then I would like to use this Codeunit to read the xyz.json file (under JSON folder). Is it possible to read the JSON file? Thank you.
NAV2018 - not able to connect to NAV Server
Hi all I have 2 laptops freshly installed with NAV2018. Both laptops are the on the same network, both windows 10 pro. 1 can connect to NAV but the 2nd one cannot. Error when I open NAV2018 is - When trying to change the server, I got this error I have uninstalled and reinstalled on the 2nd laptop, copied the Config file…
Hii Guys, can anyone help me how can i filter Date only from date and time in reports
Thank you
Dynamics BC Online performance tuning
In "classic" NAV when there is a performance issue, say with a big transaction table e.g. "G/L Entry", I will run a SQL database query analyser, and find out what index key fields I need to add to GLEntry table. And this normally will address the problem. Until, some other usage trend comes along. Then I will rinse and…
Is it possible to display promoted actions on the navbar of the mobile BC client?
I need fast and clear access to an action for users on a mobile device. Is it possible to add a custom action to the navigation bar at the bottom of the screen? If not, is there some other way to make an action clearly visible and presentable without having to hide it behind a menu?

NAV Three Tier

Discussion List

Categories