Displaying Account Structure and dimensions mapping

(0) Share

Report

Posted on by Community Member

Hi Guys,

Need your advice.

I am importing data coming from API into General Ledger Journal. For this I have a separate settings form where I have logic for mapping Journal columns to my csv columns. But I have difficulty with mapping account (AccountDisplayValue in LedgerJournalLineEntity).

As AccountDisplayValue field could be any account structure assigned to a company I need to have functionality on settings form where user can select account structure and depending on selected structure, its dimensions will be displayed.

Could you suggest what Tables or Entities I can use for this (as I understood account structures are stored in DimensionHierarchy table but don't know where dimensions are)?

Or maybe you can advice a better way to do such mapping.

Thank you for your help!

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

Hi PolinaK,

Are you using data management import projects, Odata or other custom options to import the data from API? What is API here?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi PolinaK,

Please check the DimensionAttributeValueGroup.

Here is an blog about getting General Ledger Data from AX by SQL:

www.instructorbrandon.com/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Its a custom API which I call from the code to get csv from another system, I am not using data management import projects.

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

Like (0)

Report
Hi PolinaK,

You can probably use the class LedgerDynamicAccountHelper.

Example:

LedgerDynamicAccountHelper::getDynamicAccountFromAccountNumber("100120",LedgerJournalACType::Ledger);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guys,

Thank you for your help but I'm still feel lost.

So, maybe I explained bad what I need. Correct me if I am wrong, but as I understood, we are setting DisplayValue into ledger journal which should be in format account and dimensions (segments) of account structure divided by separator. So, if account structure has one account, two segments and separator is '-' then display value must be 'account-segment1-segment2'.

What I need is a dropdown where user can select account structure and depending on selected structure its account and segments are shown in ordered way (not possible combinations but names of segments).

Something like we can select account in grid on Journal Voucher form but there segments are shown depending on selected account whereas I need on selected account structure.

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

Like (0)

Report

Using the data entities, you can specify which dimensions will be supported during data import. You mentioned that you are writing custom code. In that case, try to see how Microsoft is doing it with the data entities.

docs.microsoft.com/.../financial-dimension-configuration-integration

Was this reply helpful? Yes No