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
.
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
.
|
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.
|