Inventory Valuation

Form ID: (IN615500)

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

This report displays information about the quantities on hand and the total cost of inventory by inventory account, with details for different warehouses.

The report is available in two formats: summary and detailed. The report in the summary format displays only summary data for each warehouse. The detailed report displays information about the operations performed for each inventory item in each warehouse; it includes the beginning and ending quantities and costs, and the reference numbers of the relevant inventory documents.

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.

  • Inventory ID: The inventory item the report will cover. Select an inventory item to view only data related to this item, or leave the box blank to view a broader range of data.
  • Inventory Class: The item class for which you want to display information. Select an item class to view only its data, or leave the box blank to view a broader range of data. If the item class that you selected has child item classes, the report will display information for the items of the selected class along with information for the items of these child classes.
  • Inventory Subitem: The subitem the report will cover. Select a subitem to view only data related to this subitem, or leave the box blank to view a broader range of data.

    This box is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form.

    Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
  • Warehouse: The warehouse for which you want to display data. Select a warehouse to view only data for this warehouse, or leave the box blank to view a broader range of data.

    This box is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features form.

  • Report Format: The format for the report, which can be Summary or Detail.
  • 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.