Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Financial reporter - Link to Financial dimension - How to use MainAccount begins with ??

Like (5) ShareShare
ReportReport
Posted on 30 Jan 2025 10:26:27 by 137
Hi Experts!
 
In Financial reporter row definition - Link to Financial dimension, I need to pick all the main accounts that start with '4', is there a syntax that I can use?
 
Using main account ranges is not an option for me :(
 
Thanks a lot in advance for your help !
 
Regards, 
Cyrille
Categories:
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,291 Super User 2025 Season 1 on 30 Jan 2025 at 21:57:00
    Financial reporter - Link to Financial dimension - How to use MainAccount begins with ??
    There's a parameter in Report display options to not display rows with $0.  This might help you.
  • Cyrille16 Profile Picture
    Cyrille16 137 on 30 Jan 2025 at 11:38:28
    Financial reporter - Link to Financial dimension - How to use MainAccount begins with ??
    Hi Adis, 
    Thank you for sharing the material. I find it useful to learn [4*] can be used to pick main accounts starting with 4.

    Now it seems I formulated the question wrongly.
     
    I need to pick all main accounts starting with 4, AND each of the account balance to be greater than 0.
     
    Any idea how to solve for this?
     
    Cyrille
     
  • Verified answer
    Adis Profile Picture
    Adis 2,731 Super User 2025 Season 1 on 30 Jan 2025 at 10:54:19
    Financial reporter - Link to Financial dimension - How to use MainAccount begins with ??
    Hey,
     
    This might help:
     
    Kind regards, Adis
     

    If this helped, please mark it as "Verified" for others facing the same issue

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans
Loading started