GRPO / Invoice did not appear in Inventory Audit Report

[rachel0322]

Hi SAP Experts,

I have problem with Inventory Audit Report. I found that it does not show some transactions. Some GRPO and AP Invoice did not show. I tried running the report using different selection criterias, but still, did not show all the GRPOs. FYI, I was also expecting some invoice to show because sometimes the Invoice amount is greater than GRPO, hence there was debit to Inventory Account and I need to tie Balance Sheet and Audit Report. Please help. Thank you.

Best regards,

Rachel

[kothandaraman_nagarajan]

Hi,

Share your selection criteria for Inventory Audit Report.

Regards,

Nagarajan

[Johan_H]

Hi Rachel,

The Inventory Audit report only takes transactions into account with items, so not service documents, and also not manual JEs posted to the given stock account.

Other reasons are usually that the expected stock transaction occurred from or to a warehouse that was deselected, or the document (e.g. delivery, invoice) actually falls outside the given time period.

Regards,

Johan

[rachel0322]

Hi Johan,

Thanks for your reply. The item is inventory type and the GRPO/Invoice is Item Type. All warehouses had been selected when running the report. I also run the report without From Date and put current date in To Date to get all records from Day 1 to present day. I run by Item not by GL Account. I notice some invoices with particular scenarios is not reflected. I tested this scenario:

Invoice earlier than GRPO with different rate

Sometimes it appears in the report, sometimes it doesn't.

Do you know why it won't appear? I checked in OINM table, it is there.

Also I tested another scenario:

GRPO got discount of .01. When user created the Invoice, they removed the discount and put it in rounding amount instead. This debited inventory account by .01 but was not reflected in audit report.

Best regards,

Rachel

[Johan_H]

Hi Rachel,

You say the invoice was earlier than the delivery. Stock movements are generally created by the Delivery document. Only if you create a stand-alone invoice, will it create the stock movements, and would it thus show up in the audit report.

The Inventory Audit Report shows how the value of your stock has come about, not the balance of a stock account, so it would reflect neither a .01 discount nor a .01 rounding to the entire document.

Regards,

Johan