Sage 200 UKI Ideas 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

  • Paul Robinson
  • Oct 18 2018
  • Idea Accepted - Gauging Support