I currently implemented a technology from cdata software (cdata.com) that replicates tables from QuickBooks (contractor version 18) to SQL (screenshot attached) and, I'm now in the process of trying to create an accounts receivable report based off of the newly replicated data.
Do any of you experts know which tables (presumably credit memos and invoices) and data in those tables I will need to get proper AR data? I'd like to be able to see the current AR, 1-30, 31-60, 61-90, 91+ days past due, if possible.
Thank you all, in advance!!