News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Export report of Cost ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Export report of Cost Centers and whether Suspended

(1) Share

Report

Report

Posted on by aussiedsmith

113

Hi,

Been unsuccessful to find a way to export a list of Cost Centers (Financial Dimension Values) and for the list to include whether they Cost Center are Suspended.

Any ideas how to get this information out in a report?

Cheers

All responses Img

All responses (2)

Answers Img

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

Export report of Cost Centers and whether Suspended

Hi,

You can refer to this old thread: Cost centre reporting in D365 (dynamics.com), which describes some default reports in D365 on cost centre.
You can use data management to export the list of Cost Centers. By creating a custom query and selecting the relevant tables and fields, you can export the Cost Center names and their status (including whether they are Suspended) to a report.

Or you can write custom reports by querying the data using code. You can write a query to fetch the list of Cost Centers and include the Suspended field in the result.

Best regards,

Kevin
Suggested answer

Ramit Paul 22,300 Most Valuable Professional on at

Like (0)

Report

Export report of Cost Centers and whether Suspended

Hello,

This is very much possible, follow the below steps.

Use Data management to export the Financial Dimension Values data entities, you can use filter if you want to export only the "Suspended" values of Cost Centre, or any filter you can use.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans