I am trying to manage stock i my shop and am using a calculation to work out how much stock we have left. The stock remaining calculation is as follows:
c_Stock_Packets - c_Stock_sold - Sum ( Stock_Corrections::Quantity) - Sum (Shop_front_sales::Quantity)
For some reason the value in "Shop_front_sales::Quantity" field is being counted twice. E.g. when the value is 1, 2 are being recorded, when value is 3, 6 are being recorded. The other fields are being counted correctly.
This seems very strange - Can anybody help?