To Be Reconciled |
The To Be Reconciled tab enables you to adjust unreconciled quantity that has been issued but not yet received. It is intended to be used in conjunction with the Stock Adjustment tab. You may change the reconciled quantity for specific transactions.
If the part quantity received is less than the quantity issued and you specify CHANGE in the Action field and QUANTITY RECONCILED in the Adjustment type field on the Stock Adjustment tab, this tab displays the current unreconciled entries for the part.
If a part has both reconciled and unreconciled records and you specify CHANGE in the Action field and QUANTITY RECONCILED in the Adjustment type field on the Stock Adjustment tab, this tab displays only those entries that need to be reconciled.
Tip: You can use the filter to restrict the information that displays to a specific part ID, part suffix, location ID, adjustment ID, or adjustment reason code, among others.
The Adjustments screen supports location-level access control, so you must belong to a user group with the applicable authorizations to make changes or updates.
The fields in the top section of the To Be Reconciled tab define the data that displays.
Location ID
Identifier of the location at which the adjustment is to be made. The location must be a parts location, and you must be authorized to process parts inventory transactions at it. This field has a list box limited to parts inventory locations. The location description displays to right of the ID.
Locations are associated with site types on the Functions tab of the Data -> Setup -> Organization Structure -> Locations -> Primary Information screen.
Part ID
Identifier of the part for which to make the inventory adjustment. The ID is associated with the part suffix. This field has a list box. The part description displays to the right of the ID.
If you enter a valid cross-reference entry for the part ID/suffix, it is automatically converted to the appropriate part ID/suffix. If more than one valid part ID/suffix is associated with the cross-reference part ID, a list of valid part ID/suffixes displays from which to choose.
Part IDs and suffixes are defined on the Basic Info tab of the Data -> Parts Items -> Primary Information screen. Part cross-references are defined on the Data -> Parts Items -> Cross-references screen.
Part suffix
Number associated with the part in the Part ID field, which distinguishes it from other parts with the same part ID.
This identification applies only if the part ID is a valid part ID.
Adjustment ID
Numeric identifier of the adjustment. Assigned automatically. This field is display only.
Manufacturer part number
Part number assigned by the manufacturer. If parts are tracked BY LOCATION, CENTRALLY, or ENTERPRISE, this field auto-populates when a part ID and suffix are entered. This field is display only.
Note: If there is a check in the Allow update of manufacturer data on Parts - Primary Information screen if not managing ordering and EOQ values CENTRALLY field on the General tab of the Data -> Parts Items -> Setup -> Options screen, data displays from the parts primary record. If that field is blank, data displays from the parts location record.
Manufacturer name
Name of the part manufacturer. If parts are tracked BY LOCATION, CENTRALLY, or ENTERPRISE, this field auto-populates when a part ID and suffix are entered. This field is display only.
Note: If there is a check in the Allow update of manufacturer data on Parts - Primary Information screen if not managing ordering and EOQ values CENTRALLY field on the General tab of the Data -> Parts Items -> Setup -> Options screen, data displays from the parts primary record. If that field is blank, data displays from the parts location record.
Data in the fields in the bottom section of the tab display the reconciliation details and enable you to reconcile the quantity.
New total qty reconciled
Quantity to be reconciled.
Note: The new quantity reconciled cannot be less than the original quantity reconciled, nor can it be greater than the quantity issued.
Orig qty reconciled
Original quantity received. This field is display only.
Qty issued
Quantity issued. This field is display only.
Issue date
Date issued (in MMDDYYYY format). This field is display only.
Work order location
Identifier of the work order location. This field is display only.
Work order year
Year the work order was issued. This field is display only.
Work order number
Number of the work order. This field is display only.
Task ID
Identifier of the task associated with the part. This field is display only.
Unit issue price
Issue price for the part. This field is display only.
Total cost
Total cost of the part. This field is display only.