Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Coil Import

Compare Page Revisions



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


Page Revision: Mon, 20 Apr 2009 17:09


The Coil Import program allows you to import your coil inventory into Adjutant.

Logic behind import program: You must have item code, coil number, and actual weight filled out in the spreadsheet. If the coil is new (not in Adjutant already), you must also have lineal feet.

Item codes that are not matched will be added. Item codes/coil #s that are matched will be updated with the new info on the spreadsheet.

Spreadsheet layout:

Column A: COIL NUMBER

Column B: WAREHOUSE

Column C: receipt date

Column D: received by

Column E: ITEM CODE

Column F: LINEAR FEET

Column G: Theo Weight

Column I: ACTUAL WEIGHT

Column J: Grade

Column K: Condition

Column L: Base Metal

Column M: Backer

Column N: Thickness

Column O: Coat

Column P: Vendor

Column Q: PO #

Column R: Mill Name

Column S: Mill Coil #

Column T: Processor Name

Column U: Processor #

Column V: Paint Code

Column W: Cost per CWT

Column X: Total cost (not used in import; the program figures out total cost based on cost/cwt and actual weight)

Column Y: Print (NO if you don’t want a tag; YES if you want to print a tag)


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