Skip to main content

Notifications

Announcements

No record found.

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

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 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,443 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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans