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
2
votes
1 answer

Read the xml response received from navison and bind the response in mvc model and display in table

I need to access an url and get the xml response (tags contain colon in it) and bind the response in model class and display it in an html table. So far I have accessed the url,read the xml and my problem is I am not able to bind the data in my…
Lukog
  • 21
  • 5
2
votes
0 answers

Creating both sales header and sales lines in one call i NAV OData REST API

What we want to do We want to create both a sales header and the corresponding sales lines in one API call. How we're trying to do it To do this we're trying to do a deep insert as specified in the OData spec. Example POST…
Jacob Rastad
  • 1,153
  • 10
  • 24
2
votes
1 answer

How to access odata that produced by Nav webservice into html layout using PHP

I try to get odata produced by a navision webservice. When I directly access the url given using chrome browser, the page asks for user name and password and then chrome shows xml data as expected. But when i use a PHP script, it always returns…
Budi Utomo
  • 21
  • 3
2
votes
3 answers

Is it possible to do the Navision 5.0 export to Word/Excel to OpenOffice.org?

Navision 5.0 includes a feature to export to Word or Excel. Is it possible to make this work with OpenOffice.org Writer or Calc instead? If so, what has to be done to set it up? I have been told by my Navision reseller that the feature works best…
Randy Orrison
  • 1,259
  • 2
  • 15
  • 14
2
votes
1 answer

Sending commands to Navision SOAP Service

I try to send commands to a Navision web service. To understand the whole connection as best as I can, I want to use at first simple cURL commands. I experiemented with simple GET Requests on the URL https://IP:PORT/.../Codeunit/Webservices. There I…
mgluesenkamp
  • 529
  • 6
  • 19
2
votes
2 answers

SQL error - Incorrect syntax near the keyword 'Database'

I want to detect databases beginning with 'NAV'in a MS SQL DB. I tried it with this code: DECLARE @DBName NVARCHAR(MAX); SET @DBName = (SELECT name FROM master.dbo.sysdatabases where name LIKE '%NAV%'); EXECUTE ('USE' + @DBName); But I got the…
WIbadeneralp
  • 71
  • 2
  • 8
2
votes
1 answer

Is possible do Select * form DynamicValue to perform a query like this in Navision?

Is possible do Select * form DynamicValue to perform a query like this in Navision? Thanks in advance
Tabutnas
  • 35
  • 6
2
votes
3 answers

.NET HTTP Client download PDF with HTML FORM POST

Bit of a .NET problem here as I am not a .NET programmer. I use Navision :) I am using Navision to connect to a Webservice that returns a PDF. The code I am using is below. HttpClient := HttpClient.HttpClient(); SubmitData :=…
2
votes
1 answer

Display picture in page from different recordset in Dynamics NAV 2009

I'd like to display a picture, that is saved as a blob, on a page that not binds the record. I created a field in Table 79 of type BLOB and subtype BitMap. Then I added the field TestPicture on Page 1 to actually insert an image manually. It gets…
Ello
  • 907
  • 1
  • 15
  • 33
2
votes
1 answer

How to SQL join payments with invoices in NAV Dynamics (former Navision)

The question is about SQL fiddling in Dynamics Nav tables, especially the table [$Vendor Ledger Entry]. How to link each payment to appropriate invoices. The aim is to get [External Document No_] and [Amount] of the invoice. One payment can be…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
2
votes
2 answers

How much time will it take to develop MS Dynamics NAV integration using XML files

I got new assignment in my workplace to integrate NAV 4.0 system with third party system using XML files. Integration will be based on XML file creation and storage of those files in predefined directories (i.e. it has to be a non-web-service…
2
votes
2 answers

Dynamics Nav (Navision) webservice ReadMultiple date filter

Using the Navision webservices, how can you filter by a date. i.e. Within a SalesHeader table there is an "ExportedDate". I would like to find all SalesHeaders where the ExportedDate has not been set or were exported on a particular date. It seems…
Billy
  • 21
  • 1
  • 3
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
2
votes
1 answer

How to change user department in Navision 2009 (role tailored)

How can i change users deparments in Microsoft Dynamics NAV RoleTailored Client, say i want to put myself in the [Purchase] department. Please help.
Zee99
  • 1,194
  • 2
  • 23
  • 46
2
votes
1 answer

PHP SOAP request to navision webservice

For days I've been struggling to get a connection between a PHP webshop and a navision server with NTLM authentication. Now that the connection and authentication is done, I'm having problems with doing a correct request. For this example I try to…
Frank Soeters
  • 33
  • 1
  • 8
1
2
3
28 29