Adjustment Summary

This report allows you to view the summary of adjustments at BU, OU or Warehouse level. Report Information.

Select the “Adjustment Summary” link under the “INVReports” business component.

The “Adjustment Summary” page appears.

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

Adjustment Summary For

Use the drop-down list box to select the level at which you want to view the adjustment summary. 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.

Warehouse – indicates that adjustment summary is displayed only for the specified warehouse.
OU – indicates that adjustment summary is displayed for all the warehouses of the login OU.
BU – indicates that adjustment summary is displayed for all the warehouses of the BU of login OU.

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.

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 “Accounting 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 displays 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 “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 displays 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.

Note: Adjustment Summary is displayed only for date that lies between Date From and Date To.

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 Cost Center	Use the drop-down list box to select the adjustment cost center. The system retrieves all the cost centers defined for the BU along with “All” option.

Enter the following detail:

All Adjustment

Check this box if you want to view all the adjustment transactions irrespective of the adjustment types. 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 adjustment summary for “General Adjustment” type only.
PI Based Adjustment	Check this box if you want to view the adjustment summary for “PI Based Adjustment” type only.
Cycle Count Based Adjustment	Check this box if you want to view the adjustment summary for “CC Based Adjustment” type only.

For viewing the report

Click the “View Report” pushbutton to view the adjustment summary details.

Adjustment Summary – An overview

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 summary such as adjustment type, adjustment document number, adjustment date, adjustment value, reference document number and reference document type.

This page allows you to specify the search conditions for viewing Adjustment Summary. You can specify the level at which you want to view the adjustment summary that is, OU, BU or Warehouse and other search conditions for viewing the report

You can select whether the adjustment type is General Adjustment, PI Based Adjustment or CC Based Adjustment.

Output For the Report “Adjustment Summary”:

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 entry page of the report. It also displays the Specific Cost Center based on the selection in the entry page in the “Cost Center “ combo. The Base Currency and a Unique “Report ID “ are also shown.

Column Information:

The column fields displayed are Adjustment Type, Adjustment Document No, Adjustment Date, Adjustment value, Reference Document No. and Reference document type.

- 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.

- Date of Transaction will be displayed in the Adjustment date column.

- Adjusted value (Either Negative / Positive) will be displayed in the Adjustment value 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 “ column as applicable

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.