web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 Rahul.p 632

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

Categories:
Development / Customization / SDK
I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Rahul.p Profile Picture
    Rahul.p 632 on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 632 on at

    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
    Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Rahul.p Profile Picture
    Rahul.p 632 on at

    We fixed this issue using  data management

    Thanks for your kind support.

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans