Mapping Source System Value to a D365 Dimension Value

(0) Share

Report

Posted on by BP-27040915-0

Hi Experts....

I am wondering if anybody has a viable approach for the below...

We are currently building an integration between a source system and D365 e.g a general journal posting via OData REST API using the LedgerJournalHeaders and Lines entities.

The source system, for example, would supply a value for Territory as UKA01 and we would like to map it to our custom Territory dimension value of A01.

I appreciate we could build a mapping table and create custom code to swap the values prior to calling the the data entities, but (always a but)

We are keen to let the business own and update the mappings at their will and so was wondering if there was native functionality in D365 to hold mappings to dimensions?

Any thoughts would be much appreciated.

Bijal

All responses (4)

Answers (1)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

For Journal postings, there is no such mapping available with financial dimensions, however if you are using PO/SO with, you can map with Site with dimensions within D365.
BP-27040915-0 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for sharing the option for PO/SO, but in this case we needed if for general journal. As I was thinking, there does not seem to be a solution in native D365 for this.
Verified answer

André Arnaud de Cal... 307,166 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Bijal,

There is indeed no transformation option available in standard Dynamics 365 when importing data via data entities. Are you able to do the transformation in the source file? If not, you would need a customization.
BP-27040915-0 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks Andre - seems like we will have to do the transformation outside of D365.