Inventory Audit Report

This report displays the total inventory value for the items according to the selection criteria configured in the Inventory Audit Report - Selection Criteria window. The fields that appear in the report depend on whether By Items or Summarize by Accounts was selected.

Note Note

The inventory audit report updates the last calculated price list.

End of the note.

Note Note

If the report is based on posting dates, and includes inventory items whose purchasing system dates deviate from the selected date range, these rows appear in blue in the inventory audit report.

End of the note.

The report is expandable and contains up to three levels. Each level displays summary information for the level below.

Note Note

If you select the Enable Quick Display checkbox in the Inventory Audit Report — Selection Criteria window, the report is not expandable, and you can select the Detailed or Summary view for the report.

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 Fields

Date From .... To....
Displays start and end dates for the report calculations, as defined in the selection criteria.

Currency
Displays the company’s local currency.

Items
Displays a range of items included in the report, as defined in the Inventory Audit Report – Selection Criteria window. If you have not defined any items in the Code fields, the Items field displays All. If you have selected two or more criteria types, the field displays Multiple. Note This field appears only if you select the By Items radio button in the Inventory Audit Report – Selection Criteria window. End of the note.

Warehouses
Displays the warehouses included in the report as defined in the selection criteria. If you have selected all warehouses, the field displays All. Note This field appears only if you select the By Items radio button in the Inventory Audit Report - Selection Criteria window. End of the note.

Accounts
Displays the range of accounts to be included in the report, as defined in the selection criteria. Note This field appears only if you select the By Items radio button in the Inventory Audit Report - Selection Criteria window. End of the note.

Document
Displays the abbreviated name of the document.

Quantity
Displays the change in inventory resulting from the transaction. If the field is empty, this indicates that there was a change only in the cost in the specific transaction.

Cost
Displays the cost of the item in the transaction. The summarized cost is calculated as Cumulative Value/Cumulative Cost. The item cost cannot be used for the report because it would need to be up to the current date.

Trans. Value
Displays the value that was posted to the inventory account.

Cumulative Qty
Displays the total quantity in stock after the transaction. At the summary levels, it summarizes the quantities from the lower levels, up to the report end date. Transactions that cause the cumulative quantity to fall below zero are highlighted in red when you display the expanded view of the report.

Cumulative Value
Displays the total value of inventory after the transaction. Transactions that cause the cumulative value to fall below zero are highlighted in red when you display the expanded view of the report.

G/L Account
Displays the account number.

Balance from G/L
Displays the G/L account balance in the chart of accounts for the report's end date. Use this information to compare information of the report and the G/L. This is relevant only when you run the report up to the current date. Note This field appears only if you select the Summarize by Accounts radio button in the Inventory Audit Report - Selection Criteria window. End of the note.

Go to Row
Enter a row number and press `Tab` to display the data starting from this row. Note The input number must be a number between 1 and the maximum row number. End of the note. Note This field is available when you select the Enable Quick Display checkbox in the Inventory Audit Report – Selection Criteria window. End of the note.

Display <Number> Rows
From the dropdown list, select a number of rows that you want to display in the table as one page. Note The number that you select decides the row number shown in the following four buttons: First <Number> Rows – Choose this button to display the data in the first page of the table. This button is disabled if the current display is the first page. Previous <Number> Rows – Choose this button to display the data in the previous page of the table. This button is disabled if the current display is the first page. Next <Number> Rows – Choose this button to display the data in the next page of the table. This button is disabled if the current display is the last page. Last <Number> Rows – Choose this button to display the data in the last page of the table. This button is disabled if the current display is the last page. End of the note. Note This dropdown list is available when you select the Enable Quick Display checkbox in the Inventory Audit Report – Selection Criteria window. End of the note.

Total Value
Display the cumulative value of all the data that meets the selection criteria. Note This field is available when you select the Enable Quick Display checkbox in the Inventory Audit Report – Selection Criteria window. End of the note.

Production Std Cost
Displays the production standard cost of the item as defined in the Item Master Data window.

Total Production Std Cost
Displays the total production standard cost as calculated on the BOM.

View
Select the appropriate view to display the data: Summary – Select the Summary option to display each item data consolidated in one row in the table including the basic information. Note that this option is selected by default. Detailed – Select the Detailed option to display detailed transactional data for each item. Note This dropdown listis available when you select the Enable Quick Display checkbox in the Inventory Audit Report – Selection Criteria window. End of the note.