Stock Adjustment

A stock adjustment can modify the quantity and value of your stock.

Media

Stock Adjustments - need to know

A stock adjustment can modify the quantity and value of your stock.

Modifications of value (accounting) and quantity (physical) can be done independently.

Depending upon your setup, you can perform quantitative Stock Adjustments from either the WMS or the main application, but not both.

There are different types of stock adjustments (see below).

The Stock Adjustment List has a control the display of stock adjustment types, specifically:

  • Stock adjustments - a change in the quantity and/or value.

  • Build assemblies - decrease raw materials (BOM), increase finished goods.

  • Break assemblies - increase raw materials (BOM), decrease finished goods.

  • Stock transfers - a rudimentary intra warehouse stock transfer. See Stock Action Transfer.

  • All - all of the above.

The default setting for this filter is 'Stock adjustments'.

Using the WMS

If you’re using the WMS adjustments to the Stock Quantity are performed in Warehouse Management Console or the Barcode Scanner Application.

See ‘Adjust Stock’ (WMS Console).

A stock adjustment will always display the total quantity on hand. When you adjust the quantity, you change the total quantity ‘on hand.

When you make a Stock Adjustment in the WMS console you alter the quantity. When you complete this action, a Stock Adjustment transaction is posted to the Stock Asset and relevant Profit and Loss account.

Edit stock value?

Once saved, you cannot edit a Stock Adjustment created from the Stock Actions Tab or the Barcode Scanner app.

To edit the Stock Value, go to Products and Services>Stock List

Find and select the SKUs whose value you want to change.

Then Actions>New Stock Adjustment

Then check the 'Edit Stock Values' box

Enter the value of the stock in the 'New Stock Value' column and save.

Not using the WMS

If you’re not using the WMS adjustments to the Stock Quantity are performed in the main application.

A stock adjustment will always display the total quantity on hand. When you adjust the quantity, you change the total quantity ‘on hand.

From the Stock Item master:

Products/Services>Items>Stock Item>Actions>New Stock Adjustment

From the Stock Item List:

Products/Services>Stock>Actions>New Stock Adjustment

(Select one or multiple Items).

Enter the new Quantity of Stock and Save.

Edit Stock Value?

Check the 'Edit Stock Values' box

Enter the value of the stock in the 'New Stock Value' column and save.

Stock adjustment Accounting

When you change the value, you change the total value of the stock asset account. A checkbox ‘Edit Stock Values’ enables/disables your ability to edit the stock value.

When you create a Stock Adjustment, the system will use the Average Cost if it’s available on the Item Master.

If there is no Average Cost and previously recorded Stock for the Item being adjusted, the system will use the Unit Cost.

Optionally you can alter this derived cost value.

When you perform a stock adjustment you are affecting the Stock Asset account and a Profit and Loss (P&L) account. You can select the P&L account. If you are not sure which P&L account to use, seek advice from a qualified accounting professional.

For example, if you are writing off stock then you are posting a loss, and therefore an expense, which should be posted (debited) to an expense account i.e. ‘Stock Write Off’. The system defaults to this account. This default is set in the Accounting Configuration. See ‘Setup accounting Configuration’.

The ‘credit’ on the adjustment will lower (credit) the balance in the stock asset account.

Find a Stock Adjustment:

Accounting >Find Transactions

If you are using the WMS a List of Stock Adjustments will appear in Products and Services. You can search from:

Products and Services>Stock Adjustments

Last updated