# Stock adjustment & revaluation

A stock adjustment / revaluation allows you to modify the current quantity in stock or value of stock of a particular stock item.

A stock adjustment would typically be used when you want to specifically adjust up or down the current quantity in stock of an item for a reason other than one of the usual stock transactions such as a Dispatch or a Receive. When you perform a stock adjustment, you are also given the opportunity to specify the cost (or stock value) of the item that is being adjusted.

A stock revaluation is similar to a stock adjustment except that the only the value changes (the quantity remains the same). You are able to specify what you would like the new average cost of the item to be, and the value of the current stock is adjusted accordingly.

With both the stock adjustment and the stock revaluation, the value of the adjustment revaluation is debited to the Stock account for that item and credited to the Allocation account specified (usually an expense account).

You can create your customised list of stock adjustment reasons by using the Stock adjustment reasons.

Features

- Allows entry of who Requested the adjustment and who Approved the adjustment
- User can select from an unlimited number of customisable stock adjustment reasons
- Allocation account is automatically selected based on the stock adjustment reason
- Allocation account selection is protected by administrator permissions
- A Job can be associated with the adjustment
- Revaluations display previous stock value as well as new value
- Pop up notifications available for Items

Stock adjustment & revaluation form

Module: Inventory

Category: Stock adjustment / revaluation

Activation: Main > Inventory > Stock Adjustment / Revaluation

Form style: Multiple instance, WYSIWYS, SODA

Special actions available for users with Administrator permissions:

- Alter the User ID in the Entered by field.
- Edit the Allocation account, regardless of accounts specified in the Stock adjustment reasons setup.
- Override warning where discrepancy of more than 20% exists between the Item cost and the Current Cost / Quantity Summary of the item.
- When Enable two phase Stock adjustments has been selected:
  - Apply / Unapply stock adjustment from the Special menu.
  - Automatically apply stock adjustment on update.
- Change the User ID of the Entered by field of memos.
- Edit memos entered by other users.

Database rules:

- A Stock adjustment / revaluation cannot be given a date that is outside the range of the Extended financial year
- A Stock adjustment / revaluation cannot be deleted if its date is outside the range of the Extended financial year or before the Journal lock date
- You cannot adjust out (down adjust) more Items for an item than currently exist in the specified warehouse

Field definitions
Main

Adjustment #

Reference: Number, Read-only, WYSIWYS

This number uniquely identifies a Stock Adjustment / Revaluation. The Adjustment # is automatically generated by the system after the first update and cannot be changed for the life of the adjustment / revaluation.

If a stock adjustment / revaluation is deleted, its Adjustment # will never be used again for another stock adjustment / revaluation.

Date

Reference: Date, Mandatory, QuickList, WYSIWYS

This is the date for which the adjustment / revaluation is being performed. It can be any valid date that is within the current extended Financial year.

This date is used as the date for the General ledger journal entry.

Type

Reference: Select from list, Mandatory, WYSIWYS

- Adjustment: This allows you to specify that you are performing a stock adjustment. Once the record has been updated, you cannot change this field
- Revaluation: This allows you to specify that you are performing a stock revaluation. Once the record has been updated, you cannot change this field

Requested by

Reference: Select from list, Mandatory, HotEdit, WYSIWYS

This is the User name (not user login ID) of the user that requested the adjustment / revaluation. By default, this field is filled with the current user when a new record is added.

Approved by

Reference: Select from list, Mandatory, HotEdit, WYSIWYS

This is the User name (not user login ID) of the user that approved the adjustment / revaluation. By default, this field is filled with the current user when a new record is added.

Reason

Reference: Select from list, Mandatory, HotEdit, WYSIWYS

This is the reason for the stock adjustment or revaluation. This list contains all of the stock adjustment reasons set up by the Stock adjustment reasons facility.

When a reason is selected from the list, the allocation account specified for that reason is automatically filled in to the Allocation account field, and can only be changed if you have administrator permissions.

Allocation account

Reference: Account Field Type, Mandatory, QuickList

This is the General ledger account to which the total value of the stock adjustment / revaluation will be credited. This account is automatically filled in when a stock adjustment reason is selected, and can only be changed if the current user has administrator permissions for stock adjustments.

Entered by

Reference: Select from list, Mandatory, HotEdit, WYSIWYS

