Navigation:  Inventory Management >

Inventory Evaluation Report

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

The Inventory Evaluation Report can be used to calculate the value of inventory in a specific store or Division for reconciliation purposes as well as to supply a list of items in stock for a specified selection.

The report will create the output in MS Excel from where it can be printed or saved. The report set will automatically select the Cost option as set on System Configuration for the database and use either the Average or Standard cost view on inventory to value the inventory as per the selection.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus1Division

If no Division is selected the report will select all the inventory in he company, regardless of the division and in all stores. If a Division is selected, only the inventory that belongs to a specific Division will be included in the selection. It will however select all the inventory out of all stores in the selected division unless of the other selections are made.

hmtoggle_plus1Financial Year

The financial year will be disabled if the database from which the report is run has a stock valuation method of Average Cost. In Standard Cost mode the Financial year must be selected. It will default to the current financial year. The selected financial year will be the base from which the inventory is valued in the Standard cost mode. This will determine the Part Financial year data to be used for evaluation.

hmtoggle_plus1Fixed Account Only

The setting for fixed account is enabled to be unchecked only if the setting limit to items in balance sheet is unchecked. If the above setting is checked, the fixed account setting will be checked and disabled, but if the setting limit to items in balance sheet is unchecked the fixed account setting can be either checked or unchecked. The setting will if checked only include inventory of fixed account parts in the selection for the report while if unchecked it will include all inventory in the report regardless of the fixed account setting on it's part master.

hmtoggle_plus1Limit To Items In Balance Sheet

If the checkbox limit to items in the balance sheet is checked, Only Fixed account parts with inventory which has a stock status of either new or used, and where the inventory does not belong to an external organisation will be valued and will be shown in the report. If however the checkbox is unchecked, all inventory will be included in he selection  i.e. Non-fixed account, Repaired and Waiting repair stock as well as stock belonging to external organizations.

hmtoggle_plus1Node

The Node can  be individually selected or can be selected in conjunction with the other settings.  If the Node is selected, only inventory that belongs to the selected Node will be included in the selection, whereas if the Node is left blank, the inventory of all nodes as well as inventory that does not belong to any nodes will be included.

hmtoggle_plus1Organisation

The Organisation can be individually selected or can be selected in conjunction with the other settings.  If the organisation is selected only inventory that belongs to the selected organization will be included in the selection, whereas if the organization is left blank, the inventory of other organizations as well as inventory that does not belong to other organizations will be included. Because inventory that belongs to external organizations is never valued in the balance sheet, the Organisation combo is only enabled when the checkbox balance sheet inventory is unchecked.

hmtoggle_plus1Product

The product code can  be individually selected or can be selected in conjunction with the other settings.  If the product code is selected, only inventory that belongs to the selected product code will be included in the selection, whereas if the product code is left blank, the inventory of all products will be included.

hmtoggle_plus1Project

The Project can  be individually selected or can be selected in conjunction with the other settings.  If the Project is selected, only inventory that belongs to the selected Project will be included in the selection, whereas if the Project is left blank, the inventory of all Project as well as the inventory that does not belong to a project  will be included.

hmtoggle_plus1Run

When the Run button is clicked,  the report will be executed as per the settings above and the result will be exported into a preconfigured excel report.

hmtoggle_plus1Show Locations With Negative Stock

The setting show items with negative stock will, if checked, limit the selection for the report to items with negative locations.

hmtoggle_plus1Stock Account

The stock account which are on the store may be varied between different stores of the same Division. If an account is selected, only the inventory that belongs to stores which features the selected account will be selected for evaluation and for the report.

hmtoggle_plus1Store

If a store is left blank, all inventory within the previous selection will be selected for evaluation, but if a store is selected only the inventory that resides within the store will be included in the selection.

hmtoggle_plus1View Quarantined Stock Only

This is a checkbox which can be checked individually or in conjunction with any of the other settings. If checked, only stock which is in quarantine will be selected for the report whereas if left unchecked, all inventory will be selected for the report.