This table currently exists but is devoid of any usable data. There is only a recordno and metadata in this table. Based on documentation, and your own support team's confirmation by hitting the Sage Intacct API endpoint, the following fields are missing:

• BOOKID
• GLACCOUNTNO
• GLACCTRATETYPES
• OVERRIDERATE
• OVERRIDEEXPIRYDATE

Unless I'm missing something regarding the data model, I'm unaware of how to convert data to the Consolidated Currency from the records in the gl_detail or gl_entry tables without this information. This means that we cannot reproduce a General Ledger for a client that has subsidiaries (location entities) in more than one currency.

We are a powered with Fivetran user, so this is affecting our clients.