2000 Smallman Street • Pittsburgh, PA 15222
2000 Smallman Street Pittsburgh, PA 15222
Voice: (412) 391-9966 Fax: (412) 391-9944
The Odyssey Software Group
Accounts Receivable Import
This product adds a new dimension to Dynamics Receivable Transaction processing by allowing the user to create receivable
transactions by importing information from another application.
1) All Accounts Receivable Setup procedures need to be completed prior to importing transactions.
2) The user needs to save the receivable transaction detail using the following import file definitions:
a) There will be two record types in the import file containing data for each invoice.
The first type will have an “I” in the first position of the record and will contain general invoice information.
The second record type will have a “D” in the first position of the record and will contain information for each
distribution associated with the invoice. The specifics of the fields that will make up each record type of the import
file have been detailed below. Step Saver will continue to add distributions to the last invoice until either the new
invoice number is found or the end of the file is reached. The sum of all the distribution amounts should be equal to
the ‘Sales Amount’ from the invoice record.
b) All fields in the interface record will be delimited with either a tab, comma, or pipe character (|). The user will be
given the option of selecting which delimiter to use during the import process. All the distribution type records for
the invoice will follow each invoice type record in the import file.
c) The additional information required entering a receivables transaction on the Dynamics system will be defaulted
from the customer record. This information includes the customer address, payment terms, shipping method, sales
person ID, territory ID, and accounts receivable GL account number.
Record Type (“I