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, ... / 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,264
 
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
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at
    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.
     
  • J_Lee Profile Picture
    J_Lee 1,264 on at
    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
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 19,856 Most Valuable Professional on at
    Can you see the dimensions on the journal lines when you try to fill on the accounts?
     
  • J_Lee Profile Picture
    J_Lee 1,264 on at
    Thank BillurSamdancioglu.
     
    Yes, i can see this dimension when i input GJ lines.
  • J_Lee Profile Picture
    J_Lee 1,264 on at
    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
     
     
     

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
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans