Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Mapping Source System ...
Finance | Project Operations, Human Resources, ...
Answered

Mapping Source System Value to a D365 Dimension Value

(0) ShareShare
ReportReport
Posted on by Community member 8
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
  • Community member Profile Picture
    Community member 8 on at
    Mapping Source System Value to a D365 Dimension Value
    Thanks Andre - seems like we will have to do the transformation outside of D365.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,735 Super User 2024 Season 2 on at
    Mapping Source System Value to a D365 Dimension Value
    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.
  • Community member Profile Picture
    Community member 8 on at
    Mapping Source System Value to a D365 Dimension Value
    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.
     
     
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,295 Most Valuable Professional on at
    Mapping Source System Value to a D365 Dimension Value
    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.

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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans