Hello! From a Currency Revaluation (Unrealized Gain/Loss) transaction. How can I get the details of the open receivables/payables that the reval is related to? As this is a monthly revaluation, transaction_links just refer to the reversal. What I need is to fetch the currency of the original transactions. Right now I only have the base currency for the revaluation. (the fx-amount is 0, but I still need what currency it was)

it seems to me that when they are unrealized gain/loss for open payable or open receivable you have the details with the type (journal, Bill, invoice, etc.) and the source currency. On the other hand, if you talk about the revaluation for the other accounts, in fact we do not have the details. The only way to have it is to customize a balance sheet and filter on the account in question which has been revalued and add a filter linked to the currency.

I should add that I need it through SuiteAnalytics Connect (odbc/jdbc)