Stack Overflow
Stack Overflow

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

C# - OdbcDataAdapter.Update() results in Syntax Error

I'm writing a program with C# to automatically insert data in a Navision database via ODBC. I am filling a DataTable-object by calling the OdbcDataAdapter.Fill() method. After changing some values, I want to update the original DB using…
tubu
  • 11
  • 2
1
vote
1 answer

How to check recref.field(Integer) is empty or exists in Navision Development ( C/ALL )?

RecRef is datatype of RecRef, and by this i access to table and can select the field of the table; RecRef.OPEN(IDTABLE); RecRef.field(2); // RETURN THE FIELD DATA OF THE IDTABLE. but if this is empty navision send error so; How to check if…
Tabutnas
  • 35
  • 6
1
vote
1 answer

fixing and understanding an error in a very simple Navision dataport

Can someone please tell me why my code would error out on CU 5402 UOM Mgmt, specifically at the Item.Testfield("No.) line under GetQtyPerUnitofMeasure function? Below is my code to import 6 columns of data:…
WSNoob
  • 33
  • 8
1
vote
1 answer

how to convert png to bmp for using dynamic navision?

I want to upload the bmp image in Dynamic Navision 2009 classic . I have png format images and need to convert as bmp. conversion of image is working only if i use MS paint/Photoshop tools. Same way i want convert the png image using Image magic or…
padh
  • 95
  • 1
  • 3
  • 14
1
vote
2 answers

Calling C/AL function FROM .NET component

As per title, I'm trying to call some C/AL function from .NET - is this possible at all? I'm using NAV2017.
Farid
  • 872
  • 1
  • 13
  • 30
1
vote
1 answer

Convert from C/AL object to JSON

As per title, is there any way to convert from C/AL object to JSON object? If I'm not mistaken, some of the data types in C/AL can be converted straight to .NET object (string, int, etc) but I'm not sure which types are / are not. I'm looking to…
Farid
  • 872
  • 1
  • 13
  • 30
1
vote
1 answer

Decimal separator Navision Xmlport

Is it possible to force any numerical value exported from an xmlport to a certain custom format, regardless of regional settings? For example, 120.25 (US) will export as 120,25?
WSNoob
  • 33
  • 8
1
vote
0 answers

How can I select only certain columns in Microsoft Dynamics Nav 2016 Web Services w/PHP?

I'm using PHP to connect to Microsoft Dynamics Nav (Navision) Web Services 2016. Authentication (NTLM) is working fine, and I can get data. So far I'm testing the Item page and the Item List page. I can easily filter which items I want to retrieve,…
Mike Willis
  • 1,493
  • 15
  • 30
1
vote
1 answer

Check if startdate is greater then enddate

I want to compare two dates. I triied like this: SetDates(Rec, StartDate2, EndDate2, Regelkorting); BOMB.RESET; BOMB.SETRANGE(StartDate2,StartDate2); IF BOMB.FINDFIRST THEN BEGIN IF BOMB.StartDate2 > BOMB.EndDate2 THEN BEGIN ERROR('startdatum kan…
SavantCode
  • 131
  • 2
  • 4
  • 14
1
vote
2 answers

Running a codeunit by reference in Navision

I have a codeunit that has the Production Order Line table as the source and the On Run trigger shows these two lines of code: ProdOrderLine.GET(Status,'xxxx',10000); ExecuteFunction(ProorderLine); The XXXX represents the Production Order No. but…
WSNoob
  • 33
  • 8
1
vote
1 answer

How to skip function in navsion 2009

I have a function where you can add articles. AND I have a date range. But if it is not in date range, I want to skip this function(table 36): FncCheckBOM(Description : Text[30]) LocRecSalesLine.SETRANGE("Document Type", Rec."Document…
SavantCode
  • 131
  • 2
  • 4
  • 14
1
vote
1 answer

OData : AddQueryOptions for POST operation

Is there anyway to do the same thing as AddQueryOptions but when doing a POST through a OData web service? For exemple: var first = ctx.JobGLJournal.AddQueryOptions("tenant", "fr").First(); The POST url also need this "tenant" but I can't find any…
01000001 01010011
  • 71
  • 1
  • 8
1
vote
2 answers

Creating Orders in Microsoft Dynamics NAV via web services or an API

I am tasked with creating an API that would allow 3rd party customers the ability to send orders into our Microsoft Dynamics NAV 5.0 SP1. I want to be able to create a SalesOrder in Dynamics NAV not with the client but via an API so i can allow a…
Paul Smith
  • 11
  • 1
  • 2
1
vote
1 answer

Guest Login to Microsoft Dynamics NAV ERP

I am a newbie to NAV and I want to see how NAV standard tables (Item,Customer...) and Columns look like. I dont don't want to install the software now. Is there any way to get a online guest login for NAV ERP? FYI, I have SQL SERVER 2012 installed…
techrhl
  • 434
  • 8
  • 19
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
1 2 3
…
28 29