Inventory Value Summary As On Date
|
|
|
|
|
This report allows you to view the summary of the inventory values between the starting date of the current financial period to till date. Report Information.
Select the “Inventory Value Summary As On Date” link under the “INVReports” business component.
The “Inventory Value Summary As On Date” 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 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. The system retrieves all the non-capital warehouses applicable for the login OU in ascending order with the first value as the default value on launch of the page. |
|
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” , "Item Account Group" 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 entered only if “Item Attached Groups” is selected 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 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 in the “Group Type Based Selection” group box:
|
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 . |
Enter the following detail:
|
All Item Types |
Check this box if you want to view “Inventory Value Summary as on Date” 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 to view “Inventory Value Summary as on Date” for Item Type “Raw Material” alone. |
|
Intermediate |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Intermediate” alone. |
|
Utility |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Utility” alone. |
|
Finished Product |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Finished Product” alone. |
|
Spare Part |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Spare Part” alone. |
|
Pack |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Pack” alone. |
|
Component |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Component” alone. |
|
Tool |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Tool” alone. |
|
Scrap |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Scrap” alone. |
|
Consumable |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Consumable” alone. |
|
Phantom |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Phantom” alone. |
|
Sundry |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Sundry” alone. |
|
Container |
Check this Box to view “Inventory Value Summary as on Date” for Item Type “Container” alone. |
For viewing the report
Click the “View Report” pushbutton to view the inventory values.
Inventory Value Summary As On Date – An overview
You can view values such as PTD (Period To Date) Opening Balance Value, PTD Receipts value, PTD Issues Value, PTD Returns Value, PTD Adjustments Value, PTD Revaluation Value and Current Inv Value. You can specify the level at which you want to view the inventory value details 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 value.
Output For the Report “Inventory Value Summary as on Date”:
Header Information:
It displays the respective BU/OU/Warehouse, which was selected in the Entry page. It displays the Current date till which the report is generated and the current period start date at the header. 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 an Unique “Report ID “ are also shown
Column Information:
The column fields displayed are Item type, Period Opening Balance value, PTD opening Balance value, PTD receipts value, PTD issues Value, PTD Returns Value, PTD adjustments value, PTD revaluation value, Current Inventory value. (PTD stands for Period To Date).
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 zero else the previous period’s closing balance is taken as the current period’s opening balance and it’s displayed in the Period Opening Balance value column
- The system gets the PTD (Period to Date) opening balance value, PTD Receipt value, PTD Issue value and PTD Return value for the current period that is, from the current period start date to till date and it’s 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 current period and it’s displayed in the respective columns that is, PTD adjustment value and in PTD revaluation columns.
- The current inventory value is calculated as: Period OB value + PTD OB value + PTD Receipt value + PTD Return value + PTD Adjustment value + PTD Revaluation value - PTD Issue value+ PTD stock transfer in value - PTD stock transfer out value and displayed in Current Inventory 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.