This article covers the Items subcategories: Status, Receiving, On Hold, Transactions, Lot Master, As of a Date, Transaction Summary, Cycle Count, DG Data, and Bundles.
What do the columns in the inventory report mean?
This section will give you the item's status. The column headers are similar to the item section in the Overview. Here is what the column headers mean.
Q on Hand – Physical Quantity on hand.
Q on Hold – what parts are on hold.
Q on FF – Units committed to our customer's shipping orders in our shipping system.
Q comm.–These are items committed to Work orders and Sales orders within the DCL ERP system (different than the shipping system).
Q in Proc. - When an order ships, the part number required moves from FF commitment to PROC commitment. PROC stands for in-process. After the order ships, there is no longer an FF order commitment and a slight delay of no more than 5 minutes before the stock is deducted from ON HAND. The PROC commitment accounts for the stock before deducting it from the system.
Open PO – This section shows open ASN’s the customer has created for incoming stock.
Open RMA – This section shows open RMA’s for RMA’s that are expected to come in.
Open WO – This section shows open WO’s that were are building that are not completed yet.
Line Type – This is the stocking line type when a part number is created. Normally you will see “S” for Stock or “O” for obsolete (if you uncheck the OMIT OBSOLETE sort function).
CAT 1 and CAT 2 – optional sort functions that can be added when a part number is created in E1.
CAT3 – Key item code will show here if the item is set up as a KEY item.
DCL Item Number – Our version of the customer part number that is created in E1
Sort Functions -
Warehouse- Where the stock is stored.
Flags – this shows reorder points, Key items, and shortages
Omit Zero qty – When this is checked, it will not list parts that are out of stock.
Omit Obsolete – When this is checked, it will not list parts that have been obsoleted.
This shows items received during a selected time period – Below are the new columns.
Receipt date – This is the day the product was received into the system.
Q Ordered – This is the qty that was requested on the ASN.
Q Received – This is the qty that was actually received.
Customer PO number – This is the PO number that the seller entered in when the ASN was created.
Supplier Ref. – This is the packing list number from the receipt.
Box/Pallet – This how many pallets or boxes were received. Example: B1 would be one box received. P3 would be three pallets received.
Order Type Desc – This is a description of the type of Internal PO the shipment was received against.
Order Type – This is the code for the type of internal PO.
OC – seller Supplied.
OP – DCL Supplied.
OM – Used for receiving goods is tied to an open RMA number
OU – Unplanned Return.
LOT/SERIAL – This is the lot code that was received in if the seller uses lot codes.
TRANS.DATE – This is the transaction date of the receipt.
DCL PO # - This is the PO number of the internal PO that is received against. When a seller creates an ASN our system creates an internal PO for the ASN.
DCL Receipt Number – When an item is received DCL creates a unique record ID for the receipt.
Trans # - This number comes from the seller when the ASN is created.
This section shows items that are on hold. If you check the “show all location” box, then it will show all stock regardless if its on hold order not. Below are the new columns not mentioned before.
Location – This is the location where the product is located.
Hold Code – This is the code for why the product is on hold. It’s a very high-level code so we will not have specific reasons here.
Hold Reason – This is a description of the hold code.
Last Activity Date- This is the last time a transaction was done against this location.
QTY – This is the qty in the location.
LOT/Serial – This is the LOT number if the seller uses lot codes.
PRM/SEC – This is the code to determine if the location is a Primary or Secondary location. Note- All stock is deducted from a primary location.
This section will show inventory transactions between a selected time period. The seller will see all additions and subtractions to inventory. What a seller will not see are internal transfers from one location to another location. New column headers not mentioned before.
Date – This is the transaction date of the addition or subtraction of the stock from the system.
QTY – This is how many units were added or subtracted from the system.
Type – This is the code we use to explain why the stock was subtracted or added.
IC – This is a completed work order. The completed finished good gets received into DCL owned stock first.
IF- This is a deduction from an order that DCL ships out on behalf of our seller.
II - This is a miscellaneous deduction of inventory from the system.
IM- Raw material deducted from Inventory for use in a Work Order.
IR- Addition of stock to seller owned that originated from DCL owned stock.
IU - Transfer of stock from the RMA department to good shippable stock.
OV - Inventory received from outside DCL.
PI - Addition/Deduction of stock due to a Physical Inventory count.
RI - Inventory deduction from an internal Sales Order.
ID - Addition of inventory due to a movement of stock from DCL owned to seller-owned.
IA - Addition/Deduction of stock due to a cycle count.
IO - If additional raw goods are needed for a work order, the additional stock is deducted using the IO code.
IP - Addition/Deduction of stock due to a Physical Inventory count.
TRANS.EXPL – This gives a brief explanation of why the stock was deducted.
Hold Status – Same as hold code from the hold section
DOC.NO – if the transaction is a receipt. The DCL internal PO number will be here.
Create Date – This is the date the transaction was created. Typically the create date and transaction date will be the same.
To Receive – This is where you can see open ASN’s for incoming product to DCL. New columns not mentioned before.
Promise date – This is the date the stock is expected to arrive.
Order date – This comes from the seller when they create the ASN.
On hold – TBD – Need to check where this data comes from.
Order number – This is the DCL internal PO number.
Last Status – This is DCL internal coding to determine what stage the PO is in.
Next Status - This is DCL internal coding to determine what stage the PO is in.
Lot Master – This section will show you inventory by lot location. Please note that the Net Available section does not include any FF orders that have a commitment.
As of Date – This will show the physical on hand for stock on a requested date – Use the sort function to select the date.
Transaction Summary – This section a seller can choose the date range and the system will summarize all the transactions between the dates chosen. I will have the beginning balance and the ending balance. New Columns not mentioned before
Beginning Balance – This is the starting balance from the date range chosen.
Sales Qty – This will be a compilation of all FF orders shipped.
Receipts – This will be a complication of all Trans Type: IR and OV (except if the DocType is OM and OU)
Assembled Qty – This will be a compilation of all IC Trans types.
Transfer Qty – This will be a compilation of all Trans types II, IM, RI, ID, IU, IO.
Adjusted Qty – This will be a compilation of all trans types with code IA.
Return Qty – This will be a compilation of Trans Type: OV (Doc Type OM and OU. It will not include Doc type OC).
Count Adjusted-This is a compilation of Trans type PI, IP, IQ.
End Balance – This is the ending balance.
This is where customers can see their cycle count results. Using the sort function, they can choose the date range.
New Columns that are not self-explanatory
CC days – These are the days from the last count.