I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date (docdate, postdate, etc.) should be used.

So I sort through the tables/date that made sense to me from here: https://sageaom.kcsvar.com/AOM2017/Advantage.xml and came up with the following query to sum invoices for a month:

Invoices:

Select sum(INVSUBTOT) FROM [COMPANY]..OEINVH where [INVFISCYR] = '2022' AND [INVFISCPER] = '9'

Credits:

Select sum(CRDTOTAL)*-1 FROM [COMPANY]..OECRDH where [INVFISCYR] = '2022' AND [INVFISCPER] = '9'

The sum of those two do not seem to match the sales history report I pull from out of OE. OE Sales History Report is nearly half of what this query generates

What am I missing?