Show TOC

Object documentationInventory Audit Report - Selection Criteria Locate this document in the navigation structure

 

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 Note

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

End of the note.

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   Inventory   Inventory Reports   Inventory Audit Report  .

Note Note

To create what-if scenarios, use the Inventory Valuation Simulation Report - Selection Criteria.

End of the note.

Note 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.
Inventory Audit Report – Selection Criteria Fields
Date Type List

Select one of the following options:

  • Posting Date

  • System Date

The Inventory Audit report displays the relevant data accordingly.

Date From....To....

Enter the posting dates or system dates that you want to include in the Inventory Audit report.

Note 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.
Properties

Choose and then select the required properties 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 summarized by accounts

Group by Warehouse

Select to group the items by warehouse.

Note Note

This option is activated only if both the following are true:

  • In the Display area, you have selected the By Items radio button.

  • In the Company Details window, on the Basic Initialization tab, you have selected the Manage Item Cost per Warehouse checkbox.

End of the note.
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.

Country-Specific Field: China
Group by Warehouse First

To display the items in the report by warehouse, select the checkbox.

Note Note

This option is activated only if you have done both of the following:

  • In the Display area, select the By Items radio button.

  • In the Company Details window, on the Basic Initialization tab, select the Manage Item Cost per Warehouse checkbox.

End of the note.

More Information

Inventory Audit Report