As most of you know, the common question about the inventory report in SAP Business one is: “Why my Inventory Audit Report does not match my inventory G/L account balance?”
Well, the simple answer would be: “Because you have Manual Journal Entries created with the Inventory G/L accounts.”
But, as you may find in some SAP notes, Manual Journal Entries are not the only reason.
Here I’ll provide some queries that you can run to compare the results of the Inventory Audit Report and other transactions that can cause the inventory G/L accounts to have a different balance.
Inventory audit report per G/L account
Manual Journal Entries to inventory G/L accounts
Service AP Invoices and/or Credit Memos
Goods Issue or Goods Receipt with the wrong offset account
Inventory Revaluation with wrong offset account
Please let me know if you guys find any other kind of transaction that can affect the inventory G/L accounts.
In my next post I’ll talk about some macros that are possible to be created using the B1 Usability Package and can make the life of the customers and the consultants easier.
Stay tuned!
SAP B1 Tips 