AR Totals from Customer Tracker BAQ

Epicor ERP 10
1

Has anyone been able to recreate the AR Totals in the Finance tab in Cust Tracker in a BAQ?

image
image845×255 13.8 KB

2

Should not be too hard. I have an aging that does average day to pay and all of that would just be subqueries on InvcHead, CashHead and CashDtl.

3

Would you be able to share your BAQ?

4

I DMd it.

5

See BAQ that “somewhat” mimics what you need.

AR invoices Avg Pmt Days.baq (28.3 KB)