Skip to Content

Inventory Audit Report

Jan 16 at 07:43 AM


avatar image

Dear Experts,

I want to ask a few question regarding Inventory audit report

1) What is the difference when we run inventory audit report by choosing GL account or not?

I tried to run both,

first, I only choose GL account for inventory, and get result,tally with balance sheet.

But, my issue is, the cumulative quantity for certain item has negative value.

Second, to avoid negative value for cumulative quantity, i do not choose any GL account, and get result positive value for all cumulative quantity, but not tally with balance sheet (balance sheet is lower than Inventory audit report)

Thus, I compared the result, to find out why when choosing specific GL account, I got negative value for the cumulative quantity,

I found out that, when I do not choose any GL account, the report will display all transaction, including items with zero cost (which supposed no Journal entry posted to it)

Can someone explain, why this happen and how inventory is work actually?

2) Is there any way to avoid the negative value at cumulative quantity, so that my report looks more normal?

Thank you in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jitin Chawla
Jan 16 at 09:03 AM


Check SAP Note 1281051 if the same clarify your questions on Inventory Audit Report.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Dear Jitin,

Thank you for your prompt response,

What I mean with GL Account is checkbox for G/L Account, not summarize by account.

forum.png (13.9 kB)