Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: add join key between ledger_account and journal_entry_line tables in Workday Financial Management connector

Completed
Devin McManus User

The journal_entry_line table created by the Workday Financial Management connector has a ledger_account_id field in it, but this field does not join to anything in the ledger_account table. When creating a manual export from workday, you can use the "workday_id" field from the ledger_account object to join to the journal_entry_line table. You need the ledger account info in order to make the journal_entry_line data useful, otherwise you don't know which account each journal entry line pertains to. I'm not sure how you would do anything with the journal_entry_line data without the account info.  

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Official comment
    Frank Fivetranner
    • Edited

    Hi Devin, 

    We released a field called ledger_account_code which should map to the ledger account table. See the new ERD here. 

    Thanks, 

    Frank

  • Frank Fivetranner
    • Edited

    Hi Devin, 

    Thanks for surfacing this I'll take a look into this. What information about the ledger accounts are you trying to join with the journal entries?

    Frank

  • Devin McManus User

    Hi Frank,

     

    I need to filter/aggregate the journal lines by ledger account, in the "ledger_account" table the fields I would need are Name, Type, and the four-digit ID 

  • Frank Fivetranner

    Thanks Devin. It seems like something we should investigate. I've added it to the backlog for our Workday team to take a look at.