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
PO NO Required Enter existing PO No PO-2000
VENDOR PRODUCT CODE Enter the Vendor Product Code VA-234-456
PRODUCT CODE Required Enter existing Product Code JA-201-345
PRODUCT DESCRIPTION Enter Product Description. If this field is left blank, the Product Description on the Product Master record will be inserted into the record Safety harness – large
UOM Required Enter existing PO UOM for this Product EA
QTY Required Enter the Quantity 1
PRICE Required Enter the unit price with up to 5 decimal places 5.00000
DATE REQUIRED Required Enter the Date Required 05/05/2016
SPECIAL ORDER Special Purchase Order? Enter Y or N, Default is N N
COMMENTS Enter the comments Comments
STATUS Required Enter Status of R (Received) or O (Open). Default is O O

 

 

  • Was this Article Helpful ?
  • Yes   No
Tagged: