Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Further query for how ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Further query for how to set the budget filter in daily GJ in lines level

(3) ShareShare
ReportReport
Posted on by J_Lee 1,112
 
I have followed below steps to join 'LedgerjournalTrans'  
 
 
Then, journal lines is joined.
 
However, i cannot find any financial dimension field present for me to filter. Please further advise
 
 
 
 
 
 
Categories:
Dynamics 365 Finance
  • J_Lee Profile Picture
    J_Lee 1,112 on at
    Further query for how to set the budget filter in daily GJ in lines level
    Before i update the GJ filtering (pic1)
     
     
    Then, i change the GJ filtering as below and then click [OK]  (pic2)
     
     
    when i reopen the GJ filtering, it does not be updated and keeps as pic1
     
     
     
  • J_Lee Profile Picture
    J_Lee 1,112 on at
    Further query for how to set the budget filter in daily GJ in lines level
    Thank BillurSamdancioglu.
     
    Yes, i can see this dimension when i input GJ lines.
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 18,101 Most Valuable Professional on at
    Further query for how to set the budget filter in daily GJ in lines level
    Can you see the dimensions on the journal lines when you try to fill on the accounts?
     
  • J_Lee Profile Picture
    J_Lee 1,112 on at
    Further query for how to set the budget filter in daily GJ in lines level
    Thank Andre.
     
    I have tried your suggested method. However, it does not consider the dimension in GJ line level. 
    May you advise me further?
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 296,060 Super User 2025 Season 1 on at
    Further query for how to set the budget filter in daily GJ in lines level
    Hi J Lee,
     
    When you have a query defined by the application, the dimension fields are available. In your scenario, you can try to add another table to the journal lines called Dimension Code Set. Then put your filter on that table.
     

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

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans