Hi there
We received a shipment of goods with 21 lines on the shipment/invoice. The data is showing correct on the purchase document but it (1 item out of the 21) doesn't show in inventory enquiries. I checked and the item in question is a Sales Inventory item on the shipment receipt. I then checked POP tables which shows correct, as well as SEE30303 and IV10200. The only table with the missing info is IV30300.
Will checklinks and reconcile create the missing record?
Do I have to manually insert it?
If I post an adjustment, the SEE30303 table will have duplicate records for this item.
Anyone experienced this before?
Regards
Riaan
Hello Riaan,
If the shipment line in question updated the IV10200, it updated your on-hand quantity. You would not want to do an inventory adjustment because the item is already there.
The only thing you are missing is the line in the IV30300.
My suggestion would be to create an insert statement that will add the record back into the IV30300. The support desk will not support this insert statement.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148