Finance | Project Operations, Human Resources, ...

Data Syncd from D365FO to Azure Synapse

(1) Share

Report

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)

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (3)

Report

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.

Was this reply helpful? Yes No
Suggested answer

mahmoud_algindy 281 on at

Like (0)

Report

After some trials,

The column related to DataAreaId can be taken from:

Table:

GeneralJournalEntry

Column:

SubLedgerVoucherDataAreaId

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
mahmoud_algindy 281 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No