Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Consolidation with Imp...
Finance forum

Consolidation with Import file structure and reference documentation

(1) ShareShare
ReportReport
Posted on by mcdstyle 12

Hello All,

We currently have a situation where we need to consolidate multiple legal entities that are within D365, and a number that are not on D365. We are planning to use the Consolidation within D365 as opposed to using soft consolidation in MR. As far as I am aware we have two options: 

1) Import the balances for external legal entities via Journal into Legal Entities each month and then run consolidation (this is not ideal as it means we will have to change our Main Account configuration every month to allow manual entry on some accounts where we ordinarily would not allow it, which poses a risk [and it's not a Legal Entity override parameter, which would be great if it was]).

2) Online consolidation with Import. This seems like it would be the correct option for us so that we do not have to allow manual entry on the Main Accounts, however I have scoured Docs and the web to try and find some documentation on how to correctly configure this, but have had no luck. Does anyone have a link to further information I could read through to help my understanding? I have exported some consolidation transactions, which gave me a text file in the format I'm assuming will be used for the import - however it is not easy to understand exactly what each line represents. I can get the overall picture, but when I tried to populate a file with only a few lines and run Consolidation with Import, it threw an error and failed.

Thanks in Advance, 

LM

Categories:
Financial Management
  • Suggested answer
    PD-24051322-0 Profile Picture
    PD-24051322-0 3 on at
    Consolidation with Import file structure and reference documentation
  • KBagri Profile Picture
    KBagri 25 on at
    RE: Consolidation with Import file structure and reference documentation

    Hi

    Did anyone manage to locate any documentation regarding the file structure?

    Also, is it possible to import into different posting layers?

    In advance, thanks

    Regards

    KB

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,647 on at
    RE: Consolidation with Import file structure and reference documentation

    See below... after the date it's always 1

    after company it's either 0 or 1. 0 for +ve side of the transaction and 1 for negatives.

    After the amount it's always 0

    Last is line number for the transaction and it's a running number. This line number then help identify the corresponding financial dimension with rows starting with 7.

    ....

    5,"140200","2017/10/17",1,"EUR",0,0,1104.9,0,1

    5,"200140","2017/10/17",1,"EUR",1,0,-1104.9,0,2

    5,"140200","2017/10/18",1,"EUR",0,0,1151.98,0,3

    5,"130800","2017/10/18",1,"EUR",0,0,38,0,4

    5,"600180","2017/10/18",1,"EUR",0,0,0,0,5

    5,"200140","2017/10/18",1,"EUR",0,0,300,0,6

    5,"999999","2017/10/18",1,"EUR",0,0,0,0,7

    5,"140200","2017/10/18",1,"EUR",1,0,-300,0,8

    5,"200110","2017/10/18",1,"EUR",1,0,-338,0,9

    7,"001",1,1

    7,"023",2,1

    7,"demf",5,1

    7,"001",1,2

    7,"023",2,2

    7,"demf",5,2

    7,"001",1,3

    7,"023",2,3

    7,"demf",5,3

    7,"001",1,4

    7,"023",2,4

    7,"demf",5,4

    7,"Audio",4,5

    .....

    Unfortunately haven't seen any detailed documentation. best would be get some sample data for consolidation, enter journal entry in system. export it and see what you get. This will allow you to set the spec. Hope this helps.

  • mcdstyle Profile Picture
    mcdstyle 12 on at
    RE: Consolidation with Import file structure and reference documentation

    Hi Satish,

    Thanks for the response. I understand everything you mention, and have previously created an export file similar to the one you created - however what I am still struggling with is is there any documentation on what each field does? Eg what do the 1's and 0's represent in the lines starting with 5? I could work out that one of them was a DR/CR identifier - but not sure on the other ones. We will need to extract the information we are going to consolidate from a non-D365 entity, so will need to give the Developers of the other system a spec on what to populate each field with.

  • Satish Panwar Profile Picture
    Satish Panwar 14,647 on at
    RE: Consolidation with Import file structure and reference documentation

    In an export or import consolidation, the subsidiary legal entities are in different databases than the consolidated legal entity. The subsidiary data is exported to files that are created automatically. Those files are then imported into the database of the consolidated legal entity. So typically this option is used when multiple AX instances are present for same customer.

    However this doesn't limit us to use this feature and it will work with what you are trying to do. Only caveat is that you have to build the import files and then import in D365FO with import option. Below is sample of how this file is created.. file was created with export option. you can see how D365 created the file, if you build same kind of file, you should be able to import as well.

    Consolidate.png

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans