You are probably going to need Access to do this and do it in multiple steps. You would first need to build a table with the invoice data and check number.  Now for the GL an Invoice hits many tables, AR, COGS, Sales, Inventory, Freight. Did you  need it for every account it hits?

No i just need the ones that hit the 1400 up to 1413 the assets accounts.

Just curious if you got a solution to this?  I have been tasked to create a report like this.  The comments that are generated combine several field and I would like to break them apart.  Thanks!

The only way I have been able to do this by bringing the data into Microsoft SQL and creating views.  Once you have the data in SQL, linking the tables will be much easier and you will not have speed issues due to the massive amount of records in the tables you need to reference. 

The hardest part for me is identifying the tables that will bring the fiield (S)  that I need . I can download a different  query for  each tables and with a single common and unique number for entry I can do wonders in Excel . Example the invoice # field. No way of doing it that way? 

The problem is that some GL data will be summarized, and not have a one-to-one relationship with a single transaction.

You might find better results not starting with GL history, instead using the AR/AP invoice history, and GL accounts from the lines.