Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory On Order Qua...
Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory On Order Quantity

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are trying to replicate the On Order quantity that shows on the Vendor Item Quantities Inquiry window..

Here is the formula that we are trying:

  qtyorder from pop10110 (the PO Line table)

- qtycance from pop10110

- qtyshpd from pop10500 (the PO Receipt Line table)

+ qtyrej from pop10500

We are comparing this to qtyonord from iv00103 (Vendor Item Quantity table)

My numbers just aren't tying out as expected.  Are the above tables in sync?  Or do they clear to history differently?  And if the latter, how is reconcile REALLY calculating this quantity field?

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: Inventory On Order Quantity

    Hi Cindy,

    The table IV00103 may not be updated before the documents are all posted. You might also want to consider the PO Line Status to make sure you compare open order (release) with already received / cancelled ones.

    Taking the Fabrikam company as an example, my Item PHON-GTE-3458 is showing up in 3 PO's for a total quantity of 14 units, but they are all 3 in different status (Released, Closed, Cancelled), and the only item 'released' is = 4, which is on par with the QTYONORD for that Item / Vendor combination in IV00103.

    Keep in mind that POP documents remain in the work table even after they are closed, until someone moves them into history by running a reconcile/remove.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans