We have a number of billing documents in our Billing Item DSO that are creating inverted records in the change log. The Original Stats Update Date and Billing Date are different and a 'recordmode = X' record appears with a negative value and somehow multiplies by a negative exchange rate, even though no such exchange rates exist in TCURR. This negative exchange rate give a totally inaccurate value. eg.
Original Stats Date 21/11/07 :- 0.71c * 0.69871 = £0.50 should be £0.50
New Stats Date 23/11/07: - 0.71-c * 0.69871- = £1.02- should be £0.50-
Billing Date 23/11/07 :- 0.71c*0.69871 = £0.50 should be £0.50
Total is £0.02- and should be £0.50
If we load from the Active Table, the values are OK. If it is the change log, it is wrong.
Has anyone ever come across this before?
Anyone help would be much appreciated.