Quantity Adjustments Form

Use the Quantity Adjustments form to make and post a journal entry transaction that adjusts an inventory item's quantity in your general ledger. You can enter the quantity of an item before it is marked as an inventory item, or vice versa.

This form also serves as a history loading utility, to enter a record of your inventory items. Vision uses this data to calculate each item's initial Average Actual Cost as New Unit Cost/New Quantity on Hand.

Select the Skip GL option on the Items Grid of this form to prevent Vision from creating and posting a journal entry transaction for this quantity adjustment.

Location

To display the form, complete the following steps:

  1. From the Vision Navigation menu, click Inventory > Transactions > Quantity Adjustments.
  2. To enable the fields, click and select a quantity adjustment transaction on the lookup or click New on the toolbar.

Contents

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. Vision assigns a transaction number to this quantity adjustment and recalculates the item's Quantity on Hand and Quantity Reserved. Vision 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 Vision 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 Vision 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 in Accounting System Settings Configuration for the fiscal period or fiscal year in which you are entering 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 an accounts payable payment processing 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 tab in Configuration > Accounting > System Settings that have the same fiscal period or fiscal year in which you are entering transactions, or no fiscal period or year entered for them.

If you have multiple companies, the Diary 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 Configuration > Purchasing & Inventory > Items Master and
  • The Default in Location for Inv Transactions sub-option is selected on the Inventory tab of Configuration > Purchasing & Inventory > Company Settings.

This field displays if the Allow Modify Locations option is selected on the Inventory tab in Configuration > Purchasing & Inventory > Company Settings. 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.

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