My company just started using Salesforce CPQ and we have a structure for furniture manufacturing.
We have 3 types of products with product family:
The furniture product has dimensions that are depending of the fabric(fabric required)
He has information about the leggings required and the fabric required depending on the width of the fabric.
The fabric product has fields that shows the width of the fabric and the price.
Because the company will add new products fabric/furniture we have made a Dynamic Bundle that will gather all the furniture and fabric.
Below I am just showing the setup for one of the filters. Others are basically the same.
The structure inside the Quote Line Editor looks like this.
So as you can see first we pick the furniture type then we pick the fabric and last the leggings.
What we want to achieve is that every time a furniture is picked we gather the values of the meters needed for the fabric and when we select the fabric after an automatic calculation needs to occur.
Fabric gathers the fabric width and fabric price Furniture gathers fab required meters depending of the width of the fabric.
Let me explain it even further. When I pick a fabric the fabric gathers the data of the
for example, and then checks
Fab. Req m(140): 5.6
what occurs next is automatic calculation:
5.6 * fabric price * 1.2 * 1.4
The values 1.2 and 1.4 are just automatically calculated fixed numbers.
How can we achieve this in the quote line editor for this automatic calculation to be calculated every time i pick a different fabric or different furniture prices to change?
Here is more info that I wrote in the salesforce community regarding my problem. https://success.salesforce.com/answers?id=9063A000000imWHQAY