Can someone explain the Aged Receivables Report Options to me please?

[shobdy (Shawn Hobdy)]

Hello,

I am trying to recreate the aged receivables as a BAQ to use in a few dashboards.

I have it mostly down but having an issue with some amounts going to the wrong column.

An example would be the amount in the 1-30 shows in the 31-60 column.

This only happens to a few of the customers, not all.

I think it is coming down to me not quite understanding the Report options on the Aged Receivables report.

I have Select by: Apply Date, Age by: Due Date.

What does that mean exactly?

Any help is appreciated!

[Hally (Simon Hall)]

You need to take a look at the aging format. That’s what dictates how the totals get applied to what bucket.

It does depend on how in depth the requirement is, but I’d start with using the apply date for each transaction to evaluate what bucket it needs to go into.

This post from the venerable @gpayne may help you with some examples

Aged Receivables Dashboard

Thanks Jeff. Currently, I use the Customer.CreditLimit field as it is and then have a calculated field for the ParentCredit which is - ‘’‘case when RlsHead.TopCustNum = Customer.CustNum then 0 else ParentCredit.Customer1_CreditLimit end’‘’ If I then try to sum the 2 fields for a TotalCredit- ‘’‘sum(ParentCredit+Customer.CreditLimit)’‘’, it won’t work as it says Column 'Erp.Customer.CustID is invalid in the select list because it is not contained in either an aggregate function of the GROU…

[shobdy (Shawn Hobdy)]

I am not following what that means.

Right now, all my calculations are based on apply date and it works for 95 percent of the customers.

I assume that select by: Apply Date means that it is pulling records from the apply date.

What does Age by: Due date do to this?

In the Epicor Aged receivables report for one of the customers that is incorrect, I have two invoices. (These numbers are from 2025-03-04 when I ran the reports, BTW).

Invoice 1 has a balance of -$5.45.
The apply date is 11/6/2024
The due date is 11/6/2024
The terms are set to blank. (I calculate the buckets using the terms that the invoice are set to).
This is an Unapplied Receipt if that makes a difference.
On the report it shows in the 91-120 bucket.
In my BAQ, it shows in the 61-90 bucket.

Invoice 2 has a balance of -$87.25.
The apply date is 12/3/2024.
The due date is 12/3/2024.
The terms are blank.
This is also an unapplied receipt.
The report shows it in the 61-90 bucket.
The BAQ shows it in the 61-90 bucket.

If terms are not set, what would be Epicor’s default for the aged receivables calculation?

Does being an unapplied receipt affect it somehow?

Any information would help.