Successfully loading data into on prem SQL. Trying to query against data but there seems to be a corresponding debit and credit for each transaction and no way to discern which is the original transaction. Set up a window function to partion by postingDate and itemNumber but it fails when there are multiple entries on the same date. You can't select negative values because occasionally office does reverse transfers.
Is there another endpoint that might add information?
Any direction is most appreciated.