Skip to Content
avatar image
Former Member

Inventory audit is not equal to inventory posting

Hi Experts,

How come Audit report for a specific item is note equal to item's quantity for inventory count?

How can it be resolved?

Here's an screenshot of the sample items

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Oct 25, 2016 at 06:54 AM

    Hi Marjie,

    Please first use the Restore Item Balances tool (Help > Support Desk > Restore > Restore Item Balances).

    Remember to make a backup of the company database before you use this tool.

    regards,

    Johan

    ,

    Hi Marjie,

    First thing you should try is to run the Restore item Balances tool (Help > Support Desk > Restore > Restore item Balances).

    Please make a backup of the database first, and preferably run the tool only for affected items.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 08:13 AM

    Hi Marjie,

    The Audit report is specifically meant to determine how a certain inventory has come about. Please run the report for this item only, for a couple of months (depending on how actively the item is traded).

    If from this you cannot determine why the inventory number is what it is, please contact your SAP Partner. They can look at the actual data and can determine whether this is a bug or otherwise they can explain the difference.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 08:34 AM

    Dear Marjie

    If you type the count date 1/10/2016, what is the result?

    Regards

    Edmund

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 10:57 AM

    Hi Marjie,

    Okay, have you checked SAP Notes for the customer's B1 version?

    Perhaps it is time to report this to SAP as a bug.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 08:18 AM

    Hi,

    Long back we faced this kind of a problem where inventory audit report figures were not going with trial balance. With the help of the partner, we executed an inventory valuation check tool on DB and fixed it.

    Kindly go through this link. It may be helpful to you.

    https://archive.sap.com/discussions/thread/2042595

    Regards

    Narayani

    ,

    Hi,

    I faced this kind of issue long back on one of my client's place. In our case our audit report and trial balance figures were not matching. And happen to sort it out with the help of some utility which you have to run on DB with the hep of your partner.

    https://archive.sap.com/discussions/thread/2042595

    Kindly go through this. May be it will help you.

    Regards

    Narayani

    Add comment
    10|10000 characters needed characters exceeded