Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the Reconcile Inventory Balances Screen

Use the fields and options to configure the Reconcile Inventory Balances screen.

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on 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

Field Description
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

Field Description
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

Field Description
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

Field Description
1st Sort

Select a sort option from the drop-down list. The available options are:

  • Inventory Project: Select this to sort by inventory project.
  • Part: Select this to sort by part.

Options

Field Description
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 Serial/Lot Qty Select this check box to reconcile inventory serial/lot quantity to location detail quantity. This check box is enabled when Reconcile Inv Summary and Detail Qty to Transaction Detail option is selected, and Enable Inventory Serial/Lot Tracking is selected on the Configure Serial Lot Settings screen.
Note: Transactions with mismatched tracking requirements will be included in the Exclusion Report, and will not be included in the calculations.
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.