Inventory Value Summary For A Period

This report allows you to view the summary of the inventory values for the chosen financial period. Report Information.

Select the “Inventory Value Summary For A Period” link under the “INVReports” business component.

The “Inventory Value Summary For A Period” page appears.

Enter the following field details in the “Search Criteria” group box:

Summary Report For

Use the drop-down list box to select the level at which you want to view the inventory summary report. The options available in the drop-down list box are “Warehouse”, “OU” and “BU”. The system displays “OU” as the default value on launch of the page.

Note: Warehouse code is selected only if Warehouse option is chosen.

Warehouse Code	Use the drop-down list box to select the warehouse code.
Item Selection Options	Use the drop-down list box to select whether the items for which you want to view the inventory values is based on “Item Type” or “Item Group”. The system displays “Item Type” as the default value on launch of the page.

Note: Item Group Selection Option is selected only if the “Item Group” option is chosen in the Item Selection Options drop-down.

Item Account Group

Use the drop-down list box to select the item account group. The combo is loaded with “All” and active item account groups.

The system displays the following detail:

Description

The description of the Item account group.

Enter the following in the "Item Group Based Selection" group box :

Category	Use the drop-down list box to select the category of the item group. The combo is loaded with options "System Defined" and "User Defined".
Usage	Use the drop-down list box to select the usage of the item group.
Group Type	Use the drop-down list box to select the group type. The system retrieves all the group type codes defined for the login OU’s and LO in ascending order. The system displays blank as the default value on launch of the page.

Item Group Selection Option

Use the drop-down list box to select whether the item group is “Group type based” or “Item Attached Groups”.

Note: Item Group Code is selected only if “Item Attached Groups” is chosen in Item Group Selection Option drop-down.

Group Code

The code identifying the group.

The system displays the following detail:

Group Code Desc.

The description of the Item Group Code.

Enter the following detail :

Item Group Code

Use the drop-down list box to select the Item Group Code. The system retrieves all the active Item group in which Items are attached to it in the ascending order. The first value in the drop-down list box is displayed as the default value on launch of the page.

The system displays the following detail:

Group Code Desc.

The description of the Item Group Code.

Note: Fields in Group Type Based Selection are selected only if “Group type based” option is chosen in Item Group Selection Option drop-down.

Enter the following detail:

All Item Types

Check this box if you want to view “Inventory Value Summary For a Period” for all the item types specified in the “Item Type Selection” group box. This field is checked by default on launch of the page.

Enter the following in “Item Type Selection” group box:

Raw Material	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Raw Material” alone.
Intermediate	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Intermediate” alone.
Utility	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Utility” alone.
Finished Product	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Finished Product” alone.
Spare Part	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Spare Part” alone.
Pack	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Pack” alone.
Component	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Component” alone.
Tool	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Tool” alone.
Scrap	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Scrap” alone.
Consumable	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Consumable” alone.
Phantom	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Phantom” alone.
Sundry	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Sundry” alone.
Container	Check this box if you want to view “Inventory Value Summary For a Period” for the Item Type “Container” alone.

Enter the following details in Financial Period Selection group box:

Financial Year

Use the drop-down list box to select the financial year. The system retrieves all the financial years defined for the company from the Accounting Setup Component along with a blank value. The financial year retrieved must has atleast one closed financial period. The system displays the default value as blank.

The system displays the following details:

Financial Year Start Date	The starting date of the financial year selected.
Financial Year End Date	The ending date of the financial year selected.

Enter the following detail:

Financial Period

Use the drop-down list box to select the financial period. The system retrieves the financial periods defined for the financial year selected for the company from the Accounting Setup Component. The financial period displayed must be on or before the system date. The values are populated in ascending order with blank as the default value.

The system displays the following details

Financial Period Start Date	The starting date of the financial period selected.
Financial Calendar End Date	The ending date of the financial period selected.

For viewing the report

Click the “View Report” pushbutton to view the inventory values.

Inventory Value Summary For A Period – An overview

You can view values such as Period OB (Opening Balance) Value, OB value, Receipt Value, Issue Value, Return Value, Adjustments Value, Revaluation Value and Period CB (Closing Balance) Value.

You can specify the level at which you want to view the inventory values that is, OU, BU or Warehouse and other search conditions for viewing the report.

You can select the Item Selection Option from the drop-down list box. The options available are “Item Group” and “Item Type”.

Item Group – You must select a value from the “Item Group Selection Option”. The options available are “Group Type Based” and “Item Attached Groups”. Group Type and Item Group at different Levels must be selected if the first option is chosen. The Item Group Code is to be selected if the second option is chosen.
Item Type – You can select one or more or all the type of item for which you want to view the inventory values.

The financial year is specified, based on which the corresponding financial periods are retrieved. You can choose a financial period for which you want to view the inventory values.

Output For the Report “Inventory Value Summary for a Period”:

Header Information:

It displays the respective BU/OU/Warehouse, which was selected in the Entry. It displays the Financial Period and Financial dates based on the date selection option, which was chosen in the entry page. If nothing was selected it displays the current financial year and the financial period. It also displays the Group code / Group type based on the selection in the entry page in the “Item group selection option “. The Base Currency and a Unique “Report ID “ are also shown.

Column Information:

The column fields displayed are Item type, Period Opening Balance, Opening Balance value, Receipt value, Issue Value, Return Value, Adjustment value, Revaluation value, Period Closing Balance Value.

Note: Respective OU and Warehouse codes are displayed at the header of each group by table

- Item types will be displayed in the Item type column.

- If the current financial period is the first period then the opening balance will be be zero else the previous period’s closing balance is taken as this period’s opening balance and it’s displayed in the Period Opening Balance column.

- The system gets the opening balance value, Receipt value, Issue value and Return value for the selected period from the corresponding components and displayed in the respective columns.

- The system gets the net adjustment value (all the positive and negative value are consolidated to give the net value) and net revaluation value for the selected period and it’s displayed in the respective columns that is, in Adjustment value and in Revaluation value columns.

- Period Closing balance value is calculated as: Period OB value + OB value + Receipt value + Return value + Adjustment value + Revaluation value - Issue value+ stock transfer in value - stock transfer out value and displayed in the Period CB value column.

Footer Information:

The date and Time of running the report will be displayed at the bottom left side of the report.

Corresponding page number will be displayed at the bottom right side of the report.