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 | Project Operations, Human Resources, ... / How to get Journal Nam...
Finance | Project Operations, Human Resources, ...
Answered

How to get Journal Name & GL Account Lookup

(0) ShareShare
ReportReport
Posted on by Arun Maliwal 12

Hi team,

I am working on a task & my requirements are: 

  1. Create a new Journal Name “SplitRevenue” to be added as shown below.
  2. Create a new GL account selection drop down for default account selection as shown below.

These Customizations need to be done on ProjParameters Table & form.

I can't find any standard EDT to assign it to Journal Name field to get all journal Name using lookup. Is their any EDT's exist in D365fo or any other way than onlookup event handler on form Control.

Also, Don't have any idea how to get the GL Account Selection drop down.

GLAccount.png

Thanks,

Arun

I have the same question (0)
  • Verified answer
    GirishS Profile Picture
    GirishS 27,827 Moderator on at

    Hi Arun,

    You can use LedgerJournalName table to add the lookup event handler or use LedgerJournalNameId EDT and see if the lookup loads automatically.

    If the EDT lookup doesn't work, then refer to the below blog for adding lookup event handlers.

    https://stoneridgesoftware.com/use-event-handlers-to-override-a-form-control-lookup-method-in-dynamics-365-finance-and-operations/

    For Main account lookup refer to the below blog.

    https://dynamicsaxtechstuff.wordpress.com/2019/01/24/how-to-add-main-account-lookup-on-form-by-using-segmented-entry-control/

    Thanks,

    Girish S.

  • Arun Maliwal Profile Picture
    Arun Maliwal 12 on at

    Hi Girish,

    Thanks for the Reply.

    I got the lookup for Journal Name & GL Account as well.

    In addition to above, This task needs to create a journal & post it & other steps are there.

    I am attaching a word file which contains the complete task, I need help to understand where to write code & how to start which specified in point 4 in word file.

    PBI-11298-_2D00_-FP-project-split-revenue-modification_5F00_v3.docx

    Thanks,

    Arun

  • GirishS Profile Picture
    GirishS 27,827 Moderator on at

    Hi Arun,

    Please close this thread and create new thread with the required scenarios, since you got the answer for the question you asked. So that other member when looking at this thread will not be confused.

    Also please mark the helpful answers as verified by clicking >> Did this answer your question >> Yes on the particular reply.

    Thanks,

    Girish S.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans