I have an inventory receipt totalling $19,626.15, however the individual item landed costs do not total to this amount and there is an item missing. When I go the receipts audit list,the missing item is there and the receipt totals $19,308.34. However there are two other entries on the audit list referencing this same receipt number one has a reference of adjustment for $316.93 and the other a return of $0.88. When you add the original receipt amount of $19,308.34 and the adjustment and return, you get the total shown on the receipt of $19,626.15. However the individual transactions of the adjustment and the return do not appear. I suspect the receipt may have been edited, but have no way of knowing edited by whom and why. Any thoughts as to why the receipt does not match the details in the audit list?

Could an item have been deleted from the originally entered receipt? You said a missing item appears on the audit list - could the receipt have been edited and that item deleted?

Possible. If an item is deleted should this not show as a receipt return?

How can I tell on the audit lists who performed this function? There are two persons who have rights to do this task and both are claiming ignorance.

We don't currently track user information for IC transactions.

If an item is deleted should this now show as a receipt return.

We printed the physical inventory worksheet, created the adjustment workfile, did a physical inventory and adjusted according to the physical count. However, the quantity on hand per the physical inventory reconciliation sheet and what is shown on the stock card at that date are materially different. I only checked for one particular item as we have an issue with this. When you do an item enquiry it is showing the amount on hand at 15k however lot 1 shows 17k on hand.

How is this possible?

You have 2K on order? You have -2K in FIFO/LIFO buckets 2,3,4 or 5?