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 Manage Actual Counts Screen

Use the fields and options to configure the Manage Actual Counts screen.

Identification

Field Description
Count ID

This field displays the count ID for the count selected which you cannot modify.

Warehouse

This field displays the warehouse for the count selected which you cannot modify.

Count Type This field displays if the count is Cycle Count, Standard Physical, or Cycle Count Schedule.
Schedule This field displays the cycle count schedule corresponding to the cycle count when the Count Type is Cycle Count Schedule.

Count Details

Field Description
Count Date

Enter, or click to select, the date when the physical count is to take place.

Control Prefix

This field displays the prefix to be attached to all control numbers for a physical/cycle count. This is entered on the Create Physical Counts screen.

Default Counter

Enter, or click to select, the employee ID who is performing this count.

Default Adjustment Reason

Enter, or click to select, the quantity adjustment reason code to default to all lines with an actual count entered.

Auto Count

Click this button to have Costpoint enter Actual Count Qty, equal to Pre-Count Qty, for all lines that had not yet been counted. This will also automatically enter Yes in the Counted and Reconciled columns for those lines. If you clear the Auto load Actual Count Qty with Pre-Count Qty check box on the Configure Inventory Settings screen, this button will be disabled.

Auto Reconcile

Click this button to have Costpoint set all count and reconciliation flags to Yes for lines with an actual count.

Clicking the Auto Count and Auto Reconcile buttons also defaults the following line values:

  • Counted By
  • Counted Date
  • Count Entry By
  • Count Entry Date/Time
  • Reconciled By
  • Reconciled Date/Time

Table Window

For existing lines, only the following columns can be modified:

  • Actual Count Qty
  • Variance Qty
  • Counted
  • Reconciled

As you enter or tab through the Actual Count Qty field for the line, the following actions will occur:

  • The Counted field is set to Yes.
  • Variance Qty = Actual Count Qty – Pre-Count Qty. If the Tolerance percent is not zero, the Variance Qty is divided by the Pre-Count Qty and multiplied by 100. If the result is less than or equal to the Tolerance percent, the Variance Qty is set to zero. You can override the Variance Qty.
  • The Reconciled field is set to Y (Yes) if the Variance Qty is zero.
Field Description
Control No

The control number is automatically generated from the Starting Control No on the Create Physical Counts screen, but you can modify this when adding a new line.

Part

Enter, or click to select, the part ID of the item to be counted.

Rev

The last revision assigned to the part ID selected automatically displays; however, you can enter, or click to select, another revision that exists for this part ID.

Description

The description of the part selected will automatically display and cannot be modified.

U/M

The inventory unit of measure for the part selected will automatically display and cannot be modified.

Inventory Abbrev

Enter, or click to select, the inventory abbreviation to be counted.

Location

Enter, or click to select, the location ID to be counted.

Total Pre-Count Qty for Part/Location

The pre-count quantity for the actual location displays automatically.

Actual Count Qty

Enter the actual physical quantity counted for this count line.

Pre-Count Qty

The pre-count quantity for this part displays automatically.

Variance Qty

The variance quantity for this count line will be calculated and displayed in this field. The variance quantity is the Actual Count Qty less the Pre-Count Qty. The Variance Qty will become the adjustment quantity. If the Tolerance percent is not zero, Costpoint divides the Variance Qty by the Pre-Count Qty and multiplied the result by 100. If the result is less than or equal to the Tolerance percent, the Variance Qty is set to zero. The Variance Qty can be modified.

Tolerance

This field displays the count tolerance percentage for this part. The tolerance percentage is assigned to the part in the Tolerance field on the Manage Parts screen in Costpoint Product Definition, and it defaults based on the ABC code. Subsequently, tolerance percentages are assigned to ABC codes on the Update ABC Classifications screen.

Adj Reason

Enter, or click to select, the adjustment reason code that describes the cause of this adjustment.

Counted

Yes displays if an actual count has been entered for this count line. Otherwise, it display No. When increasing a count on an existing record where the Counted field is No and the Auto load Actual Count Qty with Pre-Count Qty check box is selected on the Configure Inventory Settings screen, the Actual Count Qty will be set equal to the Pre-Count Qty, and the Variance Qty will be set to zero. If the Auto load Actual Count Qty with Pre-Count Qty check box is clear, the Auto-Count button is disabled, and all actual count quantities will be set to zero.

Counted By

This field displays the employee ID of the counter.

Counted Date Enter, or click to select, the date when the counter actually counted the parts. This initially defaults from the header Count Date, but this can be edited to report the actual date when it was counted.
Reconciled

Select Yes from the drop-down list to indicate that this line is ready for processing. Select No to prevent adjustment creation.

Reconciled By Enter, or click to select, the employee who reconciled the entered count by displaying the valid employee ID.
Reconciled Date/Time This field displays the date/time when the count was reconciled.
Count Entry By This field displays the name of the person who entered the count into the system. This could be a different person from the one who performed the count, or the person who actually created the count row.
Count Entry Date/Time This field displays the date/time when the count was entered into the system. This date can be different from the date/time when the row was actually entered into the system.
Unit Cost This field displays the unit cost of the item.
Variance Amount This field displays the total impact on the inventory value due to the variance quantity.
Notes Enter any notes regarding the actual count, variance quantity, variance amount, or reason for recount.
Material Unit Cost

Click to select the direct material unit cost amount to be allocated.

Material Burden Cost

This field displays the burden material unit cost.

Labor Unit Cost

Click to select the direct labor unit cost to be allocated.

Labor Burden Cost

This field displays the burden labor unit cost.

Subcontract Unit Cost

Click to select the direct subcontract unit cost.

Subcontract Burden Cost

This field displays the burden subcontract unit cost.

Misc 1 Unit Cost

Click to select the direct miscellaneous 1 unit cost.

Misc 1 Burden Cost

This field displays the burden miscellaneous 1 unit cost.

Misc 2 Unit Cost

Click to select the direct miscellaneous 2 unit cost.

Misc 2 Burden Cost

This field displays the burden miscellaneous 2 unit cost.

Total Unit Cost

The total of all cost elements entered displays as the total unit cost for this part.

Load Costs

Click this button to load current cost date for the part and inventory abbreviation.

Subtask

Subtask Description
Serial/Lot Info Click this link to open the Serial/Lot Info subtask to enter and assign new serial and lot numbers.