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
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
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.
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!
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (