Is there a way to tell if a transaction has been reversed in SuiteQL? Particularly, I’m looking for the right exchange rate to use to reconstruct a balance sheet from its underlying transactions while avoiding the builtin

consolidate

function. It looks like reversals have to use the previous period’s rates instead of the reporting period’s, but I can’t find a signal that tells me my logic should be different for those cases

There's the

reversal

and

isreversal

fields on the

transaction

table

This mostly works, but some transactions show up as reversals in the UI and do not have a matching reversal ID when exported via SuiteQL. Ideas on why? Any permissions I might be missing?

You can rule out permission issues by installing and running a SuiteQL query tool as the administrator, e.g. https://nimbuslabs.com/nimbusql-installation/