Page History: Item Master Import
Compare Page Revisions
Page Revision: Wed, 06 Oct 2010 08:24
Default Menu Location
Transaction >> Importers/Exporters >> Item Control >> Item Master ImportClick here for a screenshot
General Description
The Item Import screen allows you to import
Item Master records into Adjutant.
Filters/Fields
Item File Name: File being imported into Adjutant
Default Owner: Owner of the merchandise
Default Whse: Merchandise location.
Default Heldfor: Merchandise is being held for at the time.
These fields can be specified in the file as well. If they are specified in the file, then these fields will be ignored.
Create All Combinations - Creates an Item Detail (owner, warehouse, held for) record for all possible combinations.
Validate Units - Check this box to validate the Units of Measure in the import file.
Leave this box unchecked if you're updating other fields on existing items.
Field Mapping Import File
Item Import Mapping File
Sample Import File
Item Master Import TemplateTo avoid any formatting issues, please save the spreadsheet in Microsoft Excel 5.0/95 Workbook Format.
Import Template Help
Item - Item Code (20 alphanumeric character max, no spaces allowed)
Descrip - Item Description (99 alphanumeric character max)
UnitGrp - Item Unit of Measure Group (examples are LENGTH, WEIGHT, TIME, IND). Must match a value in the UNITS rule.
PurUnit: Item purchase unit
StkUnit: Item stocking unit
SellUnit: Item sell unit
AvgCost: Item’s current average cost per stocking unit
Price: Item’s price per pricing unit
PriceUnit: Item’s pricing unit
StkFlag: Y if the item is stocked in the warehouse, N if it is not (made to order items are not stocked)
SerialFlag: Y if the item is serialized, N if it is not (serialized items have a serial number for every quantity of 1)
LotFlag: Y if the item is lot controlled, N if it is not (all coils are lot controlled)
Vendno: The vendor code of the item’s default supplier
Vpartno: The default supplier’s item code
HeldFor: Only used in multi-owner warehouses (enter USA for this)
Owner: Same as above
Whse: Enter the code of one of your warehouses (HOUSTON for example)
Taxable: Y if the item is taxable, N if it is not
UnitW: The item’s unit weight per stocking unit
Cubes: Used in Warehouse Mgmt System shipping (leave blank)
DecQty: The number of decimals that should be available when entering quantities of the item on a purchase or sales order
MiscItem: Y if the item is miscellaneous, N if it is not
Class: Free-text field where you can enter anything you want (leave blank)
Resell: Y if you plan on selling this item, N if you do not
PackCode: Leave blank
ABCCode: Leave blank
Pgroup: The item’s pricing group (customer pricing may be broken into item pricing groups; e.g. customer XYZ gets 40% off PANELS, 50% off COLDFORM, and 30% off ACCESSORIES; applicable in component sales)
ComCode: The item’s commodity code (commodity codes are used in procurement and determine which suppliers can bid on which items; enter TBD if you need to)
BaseCost: The item’s base cost (if you are pricing your items using a cost-plus scheme)
ProdLine: Leave blank
ProdGrp: Item’s product group (all items fit into one of 5 categories: Labor, Material, Equipment, Expense, or Subcontract)
ItemCat: Item’s transaction category (transaction categories are used to drive revenue and cost to the correct GL account; enter DEF here until the chart of accounts is set up)
SqFt: The items square footage per stocking unit
WarLen: If the item has an associated warranty length, enter it here
Produce: Y if the item is produced in the plant, N if the item is not produced
SearchCode: Leave blank
StdCost: Item’s standard cost per pricing unit
Coil
CW
CWPurConv
CWSellConv
CWSPriceConv
CWSTKConv
CWUnit
MasterTrack
