I recently acquired QQube for our company, and things are doing great, being able to explore different data models and Excel templates very successfully.
I´d like to ask for your help replicating some basic QB reports that don´t seem to be ready in the example list: 'Balance Sheet Detail' and 'Transaction Detail by Account'.
I´d appreciate your help.
Thank you for your comments.
A slight word of caution when showing line item details over a fairly long time period, and a fairly large file. Unless you have a ton of memory, it can really bog down refresh and display times. Just the nature of the beast.
Not available from the Intuit SDK (Intuit Software Development Kit)
Ok, understood. But do you have any suggestions on how I can build a report similar to QB Bank Reconciliation, using the available data models? From GL maybe...
Currently there is no way to do this in QQube. Without all of the details, yes, the Intuit SDK exposes a "cleared status" field, but in a manner that would add extensive reload resources every time a synch occurred. They do not make this available on a transaction by transaction "table" basis.
The Intuit SDK is full of nuances, and issues that have to be worked around - which we have done for a variety of data models, over several decades. To make this particular feature work, would require an isolated type of data model, using a different kind of engineering and resources, and is not an oft requested item.
You are welcome to post a request in our suggestions and ideas forum. Suggestions and New Ideas | CLEARIFY
Ok, thank you for the reply.
This is Fran, one of QQube's soution providers, I am curious why you would like to replicate the Bank Reconcilation Report. Are you considering using the information for other types of reports? While you can't get the exact report out of QQube, the information in a very general way is available. QQube includes a "Paid" date and a "Paid status date for each appropriate transaction. So you can generate detail reports on a cash/accrual basis.
QQube is very flexible when needing information locked in QB... Hope that helps.
Thanks a lot Fran. In fact, I didn´t need it for any special purpose other than the basic reconciliation check. As you suggested, 'Fully Paid Date' and 'Line Paid/Open Status' will fit perfectly. Thank you for your help.
Choose a location
Your session has expired. You are being logged out.