Questions tagged [navision]

Navision is the former name of Dynamics NAV, an enterprise resource planning (ERP) development platform produced by Microsoft.

Navision is the former name of Dynamics NAV, an enterprise resource planning (ERP) development platform produced by Microsoft.

Dynamics NAV uses a proprietary programming language called C/AL, which is syntactically similar to Pascal. The C/AL runtime provides constructs for interacting with database records, files and the host environment. Runtime functionality can be extended using COM and .NET.

The early versions (from 3, 4 to 2009) were called Navision, while the later versions (from 2013 to 2017) are called Dynamics NAV.


Useful links


Related tags

427 questions
1
vote
3 answers

DIfference between Navision DB and SQL Server DB

I am new to Navision application.Can you please explain the difference between Navision DB and Sql Server DB?
Monish
  • 11
  • 1
  • 2
1
vote
1 answer

How can I loop only the page records from the selected one to the latest?

I'm trying to loop all records displayed in a page, from the selected one to the end of the rows: For example here, as I'm selecting only the 5th row it will loop through 5th and 6th row (as there are no more rows below) What I've been trying is…
1
vote
1 answer

Test Automation in business central

I am trying to create a test automation project for my business central app (version 21). But I am unable to reference test libraries in the project. I followed the manual, installed business central ver.21 sandbox on docker, however I am unable to…
1
vote
3 answers

How can I find all my available objects in my NAV license?

Microsoft Dynamics NAV 2018 I'm trying to create objects with this customer license: I should have space for new objects as license says... but how I can find which object ids are available for each object type? This is what I get when trying to…
kuhi
  • 531
  • 5
  • 23
1
vote
0 answers

how to implement scheduler in auto hosted windows service

i want to add timer that will import excel or csv file in navision at the end of the month the code is done only thing left is to add timer but i could not find any solution. using WorkHoursImporterWinService; IHost host =…
1
vote
1 answer

Incorrect syntax near '' in vba code for sql

I'm getting this error because try to put Itemnr2 variable as cell value. If I use plain value like in ItemNr1 all works. But I need to use value from cell because it will change time to time so don't want change code every time. How can I put value…
user17682095
1
vote
1 answer

Python: CREATE TABLE permission denied in database 'master'

I am trying to get the Field no from NAV using the approach i found…
1
vote
2 answers

Com Interop w/ MSXML

I'm trying to COM interop w/ Navision through a .Net assembly - and specifically using MSXML interfaces. This leads to the following error message: The assembly "C:\Users\bra\Documents\Visual Studio…
Bent Rasmussen
  • 5,538
  • 9
  • 44
  • 63
1
vote
0 answers

Connecting to Microsoft Dynamics NAV using Python

I have a project where I need to pull data from an NAV server, I found only this https://www.cdata.com/drivers/dynamicsnav/python/ for reference. I also somewhere this snippet but was unable to use it. import pandas import matplotlib.pyplot as…
1
vote
1 answer

HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header received from the server was 'Negotiate oX...=='

I've just changed a webservice reference from using a local network IP to a domain and started receiveing the following: Error: System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication…
El_Shaddai
  • 23
  • 1
  • 7
1
vote
0 answers

Find next not null value for specific product code based on dates

I am trying for some time to create a query that would give the value of stock for a specific item on each date within a given date range. Tables are as they are (NAVISION) and we can not influence structure so we have to use what we have. The…
1
vote
0 answers

Navision / Shopify SKU

I've around 19.000 products/variants in Shopify. All the 19.000 variants i've created in Shopify have no SKUs. I've created all variants in Navision with unique SKUs and now I need to add the SKUs from NAV to the 19.000 variants in Shopify. The…
1
vote
1 answer

Multiple table relation in one table field (Dynamics NAV)

I have created some field with table relationship property in Dynamics NAV. Now I need to create a field that has several table relationships based on different conditions. Could you tell me how to do this? it´s possible?
JMarR
  • 55
  • 7
1
vote
1 answer

How to migrate Navision Microsoft Dynamics report to SQL

I have access to the Navision SQL Server database and the corresponding Microsoft Dynamics NAV interface. I want to migrate the 'Aged Acc. Receivable DII' report. Once I select the report and go to Tools > Designer I can see the 'DataItem' list,…
Selrac
  • 2,203
  • 9
  • 41
  • 84
1
vote
1 answer

Connect to Navision Database

I need to connect to a .fdb file (Navision database file 2009) through C#. Can anyone explain how can I connect to this file using ODBC/NODBC? I have tried these links but found nothing…
MUT
  • 576
  • 3
  • 18