This report provides an audit trail for the posted inventory transactions in the chart of accounts.
You use this report to make comparisons between the accounting view (inventory balance accounts) and the logistics view (inventory value displayed by the audit report). The report explains the value changes in inventory accounts.
Note
When you print the report, you can also print the selection criteria on a separate page.
This report does not recalculate the cost but displays the information from the database.
The report is available only for companies using the perpetual inventory system.
To access the window, choose
.Note
To create what-if scenarios, use the Inventory Valuation Simulation Report - Selection Criteria.
Note This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
Select one of the following options:
The Inventory Audit report displays the relevant data accordingly. |
Enter the posting dates or system dates that you want to include in the Inventory Audit report. Note If you have included the posting dates of a purchasing document whose posting date differs from the system date, keep in mind that SAP Business One relates to the system date for the document when generating the Inventory Audit report. Even if you select Posting Date in the date dropdown list, if the system date is not included in the range of dates you select, the corresponding line in the report appears in blue. End of the note. |
Choose and then select the required properties from the Properties window. |
Select one of the following:
|
Select to group the items by warehouse. Note This option is activated only if both the following are true:
End of the note. |
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. |
To display the items in the report by warehouse, select the checkbox. Note This option is activated only if you have done both of the following:
End of the note. |