| Field Name | Import? | Description of Field | Limit |
| Item ID | Y | Alphanumeric - Inventory ID number | Up to 20 characters |
| Item Description | Y | Alphanumeric - Inventory item description. | Up to 30 characters |
| Item Class | Y | Numeric (Whole) - Inventory item class; valid numbers are 0 through 11:
0=Non-stock item
1=Stock item
2=Description only
3=Assembly
4=Service
5=Labor
6=Activity item (Sage 50 Complete Accounting and higher only)
9=Substock (Sage 50 Complete Accounting and higher only)
10=Serialized Stock item (Sage 50 Premium Accounting and higher only)
11= Serialized Assembly (Sage 50 Premium Accounting and higher only) | |
| Inactive | Y | Boolean - Inactive check box; valid choices are True or False:
True = Inactive
False = Active | |
| Subject to Commission | Y | Boolean - Subject to commission check box; valid choices are True or False | |
| Description for Sales | Y | Alphanumeric - Inventory item detailed description. | Up to 160 characters |
| Blank Field | N | | |
| Description for Purchases | Y | Alphanumeric | Up to 160 characters |
| Sales Price/Billing Rate 1-10 | Y | Numeric (Real) - Inventory price levels 1 to 10. and higher, you can have up to 10 price levels. Sage 50 First Accounting only permit five price levels. | |
| Sales Price 1-10 Calculation | Y | Alphanumeric - Inventory price level 1 to 10, base calculation method selected in the Maintain Item Prices window. Valid choices are:
NC (no calculation)
LC (last cost) + a calculation formula
PL1 (Price Level 1) + a calculation formula
LC and PL1 include a formula such as the following:
LC+20.00 = last cost increased by the amount of $20
PL1*1.10 = Price Level 1 increased by 10 percent (depending on the number of decimal places chosen in Maintain Global Settings).
Note: NC, LC, and PL are case sensitive; they must be uppercase. | |
| Sales Price 1-10 Rounding | Y | Numeric - Inventory price levels 1 to 10, rounding method used in calculation. Valid numbers are 0 through 2:
0 = no rounding
1 = rounding to a specific cent
2 = rounding to the next dollar | |
| Sales Price 1-10 Rounding # | Y | Numeric - Inventory price level calculation 1-10, new value rounded to a specific cent. Depending on the number of decimal places chosen in Maintain Global Settings, this value is represented as 0 + 1 to 5 decimal places—for example, with two decimal places, 0.50 = value rounded to $0.50. | |
| Qty Discount ID | Y | Alphanumeric - Quantity Discount ID number | Up to 20 characters |
| Item Tax Type | Y | Numeric (Whole) – Inventory item tax types as set up in Maintain, Default Information, Inventory Items; valid numbers are 0 to 24. | Up to 13 characters |
| Last Unit Cost | Y | Numeric (Real) - Inventory item cost amount for Stock and Non-stock items. | |
| Costing Method | Y | Numeric (Whole) – Costing method; valid numbers are 0 through 2:
0 = Average Cost (all Sage 50 products)
1 = FIFO (Sage 50 Pro Accounting and higher). This field applies to [Stock item], [Assembly], and [Master Stock item] items only.
2 = LIFO
3 = Specific Unit (Only for serialized items) | |
| G/L Sales Account | Y | Alphanumeric - Usual sales account no. Must be a valid account number from your Chart of Accounts. | Up to 15 characters |
| G/L Inventory Account | Y | Alphanumeric – Inventory account no. Must be a valid account number from your Chart of Accounts. Required for all types of items excluding description only. Note: This field is not required for activity items and charge items. | Up to 15 characters |
| G/L COGS/Salary Acct | Y | Alphanumeric - Cost of Goods Sold or Salary/Wages account no. Must be a valid account number from your Chart of Accounts. Required for all types of items excluding description only. Note: This field is not required for activity items and charge items. | Up to 15 characters |
| UPC/SKU | Y | Alphanumeric - The Universal Price Code/Stock Keeping Unit for the item. | Up to 20 characters |
| Part Number | Y | Alphanumeric - Part number for an Item | Up to 20 characters |
| Item Type | Y | Alphanumeric - Inventory item type | Up to 15 characters |
| Location | Y | Alphanumeric - Location of inventory item | Up to 10 characters |
| Stocking U/M | Y | Alphanumeric - stocking unit of measure field | Up to 20 characters |
| Use Multi-Packs | Y | Boolean - buy and sell in different quantities; valid choices are [True] or [False] | |
| Purchasing U/M | Y | Alphanumeric - The default U/M for purchases of the item. | |
| Purch U/M Description | N | Alphanumeric | |
| Purch U/M No. of Stocking Units | N | Numeric (Whole) - The number of stocking units for the purchasing U/M, defined in Maintain Units/Measures | |
| Purchasing Weight | Y | Numeric (Whole) | |
| Purchasing UPC/SCC | Y | Alphanumeric - UPC/SCC code for the purchasing U/M. | |
| Use Purchasing U/M as Default | Y | Boolean - valid choices are True (use as default) or False (use Stocking U/M as default) | |
| Sales U/M | Y | Alphanumeric - The default U/M for sales of the item. | |
| Sales U/M Description | N | Alphanumeric | |
| Sales U/M No. of Stocking Units | N | Numeric (Whole) - The number of stocking units for the sales U/M, defined in Maintain Units/Measures. | |
| Sales Weight | Y | Numeric (Whole) | |
| Sales UPC/SCC | Y | Alphanumeric - UPC/SCC code for the sales U/M. | |
| Use Sales U/M as Default | Y | Boolean - valid choices are True (use as default) or False (use Stocking U/M as default) | |
| Weight | Y | Numeric - The weight of the item in the selected unit of measure. | Up to 8 characters |
| Minimum Stock | Y | Numeric (Real) – Minimum stock level | |
| Reorder Quantity | Y | Numeric (Real) - Amount of inventory item normally reordered. | |
| Vendor ID | Y | Alphanumeric - Usual Vendor ID number from your vendor list. Required only if item is a [Stock item], [Assembly item], or [Master Stock item]. | Up to 20 characters |
| Buyer ID | Y | Alphanumeric - ID of the company employee/sales rep designated as buyer for the item. | Up to 20 characters |
| Label for Inventory Item Custom Field 1 (entered in Inventory Item Defaults) | Y | Alphanumeric - The text value of what is entered in inventory item custom field 1 in Maintain Inventory Items. | Up to 40 characters |
| Label for Inventory Item Custom Field 2 (entered in Inventory Item Defaults) | Y | Alphanumeric - The text value of what is entered in inventory item custom field 2 in Maintain Inventory Items. | Up to 40 characters |
| Label for Inventory Item Custom Field 3 (entered in Inventory Item Defaults) | Y | Alphanumeric – The text value of what is entered in inventory item custom field 3 in Maintain Inventory Items. | Up to 40 characters |
| Label for Inventory Item Custom Field 4 (entered in Inventory Item Defaults) | Y | Alphanumeric – The text value of what is entered in inventory item custom field 4 in Maintain Inventory Items. | Up to 40 characters |
| Label for Inventory Item Custom Field 5 (entered in Inventory Item Defaults) | Y | Alphanumeric – The text value of what is entered in inventory item custom field 5 in Maintain Inventory Items. | Up to 40 characters |
| Master Stock ID | Y | Alphanumeric - ID number of master stock item. Required for all substock items (Sage 50 Complete Accounting and higher). | Up to 20 characters |
| Primary Attribute ID (there can be up to 20 of these fields) | Y | Alphanumeric - ID of the master stock item primary attribute. At least one required for each master stock item (Sage 50 Complete Accounting and higher). | Up to 4 characters |
| Primary Attribute Description (there can be up to 20 of these fields) | Y | Alphanumeric - At least one required for each master stock item (Sage 50 Complete Accounting and higher). | Up to 20 characters |
| Secondary Attribute ID (there can be up to 20 of these fields) | Y | Alphanumeric - ID of the master stock item secondary attribute (Sage 50 Complete Accounting and higher). | Up to 4 characters |
| Secondary Attribute Description (there can be up to 20 of these fields) | Y | Alphanumeric (Sage 50 Complete Accounting and higher) | Up to 20 characters |
| Item Note | Y | Alphanumeric - Inventory item note. | Up to 249 characters |
| Print Components | Y | Boolean - Print components check box under the bill of materials if the item is an assembly; valid choices are [True] or [False] | |
| Primary Attribute Name | Y | Alphanumeric - Name of the primary attribute. For both master and substock items (Sage 50 Complete Accounting and higher). | Up to 20 characters |
| Substock Primary Attribute ID | Y | Alphanumeric - ID of substock primary attribute. At least on is required for each substock item (Sage 50 Complete Accounting and higher). | Up to 4 characters |
| Substock Primary Attribute Description | Y | Alphanumeric - At least one is required for each substock item (Sage 50 Complete Accounting and higher). | Up to 20 characters |
| Substock Secondary Attribute ID | Y | Alphanumeric - ID of substock secondary attribute (Sage 50 Complete Accounting and higher). | Up to 4 characters |
| Substock Secondary Attribute Description | Y | Alphanumeric (Sage 50 Complete Accounting and higher) | Up to 20 characters |
| Quantity on Sales Orders | N | Numeric (Real) - Quantity of inventory item appearing on all sales orders (Sage 50 Pro Accounting and higher). | |
| Quantity on Purchase Orders | N | Numeric (Real) - Quantity of inventory item appearing on all purchase orders (Sage 50 Pro Accounting and higher). | |
| Quantity on Hand | N | Numeric (Real) - Quantity of inventory item currently in stock. | |
| Is Taxable | Y | Boolean - Item Tax Type list box; valid choices are [True] or [False], where True=Taxable and False=Exempt. | |
| Warranty Period | Y | Alphanumeric - Warranty period set for this item. Note: The warranty period can be set up in days, months, or years. | 90 |
| Revision Number | Y | Numeric (Real) - Sequential number assigned to revisions based on system date and effective date of transaction. | |
| Effective Date | Y | Date - Date of the revision. Must be in ##/##/## (month/day/yr) format. | |
| Component Number | Y | Numeric (Real) - The position the component occupies in the assembly; order may be important with subassemblies or in a step-like procedure. | - 300 (Sage 50 Distribution, Manufacturing, Quantum Accounting)
- 100 (Sage 50 Premium ,Complete, Pro Accounting)
|
| Component ID | Y | Alphanumeric - If an item is part of an assembly, these fields (1-96) will contain the component's Item ID. | |
| Quantity Needed | Y | Numeric (Whole) - If an item is part of an assembly, these fields will contain the component quantity needed to produce one unit of the assembly item. | - 300 (Sage 50 Distribution, Manufacturing, Quantum Accounting)
- 100 (Sage 50 Premium ,Complete, Pro Accounting)
|