Finance | Project Operations, Human Resources, ...

Fixed asset balances filtering by date doesn't work

(1) Share

Report

Posted on by Kacper.Domagala

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

Kacper

All responses (3)

Answers (0)

Sort by

Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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 62 on at

Like (0)

Report
Copy link

Link copied!

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 2,699 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.