Comments (14)
My understanding is that the 0 journal entry amounts are for audit trail purposes.
I would always expect a journal_line even for the 0 entries.
It might be that there are two entries 1 at 0 and 1 when it's updated. I'll have to look into this
from dbt_xero.
Hi @jazzy-r, thanks for opening this issue!
I would first like to confirm that this is not an error from the connector. Would you be able to confirm within your Xero application that for one of these journal_id
s that have null for the journal_line_id
, do in fact have no journal_line_id
.
Our assumption when developing the package was that the journal_line_id
would always be populated and be the true unique identifier for these journal records. t would be great to confirm that assumption with your live data.
from dbt_xero.
Hi @fivetran-joemarkiewicz no problem.
How would I go about verifying that there is a journal_line_id in the xero application?
from dbt_xero.
I believe if you go to the general_ledger_report within Xero and filter for one of the entries, you should be able to double click on the journal entry and see if there are journal lines that make up the entry.
from dbt_xero.
I've had a quick look and I can't actually find a way to link these rows with test failures to an entry in the general ledger.
It seems this is because many of the column values are in fact NULL.
from dbt_xero.
Interesting, my understanding is that the journal
table would only contain the metadata of the journal record, and then journal_id
would contain the monetary value of the entry. I would assume journal
would not exist without a journal_line
entry?
Would you be able to run the below query and see if you obtain any results? When I run, I see no results. If you do see results, I think we may want to open a support ticket to dig into this behavior in the connector.
with journal as (
SELECT *
FROM xero.journal
), journal_line as (
select *
from xero.journal_line
)
select
journal.journal_id,
journal_line.journal_line_id,
journal_line.gross_amount
from journal
left join journal_line
on journal.journal_id = journal_line.journal_id
where journal_line.journal_line_id is null
from dbt_xero.
I ran the above query but changed the FROM clause to match the schema we use:
The tables were stg_xero__journal and stg_xero_journal_line.
It returned rows. Can you confirm that what I did was correct?
from dbt_xero.
@jazzy-r yeah those changes are fine and wouldn't alter the intention of the query.
I just confirmed with our PM of this connector that it is the intended behavior of Xero that a journal_line entry should be present for each journal entry. Would it be possible for you to confirm internally what these journal entries in fact are and if they should be tied to a journal_line entry? If so, this may be a bigger question for Xero as to why these journals are not matching to their respective journal_lines.
from dbt_xero.
@fivetran-joemarkiewicz I've been discussing this with the finance team. It seems it might be instances when a journal entry was created using 0 amounts and / or when this journal is updated again.
from dbt_xero.
Thinking through these cases 🤔
- What would be the business reason for 0 journal entry amounts?
- If the journal is updated again (I assume to have > 0 amounts) then I would expect a journal_line. Is that not the case?
from dbt_xero.
Hey @jazzy-r! I just wanted to check in if you had a chance to look into this further?
from dbt_xero.
Hi @fivetran-joemarkiewicz yes but I didn't get any further with it. Not sure what else can be done.
from dbt_xero.
Thanks for the update @jazzy-r.
I think what will probably be the next best step is to open a ticket with our Support Team as they will have a better idea about what next steps should be taken to look further into this on the Xero side. Unfortunately, I do not have much visibility in this area, but they have helped a lot of other folks with similar questions and I believe they can help us get to the bottom of this question!
from dbt_xero.
Hi @jazzy-r 👋
I will be closing this issue as I assume the thread has moved to the support channel. Please feel free to re-open this issue if you would like to discuss this further.
Thanks!
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 - [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
- [Bug] Unrealised Currency Gains not reported HOT 1
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.