Power Community

Power Community

Understand inventory on hand form columns (Status) in Microsoft dynamics 365 finance and operations

In this blog we will go back to our basics , for long time I was confused about column available on inventory on hand form. How these columns get impacted by every transaction.

I have tried explaining this using new product and creating new transactions and showing up the impact.

Note: If these is something wrong please let me know happy to update.

Step-1: Created one sales order with 10 QTY

Impacted column: On order

Step-2: Now lets add 10 QTY against the product and see impact

Impacted column: Available physical, Available physical on exact dimensions, Available for reservation, Total available

Step-3: Since we have stock available of 20 QTY , so lets reserve 5 QTY against sales order

Column Impacted: Available physical, Available physical on exact dimensions, On order, Available for reservation

Step-4: Now out 10 QTY on order (Sales order) , 5 we will full fill from Stock but now create PO for remaining 5

Column Impacted: Ordered in Total, On order, ordered reserved, Total available

Here is the final summary of all the steps (Download Excel file for same)

That’s it for this blog, hope this will give you good idea about inventory statuses.

Thank you !!! Keep reading and sharing !!!

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

WhatsApp + Dynamics 365 CRM: Your Secret to Christmas Marketing Success

The holiday season is a busy time for businesses, and Christmas🎄 is no exception. With so much competition for...

More Articles Like This

- Advertisement -spot_img