purchase receipt not showing in inventory

(0) Share

Report

Posted on by Riaan Taljaard

536

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

Categories:

Distribution

All responses (1)

Answers (0)

Becky Berginski on at

Like (0)

Report

RE: purchase receipt not showing in inventory

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.