Accolent ERP data Import Template Instructions provide field-by-field information on the data needed to fill out the CSV templates. Always review these instructions before populating a CSV import template.

Field Name Required Field? Field Data Instructions Sample Data
VOUCHER NO Required 10 character maximum. No spaces. Use only standard ASCII characters (no *,/, etc.) 1016458
VENDOR CODE Required Enter existing Vendor Code VA-346-203
PO NO Enter existing PO No C12345
RECEIPT NO Enter existing Receipt No 10568
VOUCHER DATE Required Voucher date in US date format MM/DD/YY 3/15/2019
VOUCHER AMOUNT Required Dollar total of vendor’s invoice 2350.00
PRIOR PAID AMOUNT Dollar total of amount(s) paid against this vendor’s invoice 1000.00
DISCOUNT AMOUNT Enter as 0.00; Accolent ERP will calculate based on Terms 0.00
BALANCE DUE Dollar total of balance due against this invoice 1350.00
DUE DATE Vendor Invoice due date in US date format MM/DD/YY 4/15/2019
DISCOUNT DATE Vendor Invoice discount date in US date format MM/DD/YY 4/25/2019

 

 

  • Was this Article Helpful ?
  • Yes   No
Tagged: