|
|
|
|
|
This report allows you to view the list of adjustments for the items selected in BU, OU or Warehouse. Report Information.
Select the “Adjustment List” link under the “INVReports” business component.
The “Adjustment List” page appears.
Enter the following field details in the “Search Criteria” group box:
|
Adjustment List For |
Use the drop-down list box to select the level at which you want to view the adjustment list 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 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 adjustment list is based on “Item Type”, “Item 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 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 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 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 and 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 group 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 of 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 of 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 group 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 entered only if “Item Type” option is selected in the “Item Selection Options” drop-down.
Enter the following detail:
|
All Item Types |
Check this box if you want to select 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 the adjustment list for items of type “Raw Material” alone. |
|
Intermediate |
Check this box to view the adjustment list for items of type “Intermediate” alone. |
|
Utility |
Check this box to view the adjustment list for items of type “Utility” alone. |
|
Finished Product |
Check this box to view the adjustment list for items of type “Finished Product” alone. |
|
Spare Part |
Check this box to view the adjustment list for items of type “Spare Part” alone. |
|
Pack |
Check this box to view the adjustment list for items of type “Pack” alone. |
|
Component |
Check this box to view the adjustment list for items of type “Component” alone. |
|
Tool |
Check this box to view the adjustment list for items of type “Tool” alone. |
|
Scrap |
Check this box to view the adjustment list for items of type “Scrap” alone. |
|
Consumable |
Check this box to view the adjustment list for items of type “Consumable” alone. |
|
Phantom |
Check this box to view the adjustment list for items of type “Phantom” alone. |
|
Sundry |
Check this box to view the adjustment list for items of 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). |
|
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 from the “Account Setup” component. The financial year retrieved 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 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 the “Account 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 user defined 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. |
Enter the following details in Transaction Detail Selection group box:
|
Transaction No. From |
The starting range of transaction number (Alphanumeric, 18). |
|
Transaction No. To |
The ending range of transaction number (Alphanumeric, 18). |
|
Adjustment Value From |
The starting range of adjustment value (Integer). |
|
Adjustment Value To |
The ending range of adjustment value (Integer). |
Enter the following detail:
|
All Adjustment |
Check this box if you want to select all the fields present in Adjustment Type Selection group box. This check box is checked by default on launch of the page. |
Enter the following details in “Adjustment Type Selection” group box:
|
General Adjustment |
Check this box if you want to view the General Adjustment list . |
|
PI Based Adjustment |
Check this box if you want to view the Physical Inventory Adjustment list. |
|
Cycle Count Based Adjustment |
Check this box if you want to view the Cycle Counting Adjustment list. |
For viewing the report
Click the “View Report” pushbutton to view the adjustment list report details.
Adjustment is made when the physical stock does not match with the system stock. When the physical stock is more than the system stock, the adjustment made is positive adjustment and the vice versa is negative adjustment. There are three types of adjustment, General Adjustment, Physical Inventory Adjustments (PI Based Adjustment) and Cycle Counting Adjustments (CC Based Adjustment). The PI or CC based adjustments are based on the PI Plan or CC Sheet No respectively and General Adjustments are made without referring to the base document.
This report allows you to view the adjustment details made for an item variant such as Adjustment type, adjustment date, Issue document number, reference document number, Adjustment Qty., Adjustment Value. The net total of positive adjustment and negative adjustment is also displayed.
You can specify the level at which you want to view the adjustment list 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 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 can select one or more or all the types of item for which you want to view the adjustment list.
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 finacial year or financial period chosen. You can directly specify the range of transaction number and adjustment value in the Transaction Detail Selection group box.
You can select whether the adjustment type is General Adjustment, PI Based Adjustment or CC Based Adjustment.
Output For the Report “Adjustment List”:
Header Information:
It displays the respective BU/OU/Warehouse, which was selected in the Entry page. It also displays the Date From and Date to fields with specific dates based on the date 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 a Unique “Report ID “ are also shown.
Column Information:
The column fields displayed are Item code, Variant code, Item var desc (Item Variant Description), Item type, Stock UOM, Warehouse, Adjustment Qty, Adjustment value, Adjustment Date, Adjustment Type, Issue Document No., Reference Document No. and Reference document type.
- Item code, Variant code, Item variant description, Item type, Stock UOM and the warehouse for the respective Items for the BU/OU/Warehouse will be displayed in the respective columns.
- Quantity adjusted for the Item in the specific document will be displayed in the “Adjustment Qty “ column
- Adjusted value (either Negative / Positive) in the specific document will be displayed in the Adjustment value column.
- Date of Transaction will be displayed in the Adjustment date column.
- Type of adjustment either General adjustment / PI based adjustment / CC based adjustment will be displayed in the Adjustment type column.
- Corresponding Transaction number will be displayed in Adjustment document no. column.
- Respective Reference document no. for that transaction and the type of reference document will be displayed in the “Reference doc No.” and “Reference Doc type “ respectively
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.