web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Syncd from D365FO...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Data Syncd from D365FO to Azure Synapse

(1) ShareShare
ReportReport
Posted on by mahmoud_algindy 281
Dears good day,
 
I've setup Azure Synapse Link for Dynamics 365 Finance & Operations, and successfully the data sync to Azure Data Lake, but I noticed the DataAreaId in GeneralJounralAccountEntry (just as example) is only DAT, while I've many other companies, as you know DataAreaId  is so important for Data Analysis, please help me to solve this issue?
 
I feel there is something should be done in Data Management, but not sure.
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,729 Super User 2026 Season 1 on at
    Hi Mahmoud,
     
    This is due to the design of the data model where the accounting entries are stored in a global table. You would need both the tables GeneralJournalEntry and GeneralJournalAccountEntry. The first mentioned table has a reference to the table Ledger with the same field name. This table has a field PrimaryForLegalEntity. This field has a reference to the CompanyInfo table from where you would know the Company/DataAreaId for each ledger transaction.
  • Suggested answer
    mahmoud_algindy Profile Picture
    mahmoud_algindy 281 on at
    After some trials, 
     
    The column related to DataAreaId can be taken from:
     
    Table:
    GeneralJournalEntry
     
    Column:
    SubLedgerVoucherDataAreaId



  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,729 Super User 2026 Season 1 on at
    Hi Mahmoud,
     
    I think your reply is missing some details. Or by accident deleted some words or posted too quickly. Can you review what is missing? It looks like you wanted to share a table name, but this is not visible.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Hi,
    You seem to have encountered a forum bug that I often encounter. In the forum, when you post your answer, some words may not show up, and when you click Edit to view your original answer, it will show up there. You can try line breaks, or take a screenshot of the words that can't be displayed, and upload it in the form of pictures, then you can solve this problem.
    Best regards,
    Kevin
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,729 Super User 2026 Season 1 on at
    Hi Mahmoud,
     
    I now see all the information you provided in your reply.  Note that the SubLedgerVoucherDataAreaId field might not always have a value. Linking via the Ledger is always accurate.
  • mahmoud_algindy Profile Picture
    mahmoud_algindy 281 on at
    Thank so much for all members
     
    @Andre
     
    Could you please explain it in more details, I'm sorry I'm new to FO tables and it's really so difficult.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,729 Super User 2026 Season 1 on at
    Hi Mahmoud,

    Sure. The field you mentioned you want to use does not always have a value. Have a look at the next screenshot. Instead, the Ledger field always has the correct value to be able to link it to the CompanyInfo table as mentioned in my first reply.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 666 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 207 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans