Aged AR report different results

Epicor ERP 10
1

I’m running the Aged AR report with the exact same options except once with the Age By as Due Date and once with the Age By as Invoice Date.

When I change this filter, I get two different amounts in the total for the report.

I exported the reports to CSV and compared the difference and it’s come down to two invoices from the same customer. These invoices aren’t future dated or anything weird.

Any idea on why one filter would pick them up but not the other? Shouldn’t that filter just change the aging buckets but keep the same total?

2

We have this happen in E9 occasionally. We never found a cause or a fix. Did you ever come up with a solution?

3

From help

Due Date

Determines the period from which invoices are aged. Due Date bases invoice age on the difference between the payment due date and the Aged As Of date.

Invoice Date

Determines that the parameter from which invoices are aged is Invoice Date . The report groups the invoices into aging brackets based on the difference between the invoice date and the Aged As Of date.

4

Reviewing the report executed via “Due Date” or “Invoice Date”. Invoice Date is causing the future totals per customer to be zero due to it being calculated by invoice age in the expression for the field. Below is a list of expressions for the calculation of the future total results.

Report Total:

=CDec(ReportItems!TotalSumReportAgedTotal.Value)

Future Expression:

=CDec(ReportItems!TotSum_Grp1CalcAgeInvAmt1.Value)

Customer Future Expression:

=CDec(RunningValue(IIF(Parameters!SortBy.Value =“NATACCT” and Fields!Calc_CustID.Value <> Fields!Calc_LevelCustID.Value,CDec(0),Fields!Calc_AgeInvAmt1.Value),Sum,“Group4”))