The field order should exactly match the field order specified in this document, as should the field count. Each data row for the voucher shall contain six mandatory columns:
Assignment Number – You will want to enter the Assignment Number that the receivable is associated with. If run at the system level this will determine what company the receivable is associated with.
Account Identifier – Account Number dot Subaccount Number, or Account Number, or Long Description or Short Description
Amount – Amount of the Receivable
Currency – 3 digit currency code
Date – Date of the receivable
Reference – Provide comments/note details if applicable. (This field can be left blank but must be included as a column. You can leave it blank and yet include it as a column by having a comma after the date in “column” five. Excel won’t add this last comma for you.)
Sample Import Files
Below is an example of a valid layout. There are three receivables being created.
The following sample file is a comma-delimited sample that could be copied into a text file or imported into an Excel file for easier editing.
101211,001.01,100,USD,1/1/2009,Annual Service Fee 2009
101211,001.01,200,USD,1/1/2010,Annual Service Fee 2010
101211,001.01,300,USD,1/1/2011,