Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories New/Amend Order
Created by Paul Robinson
Created on Oct 18, 2018

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