ENTER QUANTITY ADJUSTMENTS

Use this screen to enter adjustments to quantities for inventory parts from a specified warehouse. You can also enter beginning balances for inventory parts.

Use this screen whenever adjustments to quantity are required and when initializing inventory for the first time.

When performing a clone or reverse transaction for an adjustment, you can modify only the Adjustment Quantity after the cloning or reversal takes place. All other data will come from the original transaction and cannot be modified. The reversing quantity cannot be greater than the original quantity for a transaction. Before cloning, please be sure that all data is accurate. An incorrect clone or reverse transaction (or adding or deleting records) can result in inaccurate system data.

Location

Identification

Warehouse

Enter, or click to select, the ID of the warehouse from which the material will be taken from if a negative adjustment is made.

Quantity Adjustment ID

If you selected the Auto-Assign check box for the Quantity Adjustments transaction in the Transaction IDs subtask of the Manage Warehouses screen, leave this field blank and Costpoint will automatically assign the next quantity adjustment ID. If you selected the Auto-Assign check box and you manually enter an ID in this Quantity Adjustment ID field, the Last Inv Trans ID field in the Transaction IDs subtask of the Manage Warehouses screen is not updated. If you are not using Auto-Assign, you can manually enter a quantity adjustment ID. The value in this field cannot begin with a space.

Transaction Date

The system date is displayed as the default transaction date; you can enter, or click to select, another date.

Material Handler

Enter, or click to select, the material handler who is performing this transaction. A valid employee ID is required.

Default Inv Abbrev

Enter, or click to select, the default inventory abbreviation from which the material will be taken when a positive adjustment is made. You can override this at the line level.

Notes

Enter text to be associated with this transaction.

Approval

Approver

If you entered a dollar approval amount in the Approval Amount Threshold field on the Configure Inventory Settings screen and the Total Adjustment Amount field on this screen is equal to or greater than the approval amount, you must enter, or click to select, the approver for this transaction. A valid employee ID is required.

Password

If you entered a dollar approval amount in the Approval Amount Threshold field on the Configure Inventory Settings screen and the Total Adjustment Amount field on this screen is equal to or greater than the approval amount, Costpoint will ask you to enter the approval password (assigned in the Local Approval Password field on the Configure Inventory Settings  screen) to perform this transaction. You do not have to make an entry in this field to save the transaction, but the transaction will be flagged as unapproved when the Inventory Journal is posted.

Adjusting

You can select an inventory abbreviation, project/account/organization combination, or an account/organization to charge for this quantity adjustment.

Project

If you did not enter an inventory abbreviation, enter, or click to select, the project to be charged for this adjustment. The project must be active.

Proj Abbrev

This field displays the project abbreviation to be charged for this adjustment. You can enter, or click to select, another project abbreviation.

Organization

Enter, or click to select, the organization to be charged for this adjustment. The organization must be active and a valid account/organization combination.

For GFM parts, Costpoint uses the project’s owning organization for organization security validation, if organization security is enabled.

Org Abbrev

This field displays the organization abbreviation to be charged for this adjustment.

Account

If you did not enter an inventory abbreviation, enter, or click to select, the account to be charged for this adjustment. The account must be active. If you entered a project in the Project field, the account must be valid for this project. If you did not enter a project, the account must be a non-project account. The account should be an expense or non-inventory asset account.

Inv Abbrev

Enter, or click to select, the inventory abbreviation ID to be charged for this adjustment. The adjusting inventory abbreviation must be an account type of E (Expense) or G (Government-furnished material). The project assigned to this inventory abbreviation is displayed.

Starting Balance Transaction

Select this check box to have this transaction become the starting balance for the part entered. A starting balance transaction is not allowed for parts with existing inventory and is not posted to the General Ledger.

Total Adjustment Amt

