To send orders that are created, reviewed, adjusted and confirmed in AGR to NAV, an extension needs to be installed in your NAV environment. This article guides you through the installation process.

To install the order transfer module, you will need either AGRObjects.fob or AGRObjects.txt, downloadable from the link below.

The interface should be set up within the Purchase Department in any of the Add-on X Menusuites. Adding the AGR Setup Page is sufficient, but we recommend adding the AGR Log and AGR Import Log as well.

You will need to populate the AGR Setup page with the correct data to connect to AGR's SQL database with the orders. Each record comes with some default values, as shown in the table below, that can be changed as needed.

See below for and example of the AGR setup.
​

Orders can be pulled into either NAV automatically or manually. When first setting up the interface, we recommend testing manual pulls before setting up automatic jobs to retrieve orders at a set frequency.

Manual pulls can be done from the AGR Setup page by pressing Retrieve AGR Lines in the HOME tab. This will connect to the AGR database and pull orders that have been reviewed and confirmed in AGR and are ready to be imported into NAV.

The order import process goes through three steps.

If the orders can‘t be pulled into NAV for some reason, the AGR Import Items page will open with all lines that were retrieved from the database, regardless of whether they have errors in them.

The AGR Import Lines page has the following fields.

Common issues that cause errors in the transfer of orders include:

Each time that NAV connects to AGR for an order transfer, it creates a log entry of the communication. After the import has finished, the entry shows how many errors occurred during the import.

When the AGR Setup and manual testing are finished, a job queue can be created to fetch AGR orders automatically. Assuming a Job Queue and Job Queue Category have been created, a Job Queue entry can be created as shown in the image below. The Job Queue Entry should run Codeunit AGR Synchr. Start (ID 50040). We recommend setting the time interval to 5 minutes between runs. This can be changed depending on other Job Queue Entries that are running in the system.

Codeunit 333 Req. Wksh. -Make Order needs to be changed for the job queue function to work. Every variable of type window needs to be handled, only triggering it if AGR fetching of orders happens from a NAV client. To handle this use the command IF GUIALLOWED THEN. See images of the required changes below.