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

Dimension analysis of registered sales invoices

(0) Share

Report

Posted on by Ricard Carreras

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:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

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 7,443 Super User 2024 Season 2 on at

Like (0)

Report

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