Hello everyone.
I am looking for a BAQ where I can see the Average Days to Pay for each customer by fiscal year, where I can exclude the DEP invoices (Deposit invoices). My BAQ days are very much in the past, so I am much obliged if anyone can provide me with a BAQ file for what I am looking for.
I have searched several topics, but cannot seem to find what I am looking for.
1 Like
I don’t have a BAQ with exactly what you’re looking for, but average days to pay is a pretty simple aggregate calculation:
avg(datediff(day, InvcHead.ApplyDate, InvcHead.ClosedDate))
Make that calculated field and then group by customer and fiscal year, and put a table criterion on InvcHead to filter our the DEP invoices. I have this in a subquery that I’m using in a credit hold dashboard, but I’m not grouping by year:
1 Like