Hello,
I am trying to create a report where I can filter by customer and see historical AR data in addition to the current AR.
Ex: See current buckets and also what those buckets looked at the end of each of the previous 3 months.
Do I need to build this model up from the transaction level or does someone have a recommendation of how I can do this with the example solutions?
I know this is a late reply, but this is a good question to answer so that others might benefit.
We can't reverse engineer an A/R report from the Intuit SDK - because certain pieces are missing, so we have to use the "report query" that the SDK makes available to get the appropriate A/R data. We pass through the "as of date" you provide in the QQube Configuration Tool.
The limitations of this method, is that you can't have more than one iteration of A/R on hand. You could change the A/R data, and then put that on a different sheet in your Excel workbook, and then only refresh the current sheet with the current A/R data - and not refresh the others. (You could also lock those other tabs in Excel).
If you want to look at historical A/R in a general sense, you could use the Trial Balance Activity Data Model, as it shows monthly A/R balances going back three years. A future version of QQube will be able to show the historical daily balance of open A/R - but not by specific customer at this time.
Choose a location
Forum :
Your session has expired. You are being logged out.