Contents of the Cost Adjustments Form

Use the fields and options to determine recalculated cost.

Toolbar

Field Description
New Click this option to start a new cost adjustment transaction.
Post Adjustment Click this option to commit the cost adjustment transaction. DPS assigns a transaction number to this cost adjustment transaction and recalculates the item's Average Actual Cost. DPS also creates and posts a journal entry transaction for the Total amount shown in the grid, if the Skip GL option is cleared.
Print After you click this option, select one of the following:
  • Select Print Current Issue to preview a report of the transaction that is open now. You can select to print the report.
  • Select Print Active Group to preview a report for the group of transactions currently open.
  • Select Select Issue to Print to display all of the inventory issue transactions that are posted.

Fields

Field Description
Transaction Number DPS displays the next inventory transaction number in this field.
Date This field displays today's date. To change the date, enter a date or click and select a date.
Performed By This field displays the employee name of the DPS login user. Click to select a different user from the Employee Lookup.
Comment Enter comments in this field. The header of the Cost Adjustments report displays whatever you enter in this field.
Diary This field displays only if you have set up a diary for the fiscal period or fiscal year in which you are entering transactions in the Diary Auto Numbering Options section of the Transaction Settings form in Settings > Accounting > Transactions.

Use this field to select a diary code for the current transaction or the group of transactions if you are processing a group of transactions, such as in a vendor payment run. The diaries are used to generate diary reports that contain a set of sequentially numbered transactions that have been posted to the general ledger during the fiscal year or to specific fiscal periods. You can assign different diaries (that have different diary types) to different types of transactions.

The Diary drop-down list contains three columns. The first column displays the diary code. The second and third columns display the diary type for the diary code and the description of the diary type.

The drop-down list contains all the diaries that you set up on the Diary Auto Numbering Options section in Transactions Settings that have the same fiscal period or fiscal year in which you are entering transactions or that have no fiscal period or year entered for them.

If you have multiple companies in DPS, the Diary field drop-down list includes only the diary codes that are set up for the current company. The list also includes IC - Intercompany Diary to capture intercompany transactions.

You cannot delete a transaction after it has been saved with a diary number. If a transaction is incorrect, you can enter zero amounts for the transaction or enter a reversing transaction.

Item Grid Toolbar

Field Description
Insert Click this option to add a blank row to the grid.
Delete Click this option to delete the selected row from the grid.

Items Grid

Use this grid to enter data for a journal entry in the general ledger. This journal entry adjusts the depreciated cost for the inventory item. To add one or more cost adjustments to the same item in the same session, you must make a cost adjustment transaction for each adjustment.

Field Description
Item Click to open a list of inventory items. Select an inventory item from the list.
Description This field displays the item's description.
Qty on Hand This field displays the item's quantity on hand.

This data is the sum of Quantity on Hand at all of the locations in your company, if the Allow Modify Locations option is selected on the Inventory tab of Settings > Purchasing & Inventory > Company.

U/M This field displays the item's unit of measure that is used to show the Qty on Hand.
Original Unit Cost This field displays the item's average actual cost.
Unit Cost Adjust Enter the change in cost per unit of measure. This number can be either positive or negative. DPS uses this number to calculate data for the item's New Unit Cost.

As an alternative, you can enter the New Unit Cost in the following field. If you do this, DPS uses your data to calculate the value in this field.

New Unit Cost Enter the new per item valuation of the inventory item. DPS prevents entry of a negative number.

As an alternative, you can enter the Unit Cost Adjust in the preceding field. If you do this, DPS uses your data to calculate the data in this field.

Adjust Amount This field displays the calculation (Quantity on Hand * Unit Cost Adjust).

This is the amount of the journal entry transaction that you make by clicking the Post Adjustment button in the toolbar, if the Skip GL option is cleared.

Project Click and select the project to which to post the entry that offsets the entry to the Inventory Common project. This project can be of any charge type. It is not necessary to specify an overhead project.

The area below the grid displays the project's name and number.

Phase Click and select the phase to which to post the entry that offsets the entry to the Inventory Common phase.
Task Click and select the task to which to post the entry that offsets the entry to the Inventory Common task.
Account Click and select the account to which to post the unit cost increase shown in the Adjust Amount field.
Skip GL Select this option to prevent DPS from creating a journal entry transaction and posting it to the general ledger.
Reason Code Select the cost adjustment reason from the drop-down list.