AGR offers a variety of methods for exporting confirmed orders to your ERP system, each catering to different needs and setups. By choosing the method that best suits your system, you can streamline your order processing and ensure efficient inventory management.
Below, we provide detailed instructions for each available order transfer route to ensure you can manage your orders efficiently.
Manual Excel / CSV export from AGR
This is the most basic option and requires no integration. AGR will not transfer the order automatically. Instead, you need to follow the steps below.
After reviewing and confirming an order
Set your order view to include the columns you want to include.
Select export in the top right of the toolbar.
Select Excel or .csv export.
Import the downloaded file to your ERP system.
NAV / BC 13-16 add-on fetch orders from AGR
When you confirm an order, AGR makes it available to the NAV / BC module to pull from AGR. To pull orders into the ERP, you can either:
Configure the NAV / BC add-on to periodically pull orders or
Click on the button in the interface in NAV / BC
AGR data integrator extension in BC
For BC 17 and higher on-premise or in a private cloud or BC in a public cloud (SaaS) install and configure the AGR Data Integrator add-on.
When an order is confirmed in AGR, it is sent directly to BC via API endpoints created by the AGR Data Integrator.
AGR order API
To use AGR’s API, you need to contact AGR customer service to enable the API and obtain credentials
AGR offers an API that fetches the confirmed orders from the AGR order API and delivers them to your ERP.
Once set up:
Request the authentication token to the AGR staff
Once authenticated, you will have to interact with the endpoints below. Check AGR Public API for more details
Get all confirmed order IDs - outputs a list of confirmed IDs
GET - https://api.agrinventory.net/api/Order/status/confirmed/ids
Fetch the confirmed orders for specific id, only one ID at a time
GET - https://api.agrinventory.net/api/Order/{id}
Alter the status to transferred in AGR once the order with id = id has been fetched
POST - https://api.agrinventory.net/api/Order/{id}/status/transfer
The process should only run once every 15 minutes.
AGR posts to external API
This option requires collaboration between AGR and your IT department.
AGR can push orders to built-in ERP APIs. To set up this transfer method, AGR needs:
API documentation,
An endpoint (e.g. https://yourERP.com/PurchaseOrder) to receive orders,
Credentials to the API, and
The payload format accepted by the API
AGR will send confirmed orders to the specified endpoints in the configured format. Note that support from your IT department may be needed for usage and field mapping to the API.
AGR writes to your SQL database
For this option, you need an SQL server with a table that AGR can write to.
AGR needs the following to write orders to your SQL database.
An established connection via Microsoft Integration Runtime,
Server and database names, and
Table and column definitions
Your IT department or ERP partner will be responsible for transferring the SQL information to your ERP.
AGR supports 3 SQL types.
Microsoft SQL
MySQL
PostgreSQL
AGR writes to .csv files on an SFTP server
You must have a running SFTP server, hosted by you, to use this method.
AGR needs the following for this order transfer option:
An established connection via Microsoft Integration Runtime
Server name
File paths
Column names
The order format that AGR uses to write to the SFTP server can be customized, but the output is a .csv file.
Your IT department or ERP partner is responsible for delivering the orders from your SFTP server to your ERP.
AGR offers several methods to send confirmed orders back to your ERP system. The process for transferring these orders will depend on the method you choose.
For further assistance with any of these methods, please contact AGR customer support.