I am doing a data conversion OUT of quickbooks and into some flat files to then upload into MacolaES.  I am having a challenge (especially since QB is new to me) in gathering Invoicing History by customer.

I am using Customer information from an outside (somewhat related to QB) AccessDB, but I need to be able to generate Invoice and Payment History by Customer to then create my flat files for MacolaES to upload into their system.

I am a SQL dba, so working in SQL would be my choice, however, I'm open to anything. I have downloaded the qodbc driver and it seems to be working.  I am using the RDS product to connect from a differnt server to a currently open QB file. 

My challenge is not being comfortable with the QB data, so generating information from a connection to the tables is a bit tough.

Thanks for any help.