Comments (1)
fivetran-avinash
commented on August 30, 2024
1
Hi @brandonrf94, at this moment we cannot capture unrealized currency gains, as we would need to know what the currency exchange rates are for each transaction. This is not something that is available within the Xero connector ERD. Without it, we can't work backward to understand what the gains or losses are. More details are here in the "Note about currency gains" section of the README.
I see you created a support ticket within Fivetran regarding this being a Transformations issue. This is actually a connector issue, as we would need those exchange rates available within the ERD schema to bring into our data models and then provide unrealized currency gains in the final models.
I'd recommend updating your Fivetran support request for an update in the Xero connector to include exchange rates, and once that's provided, we can work on adding support for unrealized gains.
Hope that helps!
from dbt_xero.
Related Issues (20)
- BUG - All Xero Dbt jobs failing due to missing table HOT 3
- FEATURE - [To be able to generate Employee Remuneration Report present in Xero] HOT 3
- BUG - Reports generated from the Zero DBT package has the wrong net_amount HOT 5
- FEATURE - [Allow to Combine Multiple Xero Companies] HOT 4
- dbt_utils_unique_combination_of_columns_xero__general_ledger_journal_line_id__source_relation fails when journal line id is NULL HOT 1
- BUG - unique_xero__profit_and_loss_report_profit_and_loss_id fails when account_name column differs HOT 9
- BUG - rows in the xero__general_ledger model that have a NULL value in the journal_line_id column HOT 14
- BUG - [your bug title here] HOT 5
- FEATURE - [Add Purchase Orders to Xero packages] HOT 6
- [Bug] Bank Transaction table missing HOT 5
- [Bug] Balance Sheet duplicating totals when multiple companies are consolidated HOT 6
- [Bug] Test Failure in dbt xero package HOT 7
- [Feature] Databricks compatability
- [Feature] README Updates HOT 1
- [Feature] Xero Cash Summary report in DBT HOT 1
- [Bug] Unique combination test failing - impacts production deployment HOT 12
- [Bug] Using BigQuery adapter, validation_errors - Invalid cast from STRING to JSON HOT 7
- [Bug] ERRORS ON TRANSFORMATIONS HOT 5
- [Feature] Support consolidated currency conversion HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt_xero.