Hello,
I need to show into a dashboard the amounts we paid to suppliers giving a fiscal year. My findings so far were to sum up APInvHed.InvoiceAmt field group by vendornum and fiscalyear.
Which gives me an amount.
But for the current year, the amount is $20000 more than the amount showing in supplier tracker
my query gives 
but in supplier tracker , under links/invoices/All, grouped by fiscal year:
2018 gives me 
and under Aging: the YTD shows even a bigger difference as :
where this amount is indicated as PAID ytd…now that confuses me more…as I would have tought the YTD Paid amount would be less than my total as some invoices may not been paid yet… guess not…
So I am confused as maybe I am not using the right field… This example has no currency issue as the docInvoiceAmt is the same.
Can someone enlight me on what fields I sould sum up to show the right info?
Total invoices amounts by vendor, by fiscal year.
thanks in advance.
Pierre