Inventory transaction status

Inventory transaction status

I spend an unreasonable proportion of my working day staring at Inventory transactions and trying to figure out what has happened (or will happen).

Here’s the little guide I wrote myself a while back to the all-important status fields.

First, all Dynamics AX inventory transactions are either an Issue, or a Receipt.

Incidentally, because we’re looking at Dynamics AX 2012 R3 here we ought to mention that Inventory transactions are also Warehouse work or not Work, so we now have a filter at the top of the form that will display all transactions, or show or hide the warehouse work transactions.

I’m not sure how these tables are going to format when I post this, but here goes with an explanation.

The receipt status can be:

Receipt status	Description	On hand inventory	Physical date	Financial date
Quotation receipt	A sales quotation that has a negative quantity has been sent to the customer for approval. A credit note has not yet been created for the sales quotation	Not included	Blank	Blank
Ordered	An open receipt, for instance an approved purchase order; a production order; an un-posted inventory journal; a sales order return order. The inventory transaction has an ‘Expected date’	Not included	Blank	Blank
Arrived	An arrival journal with pallet transport orders has been posted (and the pallet transport orders created). Only seen when using the WMII module.	Not included	Blank	Blank
Registered	An arrival journal without pallet transport orders has been posted; or pallet transport orders are complete (WMII); or a Purchase receive (or sales return) transaction has been performed in the mobile client (WHS); or the transaction has been manually Registered. Note. On hand inventory is updated but no posting is made to the General ledger.	Included	Blank	Blank
Received	A purchase order product receipt (or return sales order delivery note) or production order Report as finish has been posted.	Included	Filled	Blank
Purchased	A purchase order invoice (or return sales order invoice) has been posted; or a production order has been ‘Ended’; or an inventory journal has been posted.	Included	Filled	Filled

The issue status can be:

Issue status	Description	On hand inventory	Physical date	Financial date
Quotation issue	A sales quotation has been sent to the customer for approval. The sales quotation is not yet a sales order	Has not reduced on hand	Blank	Blank
On order	An open issue: for instance a sales order; a production order component; an un-posted inventory journal; a return order purchase order. The inventory transaction has an ‘Expected date’	Has not reduced on hand	Blank	Blank
Reserved ordered	An open issue is reserved (most often marked) against an open receipt. Most typically a sales order with a make to order production order, or a sales order with a buy to order purchase order.	Has not reduced on hand	Blank	Blank
Reserved physical	An open issue reserved against on hand inventory.	Has not reduced on hand	Blank	Blank
Picked	A sales order picking list has been posted, (or the inventory transaction has been picked manually). Note. On hand inventory is updated but no posting is made to the General ledger.	Has reduced on hand	Blank	Blank
Deducted	A sales order delivery note (or a return purchase order product receipt) or a production order picking list has been posted	Has reduced on hand	Filled	Blank
Sold	A sales order invoice (or a return purchase order invoice) has been posted; or a production order has been ended; or an inventory journal has been posted.	Has reduced on hand	Filled	Filled

I think this will help you...!!