[Feature] enable for multiple books support for Consolidated Exchange rate

[rwang-lyra]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

Context Our Netsuiite has two books enabled: primary and adjustment. The adjustment book includes all transactions on primary + additional transactions. That relationship between books is noted in the database by the fields is_primary and adjustment_only.

Issue : Consolidated exchange rates are also by book which impacts the values in converted_amount. In the final datasets we would expect to see two lines (one primary, one adjustment) for each transaction recorded to the primary book, translated at the relevant consolidated exchange rate.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response

[jmongerlyra]

@rwang-lyra We can close this issue as completed.