If you're talking about already-posted invoices, then you need the AP_InvoiceHistoryHeader and AP_InvoiceHistoryDetail, not the files you're using.

Have you looked at the existing Sage Report on the AP Report Menu, called AP Expense by GL Account Report?  Maybe you need to "save as", then add a run time selection for an Invoice Date, it appears to already have a selection for the GL Transaction Date.  

I was thinking the same thing. Also, the conventional wisdom was always to start with the table that has the most data, so I would recommend reversing your tables. 

Thank you that is what I was needing.

I have it set up so a custom Invoice Date range can be put in.
However in trying to reference the account key it needs to be in the range of 540000-000 and 540000-999.

However it does not return any records.

This actually ended up being an easier solution for me.

Thank you.

AccountKey is different than what you see in Sage as the Account.  Link to the GL_Account table (not GL_DetailPosting), by AccountKey, to get the Account field (for your filter).