6,775
After receiving a line item on a PO, GP still shows on-hand and available quantities as zero. The status on the PO and line item are closed indicating they are received and matched to the invoice. Why doesn't GP read the on-hand qty? What can be done to resolve?
We have run Reconcile and CheckLinks
*This post is locked for comments
Thanks Mohammad. I checked the above and the item was a Shipment/Invoice that affected the vendor balance.
After viewing through multiple zooms/inquiries, I see a message indicating it is a non-inventoried item. Since the item is a 'non-inventoried item' in GP, GP does not track quantities or provide zooms for this item. The only cause I can conclude is that a user for some reason added the item as non-inventory in the PO or when it was received. I attempted to search in Cards > Inventory > Item for a setting to change, but do not see a setting to change the item from inventory to non-inventory.
Is it possible that the user received the item as non-inventory? How can we adjust for this so that the quantity is tracked in GP?
Thank you.
You cannot fill the missing lines into IV10200 directly, many fields are required that could not be known to end users.
Your solution to the case would be first investiating the effect of your receiving on the database, check the following:
1. Was the receiving "Shipment" only or "Shipment/Invoice"?
2. If it was Shipment/Invoice, did that affected your vendor balance?
3. If yes then your AP is doing fine and you only need to fix your inventory balances by doing an adjustment without GL effect.
4. Did that affected GL correctly? If not you need o correct this as well.
5. If that didn't affect anything! Then you can safely redo the receiving again with different number.
It would not be recommended that you make changes to the IV10200 using SQL. Do a manual adjustment to get the quantities into inventory.
Interesting... The 'normal' item without the error has records in IV10200 but the item with these errors does not. I guess history is maintained but removed at some point. Is there a way to populate that record in IV10200 table for the item with the errors? Or is that not recommended?
Thanks for your replies by the way. Much appreciated.
If this is an inventory item and the history maintained, it should show record in IV30300 and IV10200, checklinks will not populate thi table.
The IV10200 is blank for this item ! Should I run CheckLinks to populate?
I compared the item with this issue to another item that appears correctly in GP. Both have no records in IV30300 so I assume that is normal.
I was not able to view trx history for the items because they have been removed unfortunately. But if the IV10200, I imagine it could not be due to negative quantities?
You either had your item quantity in minus prior to the post operation or your inventory tables were not affected with the post operation, you need to verify what was the effect of your transaction and correct that manually, I would suggest you contact your partner to validate, you will need to check the below:
1. Check out the transaction history for your item and make sure that the quantity for your item wasn't negative before posting the receiving, and check if your receiving is shown in the list.
2. Since you ran Reconcile and Quantity was not changed, check IV10200 table and check if the receiving is there.
3. Check IV30300 table and verify if it was affected by the receiving.
4. Check your vendor record and make sure that the invoice was created against your vendor account.
#1
André Arnaud de Cal...
292,865
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
