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

Categories:
Development / Customization / SDK
  • GirishS Profile Picture
    GirishS 27,799 Moderator on at
    RE: How to get Journal Name & GL Account Lookup

    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.

  • Arun Maliwal Profile Picture
    Arun Maliwal 12 on at
    RE: How to get Journal Name & GL Account Lookup

    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

  • Verified answer
    GirishS Profile Picture
    GirishS 27,799 Moderator on at
    RE: How to get Journal Name & GL Account Lookup

    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.

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

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

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

#1
Jahanvi Profile Picture

Jahanvi 34

#2
PJ JohnPaul Profile Picture

PJ JohnPaul 5

#3
SudhanshuMSID Profile Picture

SudhanshuMSID 1

Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans