web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Fixed asset balances f...
Finance | Project Operations, Human Resources, ...
Suggested answer

Fixed asset balances filtering by date doesn't work

(1) ShareShare
ReportReport
Posted on by Kacper.Domagala 62

Hi,

I have joined the fixed asset book table in the 'Fixed asset balances' report to be able to filter by acquisition date. It doesn't seem to work and I wonder if you can even join tables in predefined reports in D365?

Thank you in advance

 

Br

Kacper

I have the same question (0)
  • Waed Ayyad Profile Picture
    Waed Ayyad 8,959 Super User 2025 Season 2 on at
    Fixed asset balances filtering by date doesn't work
    Hi,
     
    Can you share screenshot of the filters? What do you mean by " It doesn't seem to work", the data is returned as you don't use the filter? or no data is returned?
     
     
    Thanks,
    Waed Ayyad
  • Kacper.Domagala Profile Picture
    Kacper.Domagala 62 on at
    Fixed asset balances filtering by date doesn't work
    Hi,
     
    The report is being generated, but it includes all fixed assets, including those with an acquisition date after 2024-04-30.
     
     
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,179 Super User 2025 Season 2 on at
    Fixed asset balances filtering by date doesn't work
    Hi Kacper,
     
    In your Fixed Assets Balance report, there is a limitation on the date expressions. You will have to use an expression like LessThanDate() instead of the symbol < which means if you are looking at a report before 1st May 2024 and if you are running the report on 18th June  then your expression has to be based on the number of days before which you are looking to run a report. 
    eg: expression will be 
    ​​​​​​​LessThanDate(48) 
     
    Happy to answer questions, if any.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans