Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Advanced filtering on ...
Finance forum
Suggested answer

Advanced filtering on customer ageing report to filter data via Cost Centre

Posted on by 85
Hi
 
I have had a question from our Finance department asking if its possible to filter the Customer ageing report via the cost centres set against each project under the Financcial Dimensions which you set against each Project.
 
 
 
I have tried tried doing this be using the advanced filtering on customer ageing reports and linking the Customer table to Projects then Dimension set code
 
 
Although this does something to the reporting when I apply the search criteria in the Range tab setting Table Dimension code to filter the data on Cost_Center the results do not reflect filtering only projects and with the cost center LD :
 
 
Can any one provide some more guidance on how I might get this report to only pull through customers data for the customers projects which have the Cost Code I set as the range criteria?
 
Thanks in Advance
Neil
  • Suggested answer
    Anton Venter Profile Picture
    Anton Venter 18,625 Super User 2024 Season 2 on at
    Advanced filtering on customer ageing report to filter data via Cost Centre
    I don't see any way of getting the result you require from the standard customer againg report. It will require a customisation.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans