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.
If you entered "Y" in the Auto-Assign field in the Transaction IDs subtask of the Warehouses screen and selected "Quantity Adjustments," leave this field blank and the system will automatically assign the next quantity adjustment ID. If you entered "Y" in the Auto-Assign field and you manually enter an ID in this Qty Adjustment ID field, the Last Inv Trans ID field in the Transactions IDs subtask of the Warehouses screen will not be updated. If you are not using Auto-Assign, you can manually enter a quantity adjustment ID containing up to 10 alphanumeric characters. The value in this field cannot begin with a space.
The system date is displayed as the default transaction date; you can enter another date.
Enter, or use Lookup to select, the material handler who is performing this transaction. A valid employee ID is required.
If you entered a dollar approval amount in the Approval Amount Threshold field in the Inventory Settings screen, and the Total Adj Amt field in this screen is equal to or greater than the approval amount, you must enter, or use Lookup to select, the approver for this transaction. A valid employee ID is required.
If you entered a dollar approval amount in the Approval Amount Threshold field in the Inventory Settings screen, and the Total Adj Amt field in this screen is equal to or greater than the approval amount, the system will ask you to enter the approval password (assigned in the Local Approval Password field in the 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.
Enter, or use Lookup to select, the ID of the warehouse from which the material will be taken from if a negative adjustment is made.
Enter 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.
You can select an inventory abbreviation, project/account/organization combination, or an account/organization to charge for this quantity adjustment.
If you did not enter an inventory abbreviation, enter, or use Lookup to select, the project to be charged for this adjustment. The project must be active. This field is optional.
If you did not enter an inventory abbreviation, enter, or use Lookup 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.
Enter, or use Lookup to select, the organization to be charged for this adjustment. The organization must be active and a valid account/organization combination.
Enter, or use Lookup 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.
Select this checkbox to have this transaction become the starting balance(s) for the part(s) entered. A starting balance transaction will not be allowed for parts with existing inventory and will not be posted to the General Ledger.
Enter free-form text to be associated with this adjustment.
This field displays the total amount of this adjustment. The system 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 edit this calculated field. This field is not displayed if Cost Suppression is in effect (the Suppress Cost checkbox is selected in the table window of the Maintain Users screen in Costpoint System Administration).
The line number is automatically generated.
Enter, or use Lookup to select, the part ID for the material to be adjusted.
The last revision assigned to the part ID selected is automatically displayed; however, you can enter, or use Lookup to select, another revision that exists for this part ID.
This field displays the description for the part selected.
This field displays the inventory unit of measure for the part selected.
The default From inventory abbreviation entered in the header is displayed in this field but can be changed. You can use Lookup to select a new inventory abbreviation.
Enter the quantity to be adjusted. This will default from the reservation if one has been entered.
Enter, or use Lookup to select, the location ID from where the material is being adjusted.
Enter, or use Lookup to select, a reason code for this adjustment. The reason code must already be established in the Adjustment Reasons table in Inventory Controls.
After you select the Adjustment Reason, the Update Last Count Date default value associated with it is displayed. If this field is set to "Y," 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.
This field displays the unit cost for this part. You can update the unit cost in the Cost Elements subtask for any positive adjustment. If Cost Suppression is in effect (the Suppress Cost checkbox is selected in the table window of the Maintain Users screen in Costpoint System Administration), the unit cost does not display.
The total of the adjustment quantity multiplied by the unit cost is displayed. If Cost Suppression is in effect (the Suppress Cost checkbox is selected in the table window of the Maintain Users screen in Costpoint System Administration), the extended cost does not display.
Enter, or use Lookup to select, a valid reference 1 number.
Enter, or use Lookup to select, a valid reference 2 number.
Enter, or use Lookup to select, a valid reference 1 number.
Enter, or use Lookup to select, a valid reference 2 number.
Select this pushbutton to view the accounting period to which the transaction will be posted, according to the transaction date.
Select this pushbutton to record or view serial and lot number information for a selected transaction line. Depending upon the transaction, the subtask screen will be either Serial/Lot Assignment or Serial/Lot Disposition.
Select this pushbutton to record or view inventory cost element information for a selected transaction line.
This pushbutton is disabled in this version of Costpoint. However, if you select Clone from the File menu, a Clone window will appear in which you can select the transaction that you would like to clone. Upon completing the cloning process, you will be given the option of reversing the transaction, in which case the positive Adjustment Qty and associated Total Adj Amt will be reversed; or keeping the cloned transaction equal to the original amounts. Reversing quantities cannot exceed the original transaction quantity. 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.
Changes to this screen update the INVT_TRN and INVT_TRN_LN tables. This screen also relies on the settings in the INVT_SETTINGS and MRP_SETTINGS_CORP tables. Information for quantity adjustments is also stored in and/or pulled from the following tables, as indicated for the applicable subtasks in this screen: EMPL, INVT_ABBRV_CD, INVT_TRN, INVT_TRN_LN, INVT_WHSE_LOC, ITEM, ITEM_UM, PROJ_EDIT, REF_STRUC, RSN_CD, S_CST_MTHD_CD, SUB_PD, WHSE_LAST_TRANS, WHSE_LOC.