Skip to Content

Inventory Audit Report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 16 at 09:03 AM

    Hi,

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

    regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded