Skip to main content

Notifications

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

Dimension analysis of registered sales invoices

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

Categories:
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Dimension analysis of registered sales invoices

    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
    Jun Wang 7,435 Super User 2024 Season 2 on at
    RE: Dimension analysis of registered sales invoices

    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans