You can adjust the quantity in stock and quantity available by entering either a positive or negative quantity. This is used when products are damaged, misplaced or stolen.
It is better to use a Product Stock take if you have a high number of these types of product adjustments.
Product adjustments do not update sales figures. To update sales, use a credit adjustment note or invoice.
The Product Adjustment program has two separate functions:
Adjust Quantity in Stock.
Change the Unit Cost of a Product.
📌Note: Do not enter a cost unless you want to change the unit cost for a product. If you do change the unit cost, the quantity in stock will be re-valued at this new amount.
To enter stock adjustments
Choose Products, Transactions, Adjustments, Enter Adjustments.
Enter the Product Code.
Enter the Date and a Reference if required.
Enter your Quantity or Cost adjustments.
Enter a Comment if required.
Press Accept (F9) to complete the adjustment.
Press Close (Esc) to return to the menu.
Notes on the Stock Adjustment screen
Date, reference and comment fields will not display unless Retain Transactions checkbox has been selected in Product Options (Setups, Products, Options, Product Options, Options tab, Options task area).
From the menu path above, when the General Ledger Postings checkbox has been selected in Product Options, you can view the relevant general ledger account codes using G/Ledger (F4).
If adjusting the quantity in stock, enter either a positive or negative quantity. If adjusting the cost, leave the quantity at zero.
Calculated values such as quantity and cost are displayed on the right of the screen for each transaction. These are the values that will update your product details.
The transaction details are updated to the product.
If a quantity was entered, the new quantity in stock will be revalued at the existing cost to give a new value at cost.
If a cost was entered, the existing quantity in stock is revalued at this new cost.
When these values are updated to the general ledger there could be some Buying Variance calculated.
A variance is displayed when the quantity issued does not divide evenly into the total cost or price entered. The variance amount that is updated to the general ledger may differ from the displayed variance.
When the transaction details are updated to the product, the new Quantity in Stock and Value at Cost is re-calculated. This may result in a different variance from that displayed on the screen. This is the general ledger variance amount.