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

Notifications

Announcements

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
    KasparsSemjonovs Profile Picture
    4,802 Super User 2025 Season 2 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.

  • Suggested answer
    Jun Wang Profile Picture
    8,202 Super User 2025 Season 2 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

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,572

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 693 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans