Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to import the Gene...
Finance forum

How to import the General journals using excel if account type is ledger in D365FO

(0) ShareShare
ReportReport
Posted on by 630

Hi Experts,

I am able to import General journals if Account type is customer and vendor using excel through code but i am unable to import data if Account type is ledger in D3565FO.

I want to import Account field if Account type is Ledger through code.

Please tell me how to import account if account type is ledger through code.

Thanks & Regards

Rahul

  • Rahul.p Profile Picture
    Rahul.p 630 on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    We fixed this issue using  data management

    Thanks for your kind support.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    Hi Rahul.p.,

    Have you been able to get this issue fixed?

    Would be great if you could keep us updated here.

    Many thanks,

    Ludwig

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,656 Moderator on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    you can refer these links . Once you create default dimension , you can merger it with Main account to get ledger dimension , however I recommend you to use in built entities for importing instead of writing code.  

    community.dynamics.com/.../msdynd365fo-working-with-dimensions-x-code-part-I

    community.dynamics.com/.../msdynd365fo-working-with-dimensions-x-code-part-ii

  • Rahul.p Profile Picture
    Rahul.p 630 on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    We did this in ax 2012 using following code:

    ledgerJournalTrans.OffsetLedgerDimension    =  AxdDimensionUtil::getLedgerAccountId(offsetcombinedContainer);

    but in d365fo i am not able to see getLedgerAccountId method.

    Please help me

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    Hi,

    Please check if the following post helps

    community.dynamics.com/.../how-to-generate-ledger-vouchers-using-dataentities-and-x-in-dynamics-365-for-operations

    Best regards,

    Ludwig

  • Rahul.p Profile Picture
    Rahul.p 630 on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    My management want to import by code. I explain them before for this but they want to me import through code.

    I imported  all customer and vendors records but i am unable to import ledger.

    So please share me for ledger import code.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to import the General journals using excel if account type is ledger in D365FO

    Hi Rahul,

    Why you need to do the import by code?

    We have the standard excel addin, the data management functionality, flow and electronic reporting available that can do and automate this import for you.

    Why do you want to modify something here?

    Best regards,

    Ludwig

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,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans