JV_Ext_Encumbr_Import.xls

The JV_Ext_Encumbr_Import.xls template applies only to Journal Voucher (JV) - Debit/Credit amount entry, used for External Encumbrance balance types

     A Journal Voucher has three different accounting line formats, depending on its Balance Type. You must choose the Balance Type before importing.

The basic format of the template is shown below.

JV_Ext_Encumbr_Import template format

Column	Field Name
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	Object Type Code
F	Sub-Object Code
G	Project Code
H	Organization Reference Id
I	Enc Update Code
J	Line Description
K	Reference Origin Code*
L	Reference Type Code*
M	Reference Number*
N	Debit*
O	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 is imported to the e-doc, the debit amount is not imported.

More:

JV_NonOffset_Bal_Type_Import.xls