We issued a credit memo for 4 different part numbers.  On the Credit Memo all 4 prices are correct.  When we run SA-B Profit Analysis by Invoice and pull up this same Credit Memo the second line (s/b 0.4795) Cost is the same as the first (is $28.3697) and the fourth line Cost (s/b 8.4251) is the same as the third (is $7.6721).  The only reason we caught this is when we closed a Work Order for the Line 2 part number the Last was $28.3697 and the Actual was 0.4775.
 
How do we fix it and what should we be looking for to catch things like this happening?
 
Joyce
Update 7/26/13 SP1
Pervasive Ver 11.30