The Inventory Transaction Status in AX 2012.

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

Clear as mud eh?

Advertisements