Hi All
Just a heads up - just found a potential defect on Debtors Report for Foreign Currency only... believe it will just affect SQL SE.
For each invoice added to AHI0001 for 100,000 euro, the Debtor Report adds in an extra 2 decimal places in it's calculation of euro totals i.e. one invoice is 2 decimal places, 2 invoices is 4 decimal places etc etc..similar to the below:
At around 5 invoice lines, it crashes with "Error: 1908 Description: Width or decimal place argument is invalid" (I used 5 invoices of 100,000 euro each). . . It is still to be verified by Pegasus.
If you tick the 'Show Transactions' option, the report runs fine.
When running SQL Profiler, it looks as though the code sums st_fcdec ...
Regards
Tony