This field displays the total amount of this adjustment. Costpoint calculates the total by multiplying the adjustment quantity by the unit cost or the sum of the extended cost for all of the lines. You cannot modify this calculated field. This field is not displayed if Cost Suppression is in effect (the Suppress Cost check box is selected on the Manage Users screen in Costpoint Administration).

Reverse Transaction

Click this button to reverse the selected transaction. The positive Adjustment Quantity and associated Total Adjustment Amount will be reversed. Reversing quantities cannot exceed the original transaction quantity. You can apply a reversal of transaction to both positive and/or negative adjustment quantities, and the effect of reversing a positive adjustment is similar to that of a negative adjustment. The original transaction costs will be used for the reversal.

Table Window

Line

The line number is automatically generated.

Part

Enter, or click to select, the part ID for the material to be adjusted.

Rev

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

Description

This field displays the description for the part selected.

U/M

This field displays the inventory unit of measure for the part selected.

From Inv Abbrev

The default inventory abbreviation entered in the Default Inv Abbrev field in the header is displayed in this field but can be modified. Enter, or click to select a new inventory abbreviation.

Adjustment Quantity

Enter the quantity to be adjusted. This will default from the reservation if one has been entered.

From Location

Enter, or click to select, the location ID from where the material is being adjusted.

Adjustment Reason

Enter, or click to select, a reason code for this adjustment. The reason code must already be established in the Manage Adjustment Reasons table in Inventory Controls.

Update Last Count Date

After you select the Adjustment Reason, the Update Last Count Date default value associated with it is displayed. If this check box is selected, the Last Count Date will be updated with the transaction date (it must be later than the previous last count date) throughout Costpoint Inventory based on this quantity adjustment record.

Unit Cost

The unit cost for this part is displayed which is the summation of the direct costs. If a negative issue quantity has been entered, you can modify direct costs and the unit cost is recomputed. If Cost Suppression is in effect (that is, the Suppress Cost check box is selected on the Manage Users screen), the unit cost does not display.

Extended Cost

The total of the adjustment quantity multiplied by the unit cost is displayed. If Cost Suppression is in effect (that is, the Suppress Cost check box is selected on the Manage Users screen), the extended cost does not display.

From Ref 1

Enter, or click to select, a valid reference 1 number.

The label Ref 1 may display a different label if it has been changed on the Configure General Ledger Settings screen.

From Ref 2

Enter, or click to select, a valid reference 1 number.

To Ref 1

Enter, or click to select, a valid reference 2 number.

The label Ref 2 may display a different label if it has been changed on the Configure General Ledger Settings screen.

To Ref 2

Enter, or click to select, a valid reference 2 number.

If you have entered the value for the Default Inv Abbrev field, the following direct cost fields are enabled. Otherwise, these fields are not available and cannot be modified.

Direct Material Cost

This field displays the direct material unit cost. You can click to either select the cost you want to use base from the following costs:

Direct Labor Cost

This field displays the direct labor unit cost. You can click to select the cost you want to use.

Direct Subcontract Cost

This field displays the direct subcontract unit cost. You can click to select the cost you want to use.

Direct Misc 1 Cost

This field displays the direct miscellaneous 1 unit cost. You can click to select the cost you want to use.

Direct Misc 2 Cost

This field displays the direct miscellaneous 2 unit cost. You can click to select the cost you want to use.

The following fields are for viewing only and cannot be modified.

Burden Material Cost

This field displays the burden material unit cost.

Burden Labor Cost

This field displays the burden labor unit cost.

Burden Subcontract Cost

This field displays the burden subcontract unit cost.

Burden Misc 1 Cost

This field displays the burden miscellaneous 1 unit cost.

Burden Misc 2 Cost

This field displays the burden miscellaneous 2 unit cost.

Load Costs

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

Subtasks

Subtask

Description

Accounting Period

 

Click this link to open the Accounting Period subtask, so that you can view the accounting period to which the transaction will be posted, based on the transaction date.

Serial/Lot Info

 

Click this link to open the Serial/Lot Info subtask, to record or view serial and lot number information for a selected transaction line.