Historical Inventory Valuation

Form ID: (IN617000)
Note: This report is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.

This report displays information about how the balances of the inventory accounts and the costs of the inventory items at different warehouses have changed in the selected time period or range of periods.

The report is available in two formats: summary and detail. In the summary format, the report displays summary data for each inventory account (and subaccount, if applicable) resulting from operations with inventory items. In the detailed format, the report displays information about each cost subitem in each warehouse involved, and includes the quantities and costs of the items with subitems moving through the warehouse during the selected financial period or range of periods.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Company/Branch: The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access or leave the box blank to view information about all companies in the tenant.

    This parameter is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

  • Format: The format for the report, which can be Summary or Detail. If you select Detail, you need to select an inventory ID.
  • Start Period: The starting financial period for the report.
  • End Period: The ending financial period for the report.
  • Inventory ID: The inventory ID of the item the report will cover. Select an ID to view only data related to this item, or leave the box blank to view a broader range of data.
  • Company/Branch: The company or branch for which you want to view information. You can select a company or make no selection to view information about all companies in the tenant.

    By default, the system inserts the company or branch selected on the Company and Branch Selection menu.