Cost Adjustments Form

Use the Cost Adjustments form to recalculate an inventory item's average actual cost and post to the general ledger a journal entry transaction that adjusts an inventory item's depreciated cost.

This also creates a journal entry transaction posting log which you can display in Transaction Center > Posting Logs.

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

Location

To display the Cost Adjustments form, complete the following steps:

  1. From the Vision Navigation menu, click Inventory > Transactions > Cost Adjustments.
  2. To make the header and grid fields active, click and select a cost adjustment transaction on the lookup or click New on the toolbar.

Contents

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. Vision assigns a transaction number to this cost adjustment transaction and recalculates the item's Average Actual Cost. Vision 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.
Help Click this option to open the Vision online help.

Fields

Field Description
Transaction Number Vision 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 Vision 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 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.

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 Configuration > Purchasing & Inventory > Company Settings.

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. Vision 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, Vision uses your data to calculate the value in this field.

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

As an alternative, you can enter the Unit Cost Adjust in the preceding field. If you do this, Vision 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 Vision 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.