Hi,
I would just need a simple (I guess?) BAQ where I could have both incoming cash per invoice per due date from the open accounts receivables data, and the same for outgoing cash due date from the open accounts payables data. The aged payables and receivables reports are cumbersome to work with as data for supplier code and the amounts are on different lines etc, even if I take it out as excel. Anyone who has done anything like this?
BRgds CH
Have you looked at the built in cash flow executive dashboard? Does it do what you’re after?
Edit: image
1 Like
Could also create a Excel friendly version of the AR and AP aging reports.
Hi Chad,
yes I did, but it was on summary level, or at least I could not find it on invoice level so that I could have checked the correctness. Summary would be OK if there would be a drilldown functionality 
Ah ok, that’s the drawback there is that it’s super summarized. I don’t think there is an underlying BAQ to borrow from on that one.
There are pre-defined BAQ’s for the AR and AP Agings though that will get you you to the document level.
zHomepage_ARAgedReceivables
zHomepage_APAgedPayables
2 Likes
I will check those two: thanks!