Who has built BAQ before. Please share

Anybody who knows how to do this?

The BAQ gives the current status only. You cannot use it for historical data. An invoice might have been open in January but in february its closed. When you age by 31st of January it should appear in the aged report which is not the case on this BAQ

[image] JaneToo: The BAQ gives the current status only. You cannot use it for historical data. I think this may be a disconnect. An “Aged Receivables” only includes unpaid invoices by definition. An Average Days to Pay report sounds like what you are looking for possibly.

Have a quick look at how it works. If you chose age as last week Tuesday you will get different data when compared to Age as of Today

[image] JaneToo: The BAQ gives the current status only. That BAQ yes, you’d have to create a more complex query to walk through the transactions from today to whatever date backward they’d want. I’m not sure a BAQ could do this without timing out as I’ve never tried. If they want the expande…

the AR Aging report that Epicor delivers does not use a BAQ to generate, because of the complexity to calculate the aging “as of” a date… if you are running it “as of now” then a BAQ could certainly be used, but if you want it “as of Jan 31 2023” then you must take the current balance and back out a…

Transforming AR aged report into a BAQ

Epicor ERP 10

Randy (Randy Stulce) February 20, 2023, 2:27pm 3

Found this thread with a quick search Aged AR Report in BAQ - #2 by lgraham

Topic		Replies	Views
Aged AR Report in BAQ Epicor ERP 10	8	7053	May 6, 2026
AR Aging Report Epicor ERP 10 e10	6	1328	February 21, 2023
Creating Buckets in BAQ Epicor ERP 9 baq	11	2077	February 23, 2021
Aged Receivables Report :: How does it calculate? Epicor ERP 10 baq	6	6444	June 9, 2026
I want to get BAQ see this report Aged Receivables by AR Inivoce Epicor ERP 10 baq , reports , dashboard	1	707	March 31, 2022

Transforming AR aged report into a BAQ

Related topics