"Outstanding Orders (LCY)" - VAT Calculation

Jonathan2708

Hi,

I've just noticed that the "Outstanding Orders (LCY)" field on the Customer table calculates VAT on each line then adds them up to give the total. This will often be different to the actual value printed on the order confirmation and the value that will be invoiced as they calculate VAT on the total goods. This is a problem for me as I want to use this figure for accurate credit control.

Has anybody implemented an outstanding orders value field/function that always matches the value that would be invoiced?

Any help appreciated,

Jonathan