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
PRODUCT CODE Required Enter existing Product Code JAF-1-234
WAREHOUSE CODE Required Up to 3 digit numeric code. Do not have to be sequential 100
STANDARD COST Enter the standard cost in the Pricing UOM for the product code entered. Accepts up to 5 decimals for costs 150.00000
ALTERNATE COST Enter the alternate cost in the Pricing UOM for the product code entered. Accepts up to 5 decimals for costs 152.00000
SPECIAL COST Enter the special cost in the Pricing UOM for the product code entered. Accepts up to 5 decimals for costs 125.00000
REORDER REQUIRED? Is reorder required? Enter 0 for No or 1 for Yes. Default is No 1
MIN QUANTITY If Reorder is required, enter the Min Qty in the Default Stocking UOM (decimal value not allowed) 3.00
MAX QUANTITY If reorder is required, enter Max Qty in the Default Stocking UOM (decimal value not allowed) 5.00

 

 

  • Was this Article Helpful ?
  • Yes   No
Tagged: