News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... List with Dimensions i...

Small and medium business | Business Central, N...

Suggested answer

List with Dimensions in Columns

(0) Share

Report

Report

Posted on by DinB

3,893

How can I generate List with Dimensions as Columns?

For example, I have Posted Sales Invoice with 4 Dimensions as below.

I need to see the data in following format.

Thank you

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Seraz 12 on at

Like (1)

Report

List with Dimensions in Columns

You search for the "sales lines" list.

This will give a list of all sale lines and dimension columns (use personlisation to expose the fields).

Filter on document type column to "Invoice" to get all posted sales invoice lines.
Suggested answer

YUN ZHU 86,253 Super User 2025 Season 1 on at

Like (1)

Report

List with Dimensions in Columns

Hi, hope the following helps.

How to add Dimensions to the page (Other than Global and Shortcut dimensions)

https://yzhums.com/5007/

Thanks.

ZHU

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans