Show TOC

Object documentationInventory Audit Report Locate this document in the navigation structure

 

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

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