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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

On Order/Item Inquiry

(0) ShareShare
ReportReport
Posted on by 1,210

Hello,

I would like to know the reason why the amount of the Item Inquiry “On Order” field and the sum of the Purchase Line Items in SmartList show different results.

 

e.g.)

 

Item Inquiry- Item: aaa, Site: 01, Quantities: On Order 8,200

 

SmartList – Purchasing - Purchase Line Items (criteria) Item Number: aaa, Location Code: 01, PO line status: New  Result: 8 transactions, sum of the QTY ordered: 14,550

 

Please advise me.

 

Best regards,

 

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    7,365 on at
    Re: On Order/Item Inquiry

     From the item inquiry, can't you drill into the "On Order" amount to see what it consists of?  Is there a blue hyperlink that shows the "Purchase Order Processing Item Inquiry" Window?

    Po Line Status of "New" means the PO has not been printed (or released) yet.  Once it has been printed it turns to Released.  Those should be factored into your list as long as you are using the system that way.  Maybe "change orders" too.

    Having said that, there are also times when the subledgers get out of sync.  Try Reconciling (Utilities - Inventory - Reconcile) or even running "Check Links."  This might pick up on something.

     

     

  • K Day Profile Picture
    7,365 on at
    Re: Re: On Order/Item Inquiry

     One other thing, Quantity ordered is one thing, but have there been any partial receipts done against a PO?  How about trying some of the other fields in Smartlist (Quantity Shipped, Quantity Cancelled) and see if some combination of those exists to tie you out.  Like QTY Ordered - Qty Shipped = Remaining Open

  • Eri Yamaguchi Profile Picture
    1,210 on at
    Re: Re: On Order/Item Inquiry

    Thank you for your reply.

    I cannot drill into the "On Order". I click the blue hyperlink, but window didn't open. Is there any setting to see it?

    I will try Reconcile and Check links.

    Thanks!

  • K Day Profile Picture
    7,365 on at
    Re: Re: Re: On Order/Item Inquiry

     I'm not sure why you can't drill in but this might be controlled by your security model.  However, I would have expected it to say "You don't have security privileges to open this window" if that was the case.

    Maybe ask someone with more rights, preferable SA to log in and do the same thing and see what happens.  You can narrow it down from there.

  • Ron Wilson Profile Picture
    6,010 on at
    Re: Re: Re: Re: On Order/Item Inquiry

    EY,

    The On Order quantity regularly becomes out of balance in GP.  There is an active thread on this subject right now with the only solution being to Reconcile inventory.  This is your best bet.

    Ron

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans