Items (Inventory) - Overview
The Items tab within eFactory gives sellers visibility of their product inventory, otherwise known as Items, that are being managed at DCL facilities or partner facilities.
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.
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 Internatl PO the shipment was received against.
Order Type – This is the code for the type of internal PO.
OC – seller Supplied.
OP – DCL Supplied.
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.
Expl – This gives a brief explanation of why the stock was deducted.
Hold Status – Same as hold code from the hold section
Number – 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.
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.