If I run the item history report and select “Quantities and Values” as a function, I am seeing some discrepancies in the p-price column for items that have been put back in to stock via a returned goods record.

To recreate, load GB Sample data

Enter a sales order for customer 047 for item 10111 qty 2 (make sure paste components is not ticked for item 10111)

Save and then create a delivery for the sales order.

Now from the sales order, create a retuned goods record

Reduce the qty ordered and delivered, make sure update stock is ticked and ok and save

Now check the item history report

You will see that for example, item 10107 has been taken out of stock by the delivery with a p-price of 6.26915, however, it has been put back in stock by the returned goods with a p-price of 62.6915


It seems to all be to do with the fact that item 10111 is a structured item and instead of taking the unit price of component 10107 from its item card, it is picking it from the delivery but using the original total for that item as the p-price

I have tested in the latest version, and the issue is still present.



I have an item in my system that has a recipe of 20,000 grams in and 1 box out.


I now have a returned goods record for 3 boxes which has valued each gram at £304, not 0.052p!!

How do I fix this in my system so my stock history report is correct?