Inventory audit report and trail balance amount miss mismatch

[Underdog]

Hi All,
There is missmatch for some accounts balance in Inventory Audit Report and Trail Balance , In SAP B1, what can be the possible reason behind this miss match ?

For example as on 31/12/2024

1040080 - Raw Materials - is showing  17,11,57,815.03 amount in Trail Balance and showing  17,17,79,934.85  as per Inventory Audit Report.

Need guidance for investigating it.

[hdolenec · Accepted solution]

Usually, the reason for this is one of the following:

• there are manual postings to stock GL account (this might be manual JE, or simply manually choosing stock GL account on a document that does not affect stock value)
• in account determination, stock GL account is used for posting something else other than stock value (for example, if stock GL account is set as expense account, price difference account or something similar)

[MarcelaK · Accepted solution]

Yes, posting to GL without material document would make miss reconciliation between MM and FI reports. (in FS00 the stock account has NO Auto posting only)

[MarcelaK]

Transaction - Fiori app MB5L - List of Stock Values: Balances can show the detail of the differences. We can select whole Company Code values per previous period and tick on Display Indiv. material. The list will help to identify the material in issue. Investigation of the document of such NOK material will help to find the issue. The issue could be caused by material price update without proper update to GL (i.e. stock transfer between materials which have different price).