Importing an EDI file

Purpose

To allow the import of asset details so that Bailment Accounts and Trust Receipts may be automatically created

EDI File Import Rules

• All invoice amounts must be positive
  
• All Credit Return amounts must be negative and for the full amount of the asset value
  
• Prices Adjustments may have a negative or positive amount
  
• GST will be ignored for all Related Parties
  
• GST must be included in the EDI file for Non Related Parties. The GST amount in the file will be used when calculating the Asset value.
  
• The GST must have the same sign as the invoice or credit note value
  

Access

1. Process | Bailment | Import EDI File
   

Process

The following dialog will display:

Field	Explanation
Select Distributor	[F2] to highlight and  the Distributor for which the EDI file is to be imported
Processing Date	This is the date to be used as the value date for all new asset purchases, price adjustments or credit returns included in the import file It will default to today's date It cannot be greater than today's date It cannot be earlier than the invoice dates in the file to be imported

The EDI Import process creates a log file

Every record is recorded in the log file as a success or failure

 to view the log file is any records failed to import

The log file will list all records imported, any records that were not imported and why they failed

Note: If an EDI file is imported more than once anything already imported will be ignored

Defaults

The following fields are defaulted by the EDI Import

Field	Explanation
Year of Manufacture	This will default to the year of the import data
Security Make	This will default to the Security Make as specified on the Distributor Setting tab for the Selected Distributor
Second Analysis Code	This will default to the Second Analysis Code as specified on the Distributor Setting tab for the Selected Distributor

• Related Articles

• Import EDI File Errors

  Purpose EDI Import allows the import of an externally created file of Bailment Assets, credit returns and price adjustments. Process Review the error, and correct Issue Solution File IO Exceptions or parsing errors If there is a problem reading the ...

• Trust Receipts

  Purpose The Trust Receipt document will provide details of the asset for which the account was created. It is a legal agreement between the Dealer and the Finance Company. Creation of Trust Receipts When an account is created, a price adjustment made ...

• Import EDI File Setup

  Purpose Allow the setup of file paths for import and export of file relevant to distributors Access View | Distributor | account | Distributor Settings tab Dialog Details The following dialog will display: Details Specific Fields Field Explanation ...

• Argos API/EDI Import Tool

  This document outlines how to use the Argos API Import tool to import new Bailment Accounts from an external file through the Argos API Server. Also how raise Credit Returns and Price Adjustments. Prerequisites API Server The API Import tool requires ...

• Print Trust Receipts

  Purpose Allow the bulk printing of Trust Receipts Access Processes | Bailment | Print Trust Receipts Process Field Explanation Not Printed This allows the user to print all Trust Receipts that are not yet printed Company [F2] to highlight and the ...