Page History: Item Master Import
Compare Page Revisions
Page Revision: Mon, 01 Aug 2011 09:24
General Description
Default Menu Location Transaction >> Importers/Exporters >> Item Control >> Item Master Import
Screen Name ITEMIMPORT
Click here for a screenshot
Funtion 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: Y if the item is a coil.
CW: Y if the item is a catch-weight item.
CWPurCon: Catch-Weight conversion factor between stock unit and purchase unit
CWSellConv: Catch-Weight conversion factor between stock unit and selling unit.
CWSPriceConv: Catch-Weight conversion factor between stock unit and pricing unit.
CWSTKConv: Catch-Weight conversion factor between catch unit and stock unit.
CWUnit: Catch-Weight Unit.
MasterTrack: Y if item is lot controlled AND needs to be tracked by P-number. This is typically used if you need to individually track multiple lots that have the same lot number.
