RECONCILE TRANSACTIONS

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.

Sort

Inventory Project

Select this radio button to sort by inventory project.

Part

Select this radio button to sort by part.

Select Inventory Project

Range Option

Select the range of inventory projects to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."

From/To

Enter, or use Lookup to select, the inventory project that will be the starting and/or ending point to be printed on the report.

Select Inventory Abbreviation

Range Option

Select the range of inventory abbreviations to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."

From/To

Enter, or use Lookup to select, the inventory abbreviation that will be the starting and/or ending point to be printed on the report.

Select Part/Rev

Range Option

Select the range of inventory parts to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."

From/To, Rev

Enter, or use Lookup to select, the inventory part and revision that will be the starting and/or ending points to be printed on the report.

Reconcile Options

This group box contains the reconciliation options.

Inv Summary Qty to Location Detail Qty

When inventory summary quantities do not match warehouse location detail inventory quantities, select this radio button 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/or warehouse location detail inventory quantities do not match the quantities the inventory transactions say they should match, select this radio button to recalculate summary inventory and detailed location inventory quantities based on the sum of the transaction quantities.

On Order Quantity

Select this radio button to compare the open quantities on purchase orders and manufacturing orders to the on-order quantities.

On Requisition Quantity

Select this radio button to compare the open quantities on purchase requisitions to the on-requisition quantities.

Reserved Quantity

Select this radio button to reconcile reserved and owed quantities to open inventory reservations.

Planned Reserved Quantity

Select this radio button to reconcile planned reserved and planned owed quantities to open inventory reservations.

Reconcile Average Cost

Select this radio button to reconcile inventory average costs to inventory transactions.

Reconcile Burden Cost

Select this radio button to reconcile inventory burden costs.

Update the database with reconciled quantities

Select this button on the toolbar to update the database with reconciled quantities.

Update the database with reconciled quantities and report discrepancies fixed

Select this button on the toolbar to update the database with reconciled quantities and print the report.

Table Information

The information that is entered in this screen and saved as a parameter is stored in the FUNC_PARM_CATLG table. This screen also relies on the settings in the INVT_SETTINGS table. Information is also stored in and/or pulled from the following tables: FUNC_PARM_CATLG, INVT, INVT_ABBRV_CD, INVT_PROJ, INVT_TRN, INVT_TRN_LN, INVT_WHSE_LOC, ITEM, ITEM_UM_CONV, MO_ALLOCATIONS, MO_HDR, PART, PO_HDR, PO_LN, RES_HDR, RES_LN, RQ_HDR, RQ_LN, UM_CONV, WHSE_LOC.