Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

Sales Return to use actual cost on stock items rather than average when using actual cost for batch traceable items

Currently when recording a sales return in the program for a stock item which is batch traceable and using 'actual' cost method the system will allocate the average cost price rather than the actual price. Example below - Create a product group using batch numbers and actual cost.- Create a stock item linked to this product group- Raise a purchase order for 2 @ £15 each (batch 1)- Raise a purchase order for 2 @ £40 each (batch 2)- Complete both purchase orders- The stock valuation correctly shows a qty of 4 and a value of £110- Raise a sales order for 1 from batch 1- Complete the sale order- The stock valuation correctly shows a qty of 3 and a value of £95