NOTE: This topic describes a premium feature. If you don't have it, see Growing your business with Sage to learn more about upgrading your subscription to turn on premium features. 

About your stock details

At the top of the stock details page we show the following information about your stock item

• Stock levels. This is the number of items currently in stock and re-order details
• Sales. This shows the last sales price for the item (from your most recent sales invoice) and the date it was last sold
• Purchases. This shows you:
  • The last price you paid for the item from your most recent purchase invoice
  • The date the item was last bought
  • The average price you’ve paid for the item. This is worked out from the total price paid to date, divided by the total number of items you've bought to date

About your stock activity

Here we show you all the individual stock movements (ins and outs) for the selected stock item. We record a stock movement everytime you

• Sell an item (include it on sales invoice)
• Buy an item (include it on a purchase invoice)
• Enter a stock adjustment
• Return a bought item (include it on a purchase credit note)
• Receive a returned sold item (include it on a sales credit note)
  

Details of stock movement types

Item Details tab

The details set on the stock item’s record. Select Edit to amend this information.

Adjust stock levels

This allows you to adjust the number of items you have in stock. This is usually used after doing stock take to make sure the your stock levels are accurate, or to write off damaged stock.

When recording stock adjustments

• We update the number of items in stock
• When you add stock, we use the cost price entered on the adjustment to work out value of the adjustment
• When you remove stock, we use the cost price on the stock record multiplied by the quantity of the adjustment to work out the value of the adjustment
• To edit an adjustment for an Inactive stock item, make the item Active first

Enter a stock adjustment

1. From the Products & Services tab, select the stock item you want to enter an adjustment for.
2. Select Adjust Stock Level, then complete the required information.
   • Date - enter the date
     The date cannot be before your Year End Lockdown date and must be after your Accounts Start Date.
   • Type - Choose whether to Increase quantity or Decrease quantity
   • Cost Price - If you are adding stock, you must enter the cost price here. We show the cost price set of the stock record by default
   • Quantity in Stock - shows you the current quantity in stock
   • Increase by / Decrease by - enter the amount to increase or decrease the stock quantity by. For example, if you have 10 in stock, and want to adjust this to 15, then Increase by 5
     You cannot decrease the quantity if this makes the stock quantity negative. For example, if you have 5 in stock and try to decrease the quantity by 6.
   • Reason- Choose one of the options. To enter your own reason, choose Other and enter the text (up to 50 characters)
3. Select Save.

This automatically increases or decreases the quantity in stock. It also creates an Adjustment In or Adjustment Out transaction on the stock record.

Edit a stock adjustment

1. From the Products & Services tab, select the relevant stock item.
2. Select the Adjustment In transaction you want to edit and adjust the stock as required.
   
3. Select Save.

Delete a stock adjustment

Delete a stock adjustment at any time. When you delete an adjustment in, we update your stock levels and the average cost price.

You cannot delete an adjustment in if this results in negative stock.

1. From the Products & Services
2. Select the check box next to each Adjustment In/Out transaction you want to delete.
3. Select the Delete button , then Yes when prompted.

Managing your stock

Stock Movements report