Sage 50 does not show last cost price correctly.

SUGGESTED

Hi

I need a way to identify where the "Last Cost Price (Standard)" of a product, does not match the actual last cost of the most recent purchase order.  We have identified that Sage seems to get it wrong, and I'm told the solution is to compress the data more frequently as needed.  Aside from this last part being one of the most ridiculous Standard Operating Procedures Sage support have given me to work around a clear bug, I need to be proactive, and have a Sage itself tell me when it's figures are not matching, and exactly which ones.  The only way I can envisage this is running a daily query or report that looks at each of the products last cost price, and compares it to posted purchase orders, and reports items where there is a clear difference.  Any pointers, because I've been left to my own devices with this latest bug. I have over 7000 products, and no confidence that Sage is giving me accurate valuations.