Subject: Request: add Sage Intacct Consolidation History to our connector sync

Hi Fivetran Support,

We use the Fivetran Sage Intacct connector to load into BigQuery (project: supportninja-finance, schema: src_sage_intacct).

We need the data behind Consolidation > Consolidation history in Sage Intacct synced to our destination. The Sage list shows these fields for each run: ownership structure, book, entity name, consolidation period, ending spot rate, weighted average rate, run date and time, run by, consolidation state, and details. It has about 2,658 rows today, and each month's close adds more.

What we see today in the schema: the standard exchange_rate, exchange_rate_entry and exchange_rate_types tables, plus journal, user_adj_book and user_adj_jrnl. None of them hold the rates produced by each consolidation run, and we don't see a consolidation history table in the schema tab to enable.

Could you please:

1. Tell us whether the connector supports this object (or the underlying Intacct object), which table it syncs to, and how to enable it.
2. If it isn't supported, tell us whether it can be added as a standard table or through a custom object option, and give us a timeline or a feature request reference.
3. Confirm whether it can sync incrementally. A consolidation rerun creates new rows for the same book, entity and period, so we need the run date and time on every row to identify the latest run.

This feeds our monthly FX conversion in revenue and financial reporting. We load it by hand today, so an automated sync would remove a recurring manual step at each close.

Thank you,
Bala Puli, VP of Finance
Global Finance & Accounting, SupportNinja