Inventory audit is not equal to inventory posting

[Former Member]

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

[Johan_H · Accepted solution]

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

[Former Member · Accepted solution]

I did, but when I do the inventory count it is still the same.

[narayanis]

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

[Johan_H]

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

[Former Member]

Dear Marjie

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

Regards

Edmund

[Johan_H]

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

[Former Member]

We are the partners, And I'm needing an explanation for the users.