web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Dimension analysis of registered sales invoices

(0) ShareShare
ReportReport
Posted on by 5

At our company we have been using Business Central for a few years now.
When we started the implementation of Business Central we defined some dimensions that later due to the workload have not been used. For example, at the beginning we defined a dimension to classify the manufacturer of each product we sell. This was one of the dimensions that has not been used during this time.
Now I have started to assign the manufacturer dimension to each of our products, because I need to do an analysis of sales by customer and manufacturer of the product.
The situation is that although I have completed the assignment of the dimensions to the products, when I run an analysis of the sales of the last year, the dimension information is not collected.
What process should you carry out so that the sales recorded in the past incorporate the information from the manufacturer dimension?
Any ideas would be of great help.

Trank you!

Ricard

I have the same question (0)
  • Suggested answer
    Jun Wang Profile Picture
    8,208 Moderator on at

    here is a post showing how to correct dimensions for posted transactions. The process is manual though. I recommend you test it out in a sandbox before making changes in live.

    www.kristenhosman.com/.../dimension-corrections-in-microsoft.html

  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,817 Super User 2026 Season 1 on at

    Yeah, as appliwin suggested, for already posted transactions You can use Correct dimensions process to add them - but this might take a lot of time - as correction can be done only for 1 transaction at a time.

    System reports will work only for the next posted dimensions.

    A workaround would be to use the reporting in Excel - export Item Ledger Entries, and have a separate table with Item No. and Dimensions value. Then do a VLOOKUP to add the needed value to the Item Ledger Entries excel table and form there You can do a Pivot table for the required analysis.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,986 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,071 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans