Working With Inventory Audit Report
If you are using a perpetual inventory configuration, the Inventory Audit Report is one of the most important reports for inventory and production areas. You may appreciate it during year-end closing activities, auditing or whenever there is a need to get to know details or summary from inventory journal, with possibility to use wide variety of selection criteria.
This report is used to make comparisons between the Accounting view (Inventory accounts) and the logistics view (Inventory value displayed by the Audit Report). The report explains the value changes in Inventory accounts. Only Inventory related transactions are displayed in this report. Transactions with non-inventory items, drop-ship warehouse or Service type documents are out scope of this report.
Inventory Audit Report has two types:
- Inventory Audit Report
- Batches and Serials Inventory Audit Report
- Inventory Audit Report provides an overview on inventory items. It allows an expanded view where you can drill down to individual transactions of selected items or you can use a collapsed view to display cumulative values and balances per item, warehouse or even G/L inventory account. All current valuation methods are supported and the information about valuation method can be also made available when using the expanded view.
- Batches and Serials Inventory Audit Report is a dedicated report for items with ‘Serial/Batch Valuation Method’. The report provides inventory valuation details per individual batches or serials numbers.
Both reports are available in the same path. Go to SAP Business One Main menu, choose the Inventory → Inventory Reports → Inventory Audit Report or Batches and Serials Inventory Audit Report.
How does Inventory Audit Report work?
The Inventory Audit Report – Selection Criteria windows.
You can use this report for different business requirement as given below:
- If you want to track of how system calculated item cost and transaction value of a specific item, then always select the System Date option in selection criteria window. The report will display all transactions chronologically based on creation date, which can be useful when reviewing details of inventory calculations or inspecting movements in the cost price across transactions.
- If you want to compare the G/L account balance with stock value for all or individual G/L inventory accounts for certain accounting period, then preferably select the Posting date option and all warehouses in selection criteria window. When you run the Inventory audit report by Posting Date and the posting date of transaction falls within the defined range, but the transaction system date falls outside the range, then report displays the row for this transaction in blue color.
- To compare the Inventory account balance with Audit Report for some selected account, select the G/L accounts checkbox in selection criteria window and select the accounts via click on browse button.
- If you manage item cost on the company level and not for each warehouse individually, select all warehouse without selecting ‘Group by Warehouse’ checkbox to see the accurate data in report. If company manages price per company, the checkbox is not visible. This information is listed in SAP Note 1279742.
Special case – price is managed per WH but since SNB valuation method is per company, the ‘Group by Warehouse’ should not be selected. We have added this to SNB valuation How to Guide.
- If an item has no transactions within the selected date range but has open transactions from previous period and you want to see the total of these open transaction as an opening balance of this item, then always select the checkbox ‘Display OB for Items/Accounts with no transactions’.
Once Inventory Audit Report show the transaction data, then some time text color of each transaction changes as follow:
- RED Text — If the transaction cause the cumulative quantity or the cumulative value to fall below zero, the text color of those fields is RED.
- Blue Text: — When you run the Inventory Audit Report by Posting Date then if the transaction’s system date deviates from the Posting Date range, the text color of this row is blue.
A sample view of Inventory Audit Report:
Please refer the below given some important SAP Notes and How to Guide documents related to Inventory Audit Report.
2374645 – Pagination Functionality in Inventory Audit Report — From SAP Business One 9.2 PL05 version for SAP HANA, the checkbox ‘Enable Quick Display’ is now available as an additional parameter in the selection criteria for the Inventory Audit Report to run the new report with pagination feature and enhancing report performance.
1281051 – Running Inventory Audit Report by Item Code or G/L Accounts
1099094 – Inventory Audit Report Shows Cumulative Value even with Zero Qty
1151677 – Difference Between Price in Document and Inventory Reports
1372625 – Blue lines in the Inventory Audit Report
1279742 – Group by Warehouse missing in Inventory Audit Report
2085843 – Inventory audit report – recommendations
- Tip 1: Did you know that Inventory Audit Report can be accessed directly from Item Master Data (by right-clicking) and it is a way of how you can directly and quickly open the report for the current item.
- Tip 2: For more detail about Inventory Audit Report Selection Criteria window, you can refer the page no. 83 of above listed document GL_B1_HTG_882_PerpInvent.pdf and page no. 50 of document How_to_Set_Up_and_Use_Serial_Batch_Valuation_Method_in_SAP_Business_One_9.3.pdf.
I hope you find this information useful and it keeps you well informed in your SAP Business One journey.
If I am running the Inventory Audit report to compare it to the balance sheet for inventory value, what date should be my start date - from inception of SAP or start of the fiscal year. If I run the report by Item from the start of the fiscal year (July 2018) it is $30,000 USD less than if I run it from July 2015, the date we started using SAP.
If you want to compare the Audit Report value with the Balance Sheet, then we will suggest you to always select the ‘Posting Date’ criteria and run Inventory Audit Report with ‘Summarize by Accounts’ option. However, in this case, you can select any date as "From Date" because Inventory Value before 'From Date' would be display as Opening Balance in Inventory Audit report.
you can select any date as “From Date” because Inventory Value before ‘From Date’ would be display as Opening Balance in Inventory Audit report.
If this is true then why do I have a $30,000 USD difference depending on what I use for my start date?
If you are still getting the value difference after using the ‘Posting Date’ criteria and ‘Summarize by Accounts’ option in Inventory Audit Report, then it could be a database or old SAP version corruption. We will suggest you contact the SAP support for further investigation of your case.
how to get real cost value of an inventory in sap which is being used in inventory audit report i mean i want's to know about tables being used in audit report for pricing
Can I use Inventory Audit Report when my user is not assigned to all branches and Manage Data Ownership by Branch is activated.
I can see data in Inventory Posting List with disactivated wharehouses which do not avalable to my user with such customization, but when I click on Inventory Audit report I'm getting an error.
"You are not permitted to perform this action. You are not assigned to all branches."