Stack Overflow
Stack Overflow

Questions tagged [dynamics-nav]

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

Dynamics NAV, formerly Navision, is 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.

Useful links

Version-specific tags

Other related tags

371 questions
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
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

Ready-made Dynamics NAV 2009 web services for integration with e-commerce system?

I'm planning to integrate our e-commerce module with Navision. I know you can set up and configure web services in NAV 2009, but I'm not familiar with Navision, and would like a more out-of-the-box solution, that we can quickly set-up for other…
Vidar Langberget
  • 143
  • 6
1
vote
3 answers

SETFILTER w WildCards Not Working as Expected

I have been trying to get Setfilter with wildcards working properly but i don't know why it isnt. SETFILTER(Description,'*@%1*',"Assembly Header"."No."); The filter does not work and does not display anything, probably because NAV is not…
Jonathan Lam
  • 1,237
  • 3
  • 20
  • 49
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
vote
5 answers

Deadlocks occur more often in a two-tier architecture or in a three-tier architecture? And why?

I am working with Microsoft Navision 2009 and a lot of times, if for example you make a new order, and change something later on the records, then often occurred that you will get a message: Another user has changed the records and you cant do…
InfinityGoesAround
  • 1,011
  • 4
  • 17
  • 31
1
vote
2 answers

How to add contacts to customer

I try to add contacts to a customer, like this: WHILE (LoopCount <> 0) DO BEGIN KlantContact.GET(FirstContact); KlantContact.VALIDATE(KlantContact."Company No.", BussinesContactName."Contact No."); //'44241'; …
InfinityGoesAround
  • 1,011
  • 4
  • 17
  • 31
1
vote
1 answer

Pass value in a Variable

I want to pass the value of 1 of my columns in my SELECT statements in a Variable. Here's my sample code: DECLARE @TotalExpense DECIMAL(18,2) SELECT a.[Posting Date] AS [Check Date], a.[Document No_] AS [Check Number], a.[Vendor No_], …
Marc
  • 11
  • 3
1
vote
1 answer

Dynamics NAV - SQL Server Report Builder - CommandText property has not been initialized

I would like to start by describing what I am trying to do. I am working in Dynamics NAV 2015 attempting to create a custom report layout using Microsoft SQL Server Report Builder. The way it works is I am in NAV, I choose a custom report, and then…
user3779582
  • 17
  • 5
1
vote
2 answers

Export methods from Navision Dynamics 5.0 to datawarehouse/OLAP purposes?

I'm using Navision Dynamics 5.0 and need to export all the financial data into my datawarehouse on a regular basis (1 time daily). And therefore I don't want to use csv-files as exporting method. Which other methods are normally used? This must be a…
MOLAP
  • 784
  • 4
  • 13
  • 28
1
vote
2 answers

SQL Filter Out Specific Month, Day, and Time for Any Year

Microsoft Dynamics NAV uses the datetime of yyyy-12-31 23:59:59.000 to identify yearly closing entries. I am trying to write a report that will bring all of my entries, except for these. The query works fine for 2014 if I explicitly use a WHERE…
Boone
  • 137
  • 3
  • 14
1
vote
1 answer

SQL Server 2014 Database NDF file Lost - Filegroup offline

I have a database that has lost one of its .ndf files and have been unable to get at the data. The .ndf file in question was added last Thursday and placed in a temporary storage location by a colleague (d'oh!). There is no backup available from…
Steve M
  • 13
  • 5
1
vote
2 answers

Calling an external API from Microsoft Dynamics Nav

I am researching how to integrate Microsoft Dynamics NAV with my existing REST API (built on Django REST Framework). What I would like to do is trigger API calls from NAV to CRUD objects via the REST API. Reading the web services docs for NAV, it…
Neil
  • 7,042
  • 9
  • 43
  • 78
1
vote
1 answer

Make list image bigger in Dynamics Nav 2013

I would like to make image bigger on an item list in Dynamics Nav 2013. What I could do so far is fetch the image and display it on the list. To achieve this I call SearchImage function on OnAfterGetRecord…
Arno 2501
  • 8,921
  • 8
  • 37
  • 55
1 2 3
…
24 25