Please can someone advise me where the "Invoice Amt" figure comes from in the above report. When we pull an Invoice Detail report looking for due invoices on a particular invoice payment type although the "Balance" for all constituent files on the report is the correct and expected figure the "invoice Amounts" bear no relation to any, current or paid invoices in the constituent records.
I.E. one constituent record on the report has an current invoice for $610.60 with a blance due of $488.48
in the Invoice Detail Report the balance is indeed $488.48 but the Invoice Amt is $3663.60 - the TOTAL in the file for ALL invoice current and paid is $7979.60
we have subsequently located a printed report from last year and the report ws working - so our IT consultant islooking into it now too