We're pushing financial info from NetSuite>Budgeting system using a query in Snowflake + middleware, etc. We don't have a lot of FX stuff, but we did calculate the FX>USD conversions for our one FX sub using the Consolidated FX rates table. Works fine for Inc Stmt and non-equity Bal Sheet accounts. However, the equity accounts that have a general rate type of Historical don't technically use the current month's value, it's being calculated based on an accumulation of balances + rates from the beginning of time Has anyone figured out how to calculate this? I don't see any table out that obviously has this info. I see there's these Posting_Account_activity tables out there, which I'm not allowed to sync for some reason. Does anyone know if those tables have the amounts already adjusted for FX consolidation? If so, I might see if I can figure out why they won't drop into Snowflake. I know we could attempt to build kind of a stripped down Trial Balance or something that's in a format consumable by our budgeting system, but I'm not sure how we'd pull that info out easily in an automated way without scripting it, which I don't really want to do. Any ideas?