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

I have the same question (0)

All responses (3)

Answers (0)

Waed Ayyad 8,985 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Kacper.Domagala 62 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,228 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No