web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Inventory Quantity on ...
Microsoft Dynamics SL (Archived)

Inventory Quantity on Hand

(0) ShareShare
ReportReport
Posted on by Community Member

Is there a screen (or field) in SL that shows the inventory quantity on hand that considers items on open shippers and from purchase orders?

The inventory availability screen (21.410.00) shows On Hand, but that number includes items on open shippers and purchase orders which means they truly are not on hand to use.

Example:  Part 123 has 25 On Hand, 5 on Shippers, and 10 from POs.  The truer QOH should be 10 (25 less 5 and l0).

Thoughts?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    You can get those kind of Qty break up details in "Quantities" tab under the Inventory Items (10.25.00) screen.

    Else for more details you can use the Inventory Item Lookup(10.210.00) under Inquiries menu in Inventory Module. Simply select the Item ID and click the Availability button to view the Qty on Hand, Qty on Shippers, Qty on Purchase Orders and so on..

    Thanks & Regards

    D.Santhosh

  • Community Member Profile Picture
    Community Member on at

    Sorry, I didn't noticed ur Question fully... :)

    According to your question, Please check the below query result will resolve your clarification?

    Query:

    Select QtyOnHand,* FRom Itemsite where InvtID='XXXXX'

    XXXXX represents the Item ID

    Thanks & Regards

    D.Santhosh

  • Gail J-N Profile Picture
    Gail J-N 1,000 on at

    It might also be interesting to check out the "Scheduling" tab of the Inventory Setup screen.   When customer priority scheduling is turned off, then you can set your own options in the calculation of "Qty Available".    You could choose to "Include Purchase Orders" and to "Deduct Open Shippers", but not deduct "All sales orders".    If you choose to implement this, you'll need to stop and start process manager to correctly rebuild the Qty available values.

    Best regards,

    Gail J-N

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans