Good day everyone!
After following up with professional support I have been told that what we are trying to do will not work and that the only path forward for this kind of analysis is to send everything through Adagio invoices and then use the tools provided in Sales Analysis.
We are taking this under consideration and have asked our reseller to make a request to development that would allow for better database intelligence by carrying the required information into these tables as I am certain there are others who are trying to do the same thing.
Thank you and,
Cheers, JK