Questions tagged [dynamics-nav-2016]

Dynamics NAV is an enterprise resource planning (ERP) development platform produced by Microsoft. Use this tag for issues that are specific for Dynamics NAV 2016.

Dynamics NAV, formerly Navision, is an enterprise resource planning (ERP) development platform produced by Microsoft.

This tag is specific for issues related Microsoft Dynamics 2016. For more general issues related to Microsoft Dynamics use tag .


Useful links


Related tags

32 questions
3
votes
1 answer

What are Dynamics NAV licensing requirements for Web Services?

This post refers to SOAP and OData Web Services in Dynamics NAV 2016 (or later) and hopefully it is not off-topic. I would like to know whether the following facts are true or false (or it depends). Given Starter Pack functionality, and default…
2
votes
1 answer

How to Delete records using Odata Dynamics NAV 2017 web services

I was developed a php application that connects to Microsoft Dynamics NAV 2017 OData Web Services, I can read (GET), and create (POST) with no problems,but for delete I receive the error 405, Microsoft say that it is possible to delete…
colo
  • 185
  • 1
  • 1
  • 10
2
votes
1 answer

Error with upgrade codeunit when changing table's PK length

I have table A-Z. Table A has PK of ID, and all other tables has fields that relates to TableA's ID. I'm being tasked to do code cleanup, and I need to change the TableA's ID from length 30 to 20. I have done for other table B-Z, together with the…
Farid
  • 872
  • 1
  • 13
  • 30
1
vote
2 answers

Adding a Tracking Spec Line through AL Code?

I am trying to add Tracking Spec entry through code; rec_trackingspec.init(); if rec_trackingspec2.FindLast() then …
1
vote
2 answers

How to take user input using C/AL in NAV 2016?

Suppose I want to write a simple addition program using C/AL in NAV 2016. How can I dynamically ask user to enter the two numbers? In Microsoft Dynamics AX we use "dialog" class for this purpose. I need some code reference or the description to…
1
vote
1 answer

Random "The destination file has an extension that may be blocked" on JobTask export

I have an inherited problem with Navision 2016 ODATA web service I use in my application. Normally it works well, but randomly (1 per 100 runs aprox.) it faults with the following stack log: Server instance: NAV Tenant ID: User: Type:…
Sergey
  • 1,332
  • 2
  • 18
  • 30
1
vote
2 answers

How to refresh Dynamics NAV cache from SQL?

I would like to know if somebody knows how Dynamics NAV cache works. I'm really a beginner of NAV, but I tested this: If I update or delete (not insert) a row in a table by SQL, NAV doesn't update its internal cache and sometimes refreshing its…
Tobia
  • 9,165
  • 28
  • 114
  • 219
1
vote
2 answers

Is there a way to pull vendor creation date in Dynamics NAV 2016?

The business has a request for auditing to pull a list of all newly created vendors in NAV 2016 for a given period. I was unable to locate an entry creation date or added date for the vendor table. Is this possible? I'm currently supplying the…
1
vote
1 answer

Creating new entities from PHP using the Microsoft Dynamics NAV 2016's Odata web services

As part of an integration project, I need a PHP website to be able to both read from and write to Microsoft Dynamics NAV 2016's Odata services. I found that fetching a list of existing customers from PHP is as simple as this : $ch = curl_init();…
John Slegers
  • 45,213
  • 22
  • 199
  • 169
0
votes
1 answer

Exception from HRESULT: 0x800A01A8 Dynamic Navision 2016

I wrote a code where user filters a source number from the table, the code get the source number and open an Excel file with the same number in a folder, write other data into the file and then save to temp folder. The program worked for some of the…
0
votes
0 answers

SQL Query to Get all User access information from NAV 2018

we are using NAV 2018 source. I am SQL developer, where I want all users information related to Roles, Groups, Access levels for auditing purposes. I have the following tables. But the result I am getting it's huge. Around 10 million records, which…
RBK4YOU
  • 13
  • 4
0
votes
1 answer

Automated Testing set up for BCsandbox

I am trying to set up an envoirnment to start developing test app for the app I developed. My app was developed on BC on prem (locally, not a docker container) and since all the resources I found on the internet says to use testtoolkit you need a…
0
votes
1 answer

Single Report - Multiple Designs in NAV 2016?

Is it possible to create multiple designs for a single report in NAV 2016? If yes than how this can be achieved.
0
votes
1 answer

How to add fields from different source table in a page (NAV 2016)?

I want to add fields from Table - "Customer Bank Account" in Page - "Bank Receipt Journal" which has a current source table as "Gen. Journal Line". It might be helpful if I get to the know the process for adding fields as a lookup from different…
0
votes
1 answer

How we can perform CRUD and Join operations using C/AL in NAV 2016?

Currently I am working on NAV 2016. I came across some C/AL functions to Insert, Delete, Modify data from the table after retrieving them statically. I want to know is there any use of SQL statement in C/AL to perform CRUD and join operations or we…
1
2 3