Contents of the Quantity Adjustments Form

Use the fields and options to adjust item quantities.

Toolbar

Field Description
New Click this option to start a new quantity adjustment transaction.
Post Adjustment Click this option to commit the quantity adjustment transaction. DPS assigns a transaction number to this quantity adjustment and recalculates the item's Quantity on Hand and Quantity Reserved. DPS also creates and posts a journal entry transaction, if the Skip GL option is cleared. The transaction amount is the amount displayed in the Total field on the grid.
Print After you click this option, select one of the following:
  • Select Print Current Adjustment to preview a report of the current transaction.
  • Select Print Active Group to preview a report for the current group of transactions.
  • Select Select Adjustment to Print to display and select from a list of all quantity adjustment transactions that have been posted. Select the ones for which you want to generate a report.
Help Click this option to display the DPS online help.

Fields

Field Description
Transaction Number This field displays the next inventory transaction number.
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 who started the Inventory application for this browser session. Click to select a different employee name.
Comment Enter comments or notes in this field. The header of the Quantity Adjustments report displays the contents of 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.

Items Grid Toolbar

Field Description
Insert Click this button to add a blank row to the grid.
Copy Click the row to copy, and then click this button.
Delete Click the row to delete, and then click this button.

Items Grid

Field Description
Item Click and select from a list of inventory items.
Description This field displays the item's description.
Location Select the location from the drop-down list.

This field displays the item's default location if:

  • It is specified in the Default Location field on the Inventory tab in Settings > Purchasing & Inventory > Items Master and
  • The Default in Location for Inv Transactions sub-option is selected on the Inventory tab of Settings > Purchasing & Inventory > Company.

This field displays if the Allow Modify Locations option is selected on the Inventory tab in Settings > Purchasing & Inventory > Company. It indicates the location of the item whose quantity you are adjusting.

Qty on Hand This field displays the item's quantity on hand at the location selected.
Adjust Qty Enter the amount by which you are adjusting the Quantity on Hand.

You can enter a negative number if it does not reduce the Quantity on Hand to less than zero.

If you enter a positive number, the Unit Cost field is editable.

U/M This field displays the Item's unit of measure for the quantity on hand at the Location.
Unit Cost This field displays the Item's average actual cost.

This field is editable if you enter a number greater than zero in the Adjust Qty field.

DPS recalculates the Item's average actual cost any time you change this value.

Total This field displays the result of the calculation (Adjust Qty * Unit Cost).

This is the amount of the journal entry transaction that you create when you click Post Adjustment on the toolbar.

Project Click and select the project to which to post the entry that offsets the entry posted to the Inventory Common project. The project you select here can be of any charge type. It is not necessary for the project to be an overhead project.
Phase Click and select the phase to which to post the entry to offset the entry that you posted to the Inventory Common phase.
Task Click and select the task to which to post the entry to offset the entry that you posted to the Inventory Common task.
Account Click and select the account to which to post the credit entry for the amount of the increase in unit cost shown in the Total field.
Skip GL This check box is usually cleared. It is equivalent to the Suppress Billing check box in Billing. Select this option to block this journal entry transaction from displaying on the general ledger.
Reason Code Select the quantity adjustment reason from the drop-down list.