web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Inventory On Order Qua...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Inventory On Order Quantity

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 797

#2

André Arnaud de Cal... 589 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans