In BC you can easily assign a Dimension to a Sales Line. We have a requirement however to split the same Sales Line to two (or more) different values for the same dimension. I'm including a second dimension because we could have one dimension that is split and one that isn't.
Sales Line Item: Quantity 1 - Car - $10,000
Dimension Salesperson:
-Michelle - $6,000
-Greg - $3,000
-Hans - $1,000
Dimension - New vs Used
-Used $10,000
When we invoice the customer we don't want the customer to see three lines because we need three lines for three dimensions. They should only see one line for $10,000 Used Car.
I've done a lot of searching on this and haven't seemed to find a solution so I am hoping there is something simpler I am overlooking. Please note that I am just using salesperson as an example (in case there is another way to split sales - the dimension could be splitting departmental credit or anything else).
Thank you for any assistance!
