Generating Stores Ledger with Value

In this activity, you can generate the stores ledger with value report.

Select the “Generate Stores Ledger with Value” link under the “Stock Management Reports” business component.

The “Generate Stores Ledger with Value” page appears.

The system displays the following:

Date Format

The format in which the date fields must be entered in this page. This format is displayed from the "User Preferences" business component based on the login user id. In case the date format is not defined, the system displays the Organization level format.

Enter the following in the “Report Criteria” group box:

From Date	The starting date, in the range of dates, for which the Stores Ledger with Value report is to be generated (Date format).
TO Date	The ending date, in the range of dates, for which the Stores Ledger with Value report is to be generated (Date format).

Note: Ensure that "From Date" is less than or equal to "To Date.

From Part #	The starting number, in the range of part numbers, for which the report must be generated (Alphanumeric, 40). You can enter the number in full or specify it partially using the "*" character.
To Part #	The ending number, in the range of part numbers, for which the report must be generated (Alphanumeric, 40). You can enter the number in full or specify it partially using the "*" character.

Note: Ensure that “From Part #” is less than or equal to “To Part #.

Location	Use the drop-down list box to select the organization unit for which the report must be generated. Leave this field blank to generate the report irrespective of the location.
Warehouse #	The warehouse number for which the report must be generated (Alphanumeric, 10). You can enter the number in full or specify it partially using the "*" character.
Part Type	Use the drop-down list box to select the type of part as “Component”, “Expendable”, ”Kit”, “Consumable”, “Tool”, “Raw Material” or “Miscellaneous”. Leave this field blank to generate the report irrespective of the part type.
Part Category,	Use the drop-down list box to select the part category. The system lists all the active part categories defined in the “Part Administration” business component. By default, the system leaves the field blank.
Part Group,	Use the drop-down list box to select the part group. The system lists all the active part groups defined in the “Part Administration” business component. By default, the system leaves the field blank.
Stock Status	Use the drop-down list box to select the stock status of the part. The system lists all the active stock statuses defined in the “User Defined Stock Status” business component. By default, the system leaves the field blank.

Enter the following in the “Report Options” group box:

Report Action	Use the drop-down list box to select the report action. The system lists the following options:
	Print – Select this option to print the report.
	View Report – Select this option to view the report.

Select the “Generate Stores Ledger with Value” link to generate the stores ledger with Value report.

Note: Ensure that the “Stock Valuation” batch processes are configured and updated in the Daemon Executor. For more details, refer to the Daemon Executor Online Help.

Select the “Generate Stock Value Report” link to generate the stock value report.