AR Invoice payment date

Epicor ERP 10
1

I need a report that lists AR invoices including their payment date (if already paid). Which table would the payment date be in?

2

You can write a baq with the invchead table filtered for closed invoices attached to a subquery containing cashdtl, return the max date from cashdtl.

Or

a baq for invchead filtered for closed invoices and displayed the closed date.

1 Like
3

Thanks, Bryan.

Using the closed date worked for me.