Aged Receivables - Modify standard report to display totals only

Epicor ERP 10
,
1

Hi there,

I’m trying to modify the standard Epicor Aged Receivables report so it displays totals only, in a specific format. I used to have this working but it was ages ago and I never backed it up :unamused:

What I’m looking for is values to be displayed like so:
CustID CustName CurrCode CurrencyTotalValue OurCurrencyTotalValue Future Current 30 60 90 120

Similarly to how it does when you check the ‘Summary Only’ checkbox. Just minus all the fluff. I can’t seem to find out what to remove so it only displays this information though, as there is a lot of values in the report. I’ve tried using ARDTLS.Calc_AgeInvAmt1 etc… but that only displays the first line and doesn’t display the summed total.

Any help is appreciated, thanks!

2

Figured it out!

Just have to take the individual values and use the ‘Sum’ function in Report Builder.