AdvanceOne Media News

SAP Business One in the News

/ Categories: SAP Business One

How to Access and Generate the Inventory Audit Report in SAP Business One

by Cherry Hidjaja

One of the real values of SAP Business One is its perpetual inventory system. The perpetual inventory system immediately updates every transaction processed, no matter what area of the business the transaction originates from including sales, purchasing, production, receiving, shipping or general inventory management.


One of the most telling reports in SAP Business One is the Inventory Audit Report. This report shows the entire history of every transaction and allows you to drill to the exact document that impacted the item balance in any way.

This report is useful for when you want to make comparisons between the accounting view and the logistic view as it explains the value changes in inventory accounts. Although this report does not recalculate item costs, the report does display the information from the database.


To access the inventory report, choose Inventory > Inventory Reports > Inventory Audit Report.

And the following window will appear to generate the inventory audit report.


Here are the selection criteria fields when you want to generate an Inventory Audit Report and their definition:

  • Date Type list:
    You can select one of the following options:
    • Posting Date
    • System Date 
  • Date From…To….
    Enter the posting dates or system dates that you want to include in the Inventory Audit Report
  • Properties
    Choose and then select the required from the Properties window.
  • Display
    Select one of the following:
    • By Items – view and audit the results by items
    • Summarize by Accounts – view the information summarised by accounts
  • Group by Warehouse
    Select to group the items by warehouse
  • Display OB for Items/ Accounts with no Transactions
    Select this checkbox to display the opening balances for items or accounts that have no transactions posted in SAP Business One.

If an item has no transactions within the selected date range but has open transactions from previous periods, the total of these transactions is presented as an open balance for this item. As a result, the report total displays the item valuation from the end date of the defined date range - that is, it contains both the opening balance figures and the transactions that are within the defined date range.


Once the fields are populated, the Inventory Audit Report will display the relevant data accordingly.

Tip: When you print the report, you can also print the selection criteria on a separate page.


Previous Article What is Cycle Counting and How it Eliminates ’Shut Down’ Inventory Audits
Next Article 10 Questions to Consider When Assessing Inventory Control Effectiveness
4760 Rate this article:

Please login or register to post comments.

Contact Us

If you have any questions, please e-mail us without hesitation. We will reply to you as quickly as we can. MORE!

  • Whatever your business vision is, SAP can help make it real. From Cloud and high speed analytics technologies to mobile and in-memory computing solutions.

    SAP Business OneFrom AdvanceOne
  • SAP HANA is an in-memory computing platform that has completely transformed the relational database industry.

    The Answer is simple, The Answer is SAP Hana