AV_Import.xls

The AV_Import.xls template applies to Auxiliary Voucher (AV) documents.

The basic format of the template is shown below.

AV_Import template format

Column	Field
A	Chart Code*     If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template.
B	Account Number*
C	Sub-Account Number
D	Object Code*
E	Sub-Object Code
F	Project Code
G	Organization Reference Id
H	Line Description
I	Debit*
J	Credit*

 

     An amount is required in either the Debit or Credit column for each accounting line. If amounts are erroneously entered in both Debit and Credit fields on an accounting line, only the credit amount are imported to the accounting lines, the debit amount is not imported.

More:

BA_YEBA_Import.xls