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
INVOICE NO Required Enter the Kit Product Code that has been set up in the system KB034
KIT PRODUCT CODE Required Enter the Kit Product Code that has been set up in the system KB034
COMPONENT PRODUCT CODE Required Enter the product code of the existing kit component JA-2304-23
COMPONENT PRODUCT CODE Required Enter the product code of the existing kit component JA-2304-23
COMPONENT UOM Enter unit of measure for component EA
COMPONENT QTY Enter quantity for component 5
COMPONENT PRICE Enter price for component 67.50
COMPONENT STANDARD COST Enter standard cost for component 32.00
COMPONENT AVERAGE COST Enter average cost for component 31.89542
COMPONENT ALTERNATE COST Enter alternate cost for component 30.00
COMPONENT SPECIAL COST Enter special cost for component 30.00

 

 

  • Was this Article Helpful ?
  • Yes   No
Tagged: