|
|
|
|
|
This report allows you to view the statistics of items at OU, BU or Warehouse Level. Report Information.
Select the “Stores Ledger” link under the “INVReports” business component.
The “Stores Ledger” page appears.
Enter the following field details in the “Search Criteria” group box:
|
Stores Ledger For |
Use the drop-down list box to select the level at which you want to view the Stores ledger Reports. 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 to be selected only if stores ledger for is chosen as “Warehouse”.
|
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 Stores ledger is based on “Item Type”, “Item Group” ,“Item Account Group” or “Item Category”. The system displays “Item Type” as the default value on launch of the page. |
Note: Item Category Code is selected only if “Item Category” 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 :
|
Item Category Code |
Use the drop-down list box to select the item category code. |
The system displays the following detail:
|
Item Category Desc. |
The description of the Item Category Code. |
Note: Item Group Selection Option is selected only if the “Item Group” option is chosen in the Item Selection Options drop-down.
|
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.
|
Item Group Code |
Use the drop-down list box to select the Item Group Code. The system retrieves all the active Item groups 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 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 in the “Group Type Based Selection” group box:
|
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 LO in ascending order. The system displays blank as the default value on launch of the page. |
The system displays the following detail:
|
Group Type Desc. |
The description of the Group type. |
Enter the following detail in the “Group Type Based Selection” group box:
|
Item Group Lvl 1 |
Use the drop-down list box to select the first level of item group. The system retrieves all the first level item groups for the selected group type along with a blank value. The system displays blank as the default value on launch of the page. |
The system displays the following detail:
|
Item Group Lvl 1 Desc. |
The description of the first level item group. |
Enter the following detail in the “Group Type Based Selection” group box:
|
Item Group Lvl 2 |
Use the drop-down list box to select the second level of item group. The system retrieves all the second level item group for the selected first level item group along with a blank value. The system displays blank as the default value on launch of the page. |
The system displays the following detail:
|
Item Group Lvl 2 Desc. |
The description of the second level item group. |
Enter the following detail in the “Group Type Based Selection” group box:
|
Item Group Lvl 3 |
Use the drop-down list box to select the third level of item group. The system retrieves all the third level item group for the selected second level item group along with a blank value. The system displays blank as the default value on launch of the page. |
The system displays the following detail:
|
Item Group Lvl 3 Desc. |
The description of the third level of item group. |
Enter the following detail in the “Group Type Based Selection” group box:
|
Item Group Lvl 4 |
Use the drop-down list box to select the fourth level of item group. The system retrieves all the fourth level item groups for the selected third level item group along with a blank value. The system displays blank as the default value on launch of the page. |
The system displays the following detail:
|
Item Group Lvl 4 Desc. |
The description of the fourth level of item group. |
Note: Item Type Selection is to be selected only if “Item Type” option is chosen in the “Item Selection Options” drop-down.
Enter the following detail:
|
All Item Types |
Check this box if you want to view “Stores Ledger” 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 “Stores ledger” for items of Item type “Raw material” alone. |
|
Intermediate |
Check this box if you want to view “Stores ledger” for items of Item type “Intermediate” alone. |
|
Utility |
Check this box if you want to view “Stores ledger” for items of Item type “Utility” alone. |
|
Finished Product |
Check this box if you want to view “Stores ledger” for items of Item type “Finished Product” alone. |
|
Spare Part |
Check this box if you want to view “Stores ledger” for items of Item type “Spare Part” alone. |
|
Pack |
Check this box if you want to view “Stores ledger” for items of Item type “Pack” alone. |
|
Component |
Check this box if you want to view “Stores ledger” for items of Item type “Component” alone. |
|
Tool |
Check this box if you want to view “Stores ledger” for items of Item type “Tool” alone. |
|
Scrap |
Check this box if you want to view “Stores ledger” for items of Item type “Scrap” alone. |
|
Consumable |
Check this box if you want to view “Stores ledger” for items of Item type “Consumable” alone. |
|
Phantom |
Check this box if you want to view “Stores ledger” for items of Item type “Phantom” alone. |
|
Sundry |
Check this box if you want to view “Stores ledger” for items of Item type “Sundry” alone. |
Enter the following details in “Item Selection” group box:
|
Item Code From |
The starting range of item code (Alphanumeric, 32). |
|
Item Code To |
The ending range of item code (Alphanumeric, 32). |
|
Show Transaction Details |
Select the check box to launch the “Stores Ledger with Value” report which displays the details about the transactions happened for the Warehouse. |
|
Variant Code |
The code identifying the variant of an item (Alphanumeric, 8). |
|
Item Variant Desc. |
The description of the item variant (Alphanumeric, 150). |
Enter the following details in Date Selection group box:
|
Date Selection Option |
Use the drop-down list box to select the date selection option. The options available in the drop-down list box are “Any Date”, “Fin Period” and “Fin Year”. The system displays “Any Date” as the default value on launch of the page. |
Note: “Financial year” is specified only if “Fin Year” option is selected in the Date Selection Option field.
|
Financial Year |
Use the drop-down list box to select the financial year. The system retrieves all the financial years defined for the company, which are on or before the system date from “Accounting Setup” component. The values are populated in ascending order with first value as the default value. The system populates the starting date and end date of the financial year in the date from and date to fields |
Note: “Financial Period” is specified only if “Fin Period” option is selected in the Date Selection Option field.
|
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 from “Accounting Setup” Component. The financial period displayed must be on or before the system date. The values are populated in ascending order with first value as the default value. The system populates the starting date and end date of the financial period in the date from and date to fields |
Note: “Date From” and “Date To” are to be given only if “Any Date” options is selected in the Date Selection Option field.
|
Date From |
The starting range of date (Date Format). The date entered in Date From field must be less than or equal to the Date To field.. |
|
Date To |
The ending range of date (Date Format). Date To must be less than or equal to the system date. |
For viewing the report
Click the “View Report” pushbutton to view the report.
The system launches the “Stores Ledger with Value” report when the “Show Transaction Details” check box is selected. When the “Show Transaction Details” check box is not selected, then the system launches the “Stores Ledger” report.
You can view the details such as Period Opening Balance Qty, Period Opening Balance Value, Opening Balance Qty, Opening Balance Value, Receipt Qty, Receipt Value, Issue Quantity, Issue Value, Return Quantity, Return Value, Adjustment Quantity, Adjustment Value, Revaluation Value, Transfer In Quantity, Transfer in Value, Transfer out Quantity, Transfer out Value, Period CB Qty and Period CB Value.
You can specify the level at which you want to view the Stores Ledger that is, OU, BU or Warehouse.
You can select the Item Selection Option from the drop-down list box. The three options available are “Item Group”, “Item Category” 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 Category – You must select the Item Category Code and the corresponding Item Category description will be displayed automatically.
Item Type – You must select one or more or all the types of item for which you want to view the stores ledger.
You can also directly specify the range of item codes in the Item Selection group box. A value can be selected for the Date Selection Option, based on which the financial year, financial period, Date From and Date To are specified. The Date From and Date To are manually entered, only if the “Any Date” option is selected, else they are fetched based on the financial year or financial period chosen.
Output For the Report “Stores Ledger”:
Header Information:
It displays the respective BU/OU/Warehouse, which was selected in the Entry page. It displays the Date From and Date to fields with specific dates based on the Financial period selection option which was chosen in the report. It also displays the Group code / Group type / Group Category 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 code / Item var desc (Item Variant Description), Variant code, Stock UOM / Item type, Period OB Qty / Value, OB Qty / Value, Receipt Qty / Value, Issue Qty / Value, Return Qty / Value, Adjustment Qty / value, Revaluation value, Transfer in qty. / Value, Transfer Out qty. / value, Period CB Qty. / Value
- Item code / Item var desc (Item Variant Description), Variant code, Stock UOM / Item type for the respective Items for the BU/OU/Warehouse will be displayed in the respective columns.
- Period OB Qty/Value will be zero if the selected period is the first period for installation. For the other periods, the previous period's closing balance qty and value to be taken as this period's opening balance qty and value.
- The opening balance transactions qty and value for the selected period will be displayed in the OB Qty / Value
- The Receipt qty and value for the selected period will be displayed in the Receipt Qty / Value column.
- The Issue qty and value for the selected period will be displayed in the Issue Qty / Value column.
- The Return qty and the value for the selected period will be displayed in the Return Qty / Value column
- The adjustments qty and value for the selected period will be displayed in the Adj. Qty / Value column. Only the net adjustment value (that is, After consolidation of all Positive and negative values) will be displayed in the column.
- The Revaluation value for the selected period will be displayed in the Reval. Value column. Only the net Revaluation value (that is, After consolidation of all Positive and negative values) will be displayed in the column
- The quantity and value of Stock received in a warehouse/OU/BU due to stock Transfer for the selected period will be displayed in the Transfer In Qty / Value column
- Similarly the Qty. and stocks transferred from the Warehouse/OU/BU due to stock transfer for the selected period will be displayed in the Transfer Out Qty / Value column
- The system calculates Period CB qty. by the formula Period OB Qty + OB Qty + Receipt Qty + Return Qty + Adjustment Qty - Issue Qty + stock transfer in qty - stock transfer out qty. Similarly, Period CB Value y. will be calculated by the formula Period OB value + OB value + Receipt value + Return value + Adjustment value + Revaluation value - Issue value+ stock transfer in value - stock transfer out value.
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.
Output For the Report “Stores Ledger with Value”:
Header Information:
It displays the From Date and To Date fields with specific dates based on the financial period selection option which was chosen in the report. It also displays the Item Code, Variant, Item Description, Warehouse, UOM and Item Type.
Column Information:
The column fields displayed are Doc. Date, Document No, Ref. Doc. No, Doc Type, Rcpt Qty (+), Rcpt Qty (-), Rate, Issue Qty (-), Issue Val (-) and Rate.
- The date on which the document was created will be displayed in the Doc date column.
- The number identifying the document will be displayed in the Document No column.
- The reference number of the document will be displayed in the Ref Doc No column.
- The type of the document in the Doc Type column.
- The Receipt qty and value for the selected period will be displayed in the Rcpt Qty / Val column.
- The rate of the receipt quantity will be displayed in the Rate column, Rate = Rcpt Val / Rcpt Qty.
- The Issue qty and value for the selected period will be displayed in the Issue Qty / Val column.
- The rate of the issued quantity will be displayed in the Rate column, Rate = Issue Val / Issue Qty.
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.