Skip to Content
0
Former Member
Dec 13, 2007 at 04:40 PM

Billing Item DSO - Statistics Date Invertion

25 Views

Hi Guys,

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.

Regards

Scott