Hello All,

After long time....i am back..

Today i am going to explain the most common and confusing form.

Every time when i Open the "On hand" in in D365/AX, i have to spend at least 5-7 mins to understand each terms in this form.

Every time i am ready for demo that time i have to put together a brief cheat sheet that i used to remember each filed means.

Please go through the below explanation for each columns of On had form.

On hand form all Column Definitions and explanations:

Physical Inventory – the physical quantity which are available in the warehouse.

Physical Reserved – the total quantity for any item that is physically reserved on an orders or inventory journals. No financial effect and we will not use that items for any other orders.

Available Physical – logic is- “Physical Inventory” minus “Physical Reserved” which equals “Available Physical.” 

 Available Physical is the inventory which is really available within the warehouse for further orders.

Ordered in Total – is the total amount of items on inbound orders or have a positive quantity on various inventory journals. Ordered in total quantities will increase inventory.

On Order – is the total amount of items on outbound orders or have a negative quantity on various inventory journals. On order total quantities will decrease inventory.

Ordered Reserved – This on-hand is displayed when a Sales Order is connected to a Purchase Order via the “direct delivery” or “purchase order” buttons within the Sales Order form. Items that fall into this bucket are not physically available in inventory. As a result, these items cannot be freely picked or delivered to be used on any open Sales Order. If the direct delivery button was used then upon receiving the linked Purchase Order, the Sales Order will change to Delivered and the on-hand for this column will be removed, as the inventory was shipped directly to the customer. If the purchase order button was used, then upon receiving the Purchase Order the on-hand values will move from Ordered Reserved to Physical Reserved as this product has been reserved within the warehouse for a specific customer on a specific Sales Order.

Total Available – is a calculated field that takes (Available Physical plus Ordered in Total) minus On Order = Total Available.

“Physical Reserved” Transaction Types

• SO > Open Order > if we reserved
• SO > complete the Picking list
• SO to PO (by clicking the purchase order button) > PO complete the GRN
• Movement Journal >click the Reserved > Negative
• Transfer Journal > Reserved > From
• Transfer Order > Open Order > Reservation
• Quarantine orders > Started > Quarantine Warehouse
• Quality Order > Open > Inventory type > Destructive
• Quality Order > Open > Inventory type > Not Destructive
• Inventory blocking

“Ordered in Total” Transaction Types

• SO to PO (via direct delivery button)
• SO to PO (via the purchase order button)
• PO > Open Order > Approved
• PO > Open Order > Confirmed
• Movement Journal > Open > Positive
• Inventory Adjustment Journal > Open > Positive
• Transfer Journal > Open > To
• Transfer Journal > Reserved > To
• Bill of Materials Journal > Open > Finished Good (positive)
• Counting Journal > Open > Positive
• Quarantine orders > Open > Quarantine Warehouse
• Quarantine orders > Started > From Warehouse
• Quality Order > Open > Inventory type > Not Destructive
• Inventory blocking

“On Order” Transaction Types

• SO > Open Order > No Reservation
• Return PO > Open Order > Approved
• Return PO > Open Order > Confirmed
• Movement Journal > Open > Negative
• Inventory Adjustment Journal > Open > Negative
• Transfer Journal > Open > From
• Bill of Materials Journal > Open > Raw Material (negative)
• Counting Journal > Open > Negative
• Transfer Order > Open Order > no reservation
• Quarantine orders > Open > From Warehouse

“Ordered Reserved” Transaction Types

• SO to PO (via direct delivery button)
• SO to PO (via the purchase order button)

                                           *********END*******