Finance | Project Operations, Human Resources, ...

Data Syncd from D365FO to Azure Synapse

(1) Share

Report

Posted on by mahmoud_algindy

277

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.

All responses (7)

Answers (0)

André Arnaud de Cal... 294,707 Super User 2025 Season 1 on at

Like (0)

Report

Data Syncd from D365FO to Azure Synapse

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.
mahmoud_algindy 277 on at

Like (0)

Report

Data Syncd from D365FO to Azure Synapse

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.
Suggested answer

André Arnaud de Cal... 294,707 Super User 2025 Season 1 on at

Like (1)

Report

Data Syncd from D365FO to Azure Synapse

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.
Suggested answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

Data Syncd from D365FO to Azure Synapse

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
André Arnaud de Cal... 294,707 Super User 2025 Season 1 on at

Like (1)

Report

Data Syncd from D365FO to Azure Synapse

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

mahmoud_algindy 277 on at

Like (0)

Report

Data Syncd from D365FO to Azure Synapse

After some trials,

The column related to DataAreaId can be taken from:

Table:

GeneralJournalEntry

Column:

SubLedgerVoucherDataAreaId
Suggested answer

André Arnaud de Cal... 294,707 Super User 2025 Season 1 on at

Like (3)

Report

Data Syncd from D365FO to Azure Synapse

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.