Dear community,
I would like to ask you for some advice regarding how to track sales statistics for a customer as a whole and per customer workplace unit, if it is possible.
To make this a bit more clear, please consider the following:
We have a very large customer with several different workplace units/shops (50 +) spread out throughout the whole country. All of these workplace units are billed to a central address.
As of now, in order for us to be able to track the sales statistics for the large customer as a whole and each workplace unit individually, we have spread out the workplace units on several different customer card within the no.-series 500 000 to 600 000.
As you can expect, if any information regarding the customer needs to be updated, this will be a quite cumbersome task because we have to update the informaiton individually on each customer card. Another issue with this is that this customer has several different cross-references, which means that we need to insert these cross-references for each individual customer card.
What I would like to be able to achieve is the following:
Only use one customer card for the large customer and use a dimension called "Workplace unit" with the different workplace units/shops as dimension values.
When registering a sales order on the customer card, we manually choose a dimension value for the dimension "Workplace unit" dependning on which workplace unit the sales order belongs to.
So my questions are:
- Is this a good way to solve my problem, by using one customer card and a dimension with several dimension values?
- Will I be able to see the sales statistics as a whole and per workplace unit? I am unfortunately not used to working with dimensions and dimension reports.
- Any other advice/solution on how I could solve my problem?
Thank you very much for your help.
