Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Item Master Import

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


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 Template

To 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.


Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions