RECONCILE INVENTORY BALANCES
Use this screen to identify and correct inventory imbalances in the inventory tables due to field corruption problems. You can select a range of projects, inventory abbreviations, and parts for which to run this reconciliation process. You can also print a trial-run report that shows the discrepancies without updating the database.
You can run this process from only one workstation at a time.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Inventory Project
Options
From the drop-down list, select the range option to use when you choose inventory projects to be printed. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start, End
Enter, or click 
to select, the inventory project that will be the starting and ending point to be printed on the report.
Inv Abbrev
Options
From the drop-down list, select the range option to use when you choose inventory abbreviations to be printed. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start, End
Enter, or click to select, the inventory abbreviation that will be the starting and/or ending point to be printed on the report.
Part
Options
From the drop-down list, select the range option to use when you choose inventory parts to be printed. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start, End
Enter, or click to select, the inventory part and revision that will be the starting and/or ending points to be printed on the report.
Sort By
1st Sort
Select a sort option from the drop-down list. The available options are:
Options
Reconcile
Select a reconcile option from the drop-down list. The available options are:
-
Inv Summary Qty to Location Detail Qty — When inventory summary quantities do not match warehouse location detail inventory quantities, select this option to recalculate summary inventory quantities based on the sum of the detailed location inventory quantities.
-
Inv Summary and Detail Qty to Transaction Detail — When inventory summary and warehouse location detail inventory quantities do not match the quantities the inventory transactions say they should match, select this option to recalculate summary inventory and detailed location inventory quantities based on the sum of the transaction quantities.
-
On Order Quantity — Select this option to compare the open quantities on purchase orders and manufacturing orders to the on-order quantities.
-
On Requisition Quantity — Select this option to compare the open quantities on purchase requisitions to the on-requisition quantities.
-
Reserved Quantity — Select this option to reconcile reserved and owed quantities to open inventory reservations.
-
Planned Reserved Quantity — Select this option to reconcile planned reserved and planned owed quantities to open inventory reservations.
-
Reconcile Average Cost — Select this option to reconcile inventory average costs to inventory transactions.
-
Reconcile Standard Cost — Select this option to reconcile inventory costs (for all cost elements) to current values in item cost or item project cost. This only applies to inventory abbreviations associated with projects that have Costing Method = Standard.
Reconcile Burden Cost
Select this check box to reconcile inventory burden costs.
Reconcile Inventory Balances
Click 
drop-down and select Reconcile Inventory Balances to update the database with reconciled quantities.
Reconcile and Print Inventory Balances
Click drop-down and select Reconcile and Print Inventory Balances to update the database with reconciled quantities and print the report.