There are 3 modes of Stock Adjustment entry.
- Stock Quantity Adjustments ('Stock Qty' batch type) allow adjustments to stock quantities, but do not change the Average Cost
- Stock Value Adjustments ('Stock Value' batch type) allow adjustments to stock valuations and hence the Average Cost, but do not change the quantities
- Stock Opening Balances ('Stock Adjust' batch type) allow entry of quantities and stock values and also update the Average Cost (and also Last Cost or Standard Cost if costing is on this basis)
In Stock Adjustment Entry double-clicking on the Quantity, Rate or Value controls, when entering a new transaction, brings up a Stock Adjustments Calculation popup form to facilitate the calculation of stock quantities and values.
Double Click on non grey portion of data screen to bring up this screen. The adjustment is for $-2.88 and it has shown the result of this value adjustment.
You can carry on making adjustments and see what the result will be.
Press OK to accept your calculation.
RETURN GOODS TO A SUPPLIER
If a stock return to a Supplier will also result in a credit note there needs to be a two step approach.
You will need to generate an AP Credit and then do Stock Quantity Adjustment to maintain the stock ledger for the quantity. If the value of the Credit Note is not at the system valuation rate then you will need to do an Opening Balance Adjustment which will allow a Qty and Value adjustment.
STOCK QUANTITY ADJUSTMENT
All
This field is relevant only when opening a Batch which already exists. By "ticking" this box, all previously entered transactions, for the Batch which you select, will be displayed. If this field is left blank, none of the earlier entries will be visible.
Batch Number
Enter a Batch Number, select one from this list or create new. The batch date determines the period of the transaction.
Stock Location
Enter the location of stock to be reduced by these issues.
Item Date
Enter a Date for this transaction.
Stock Code
Enter the stock code you wish to adjust
Qty
Enter the adjustment quantity or Double Click on the quantity to bring up this calculation screen. Pop up only works prior to entering anything.
Details
Enter transaction text
Transaction Report
Use the print function to produce a report of the transactions entered.
The bottom of the screen displays the various costing rates for the stock item. The Rate used is as per the Control Parameter and is displayed at the top of the screen.
STOCK VALUE ADJUSTMENT
All
This field is relevant only when opening a Batch which already exists. By "ticking" this box, all previously entered transactions, for the Batch which you select, will be displayed. If this field is left blank, none of the earlier entries will be visible.
Batch Number
Enter a Batch Number, select one from this list or create new. The batch date determines the period of the transaction.
Stock Location
Enter the location of stock to be adjusted.
Item Date
Enter a Date for this transaction.
Stock Code
Enter the stock code you wish to adjust
Value
Enter the adjustment value. Double Click on the value to bring up this calculation screen
Details
Enter transaction text
Transaction Report
Use the print function to produce a report of the transactions entered.
OPENING STOCK BALANCES
All
This field is relevant only when opening a Batch which already exists. By "ticking" this box, all previously entered transactions, for the Batch which you select, will be displayed. If this field is left blank, none of the earlier entries will be visible.
Batch Number
Enter a Batch Number, select one from this list or create new. The batch date determines the period of the transaction.
Stock Location
Enter the location of stock.
Item Date
Enter a Date for this transaction.
Stock Code
Enter the stock code you wish to adjust
Qty
Enter the adjustment quantity.
Cost Rate
Enter the rate relevant to this transaction. The bottom of the screen displays the various costing rates for the stock item from the Item Masterfile. The Rate defaulted is as per the Control Parameter and is displayed at the top of the screen
Double Click on the Quantity, Rate or Value to bring up this calculation screen
Details
Enter transaction text
Transaction Report
Use the print function to produce a report of the transactions entered.