SAPB1 Guy / Tuesday, August 23, 2016 / 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 Print 3973 Rate this article: 5.0 Tags: SAP Business OneSAPB1SAP B1SAPInventory Audit Report Please login or register to post comments.