This is the User name (not user login ID) of the user that entered the adjustment / revaluation. This field is automatically filled in with the user name of the current user and can only be changed if the current user has administrator permissions.

Comments

Reference: Memo, Expandable, WYSIWYS

This is free text that can be used to enter any comments about the stock adjustment / revaluation.

Warehouse

Reference: Select from list, Mandatory, HotEdit, WYSIWYS

This is the warehouse from which the Items will be adjusted if a stock adjustment, or the warehouse for which the Items will be revalued, if a revaluation is being performed.

Item code

Reference: Text(30), Mandatory, AutoComplete, QuickList, WYSIWYS

This is the item code of the item that is being adjusted / revalued. This must represent a valid stock item, but you can type the first few letters of the code and activate the QuickList (by clicking on the button or pressing the QuickList Hot Key).

Item description

Reference: Text, Read-only, WYSIWYS

This is the description of the item that is being adjusted or revalued.

Stock adjustment

The following fields are only available when the type has been set to “Adjustment”.

Job code

Reference: Text(64), AutoComplete, QuickList, WYSIWYS

This is the Job to which the stock adjustment relates.

To display a list of all valid Jobs, click on the button or press the QuickList Hot Key.

Job name

Reference: Text, Read-only

Information is under review for a new version and will be updated soon.

Quantity

Reference: Quantity, Mandatory, WYSIWYS

This is the quantity of Items being adjusted.

Unit

Reference: Select from list, Mandatory

This is the unit in which the item is being adjusted. To change the unit for an item, click with the left mouse button on the Unit name. This will cause a menu to appear, displaying all available units for the item. The available units are dictated by the units specified for the item on the item form. When you click on one of the menu items, you will see the values in the Unit qty, Item cost and Adjustment total fields change to reflect the new unit type.

Unit quantity

Reference: Quantity, Read-only

Item cost

Reference: Currency, Mandatory

This value is the value (per single item) of the item being adjusted. The total adjustment value will be this value multiplied by the adjustment quantity.

Avg cost button

Reference: Button

This button automatically fills in the item cost field with the current average cost of the item (or if none in stock, then the last cost).

Adjustment total

Reference: Currency, Read-only

This value represents the total value of the Items being added / removed from stock for the adjustment.

Stock revaluation
Which action would you like to perform?

Reference: Select from list, Mandatory

This field provides three options that dictate the method used to perform the stock revaluation. The wording of the options change depending on whether the selected Warehouse-Item code combination is tracked or untracked.

Option one:

- Make the total stock value equal to the amount below
- This option sets the total value of the Item code in the Warehouse to the specified Amount. In other words, each unit of the item in the warehouse will have its value set so that the sum of all of that item in the warehouse will equal the amount.
- This option is only available for untracked items.

Option two:

- Add the amount below to the current stock value
- This option increases the total value of the Item code in the Warehouse by the specified Amount. In other words, each unit of the item in the warehouse will have its value increased by an equal portion of the amount so that the total value of all of that item in the warehouse will be increased by the amount.
- Add the amount below to the total stock value of each selected batch number
- This option increases the total value of each specified batch number of the Item code in the Warehouse by the specified Amount. In other words, for each batch number, each unit of the item in the batch number will have its value increased by an equal portion of the amount so that the total value of the batch will be increased by the amount.
- each unit of the item in the warehouse will have its value increased by an equal portion of the amount so that the total value of all of that item in the warehouse will be increased by the amount.
- Add the amount below to the total stock value of each selected serial number
- This option increases the total value of each specified serial number of the Item code in the Warehouse by the specified Amount.

Option three:

- Make the cost of each item in stock equal to the amount below
- This option sets the value of each individual unit of the specified Item code in the Warehouse to the specified Amount.
- Make the cost of each specified item within the selected batch numbers equal to the amount below
- This option sets the value of each individual unit of the specified batch numbers of the Item code in the Warehouse to the specified Amount.
- Make the cost of each selected serial number equal to the amount below
- This option sets the value of each individual serial number of the specified Item code in the Warehouse to the specified Amount.

Last edit: 16/01/2026

Amount

Reference: Currency

This is the amount of the revaluation. The way in which the amount is used for a revaluation is dependent on the Revaluation action.

Serial numbers

Available for serial or batch tracked items.

Special menu
Apply / Unapply stock adjustment

Reference: Menu

Information is under review for a new version and will be updated soon.