1. Type – 0=Inventory, 1=Service, 2=Master.  If the field is left blank, the type will be defaulted to ‘Inventory’.
  2. Item No – Alpha numeric field.  Maximum length 15 characters.  Every inventory item must have a unique code; any alpha characters will be converted to uppercase automatically.
  3. Description – Alpha numeric field.  Maximum length 80 characters.  Every item must have a description.
  4. Supplier No – Alpha numeric field.  Maximum length 40 characters.  Note: This field will not update if the Use Multiple Vendors function is turned on in the I/C Defaults window.
  5. Vendor – Alpha numeric field.  Maximum length 10 characters.  Enter the default vendor code; be certain that the vendor and code have been entered into CONNECTED in the A/P module.  Invalid vendor codes will not be imported.
  6. Purchase Cost – Numeric field.
  7. Selling Price – Numeric field.
  8. Cost of Sales – Enter the default cost of sales account per item.  The account number must have already been set up in CONNECTED.  If this column is left empty, the account number from the Company Setup, I/C Accounts screen under the File menu will be used.
  9. Inventory – Enter the Inventory control account per item.  The account number must have already been set up in CONNECTED.  If this column is left empty, the account number from the Company Setup, I/C Accounts screen under the File menu will be used.
  10. Sales – Enter the default sales account per item.  The account number must have already been set up in CONNECTED.  If this column is left empty, the account number from the Company Setup, I/C Accounts screen under the File menu will be used.
  11. Inv. Clearing – Enter the default account per item that will be credited when posting receiving transactions in the Inventory module.  The account number must have already been set up in CONNECTED.  If this is left empty, the account number from the Company Setup, I/C Accounts screen under the File menu will be used.
  12. Bin Location – Alpha numeric field.  Maximum length 10 characters.
  13. Lead time – (in days) Numeric field only.
  14. Min. Qty. – Numeric field.
  15. Max Qty – Numeric field
  16. Reorder Qty. – Numeric field.
  17. Units – Alpha numeric field.  Maximum length 3 characters.  Enter the unit of measure for the item, i.e., lbs.
  18. Warranty – (in months) Numeric field only.
  19. Weight – Numeric field only.
  20. Analysis code – Alpha numeric field.  Maximum length 5 characters.  The analysis code field allows you to identify items of a similar type and produce reports by selecting the desired analysis code.
  21. Tax 1 – Is the item taxable for level 1; enter YES or NO.  If the field is left blank, tax 1 will default to YES.
  22. Tax 2 – Is the item taxable for level 2; enter YES or NO.  If the field is left blank, tax 2 will default to YES.
  23. Commissions – Is the item commissionable; enter YES or NO.
  24. Commission % - Numeric field only.  Is only used if commissions are calculated based on item.  See A/R Defaults setup window for further details.
  25. Flat Fee – (For Service items only) enter 0 for YES or 1 for NO.
  26. HTD Units sold – Numeric field only. (History to Date)
  27. HTD Sales – Numeric field only. (History to Date)
  28. User Defined
  29. User Defined
  30. User Defined
  31. User Defined
  32. User Defined
  33. User Defined
  34. User Defined
  35. User Defined
  36. User Defined
  37. User Defined
  38. Status –  Using "ACTIVE" will make the item Active; a value of "INACTIVE" will make the item Inactive
  39. UPC 1 – UPC Code 1, up to 20 alpha-numeric characters
  40. UPC 2 -  UPC Code 2, up to 20 alpha-numeric characters
  41. EDI Custom
  42. EDI Custom
  43. EDI Custom
  44. EDI Custom
  45. EDI Custom
  46. EDI Custom
  47. EDI Custom
  48. EDI Custom
  49. EDI Custom
  50. EDI Custom
  51. EDI Custom
  52. EDI Custom
  53. EDI Custom
  54. EDI Custom
  55. EDI Custom

28-37 User Defined fields.  Enter these on your spreadsheet if you have defined the fields in the I/C Defaults setup window.  See the Selecting Defaults section of the Inventory Control  chapter.

41-55  EDI Custom fields – 15 alpha-numeric which support up to 20 characters in each field.  Fields must be labeled in the IC Defaults setup window to be available fo import.