I am needing to advance our pricing and quoting method in our instance. We sell ERP business systems to specific industries. I currently have five different pricing methods. For example, our one pricing method is a fixed rate method in which the total is based on the amount of the product times the quantity purchased/quoted. This is working per the current calculation on the total_amount field. However, we have four other Pricing Factor Options that we are needing to configure so the total_amount field calculates the correct total.
For instance, products that have Pricing Factor 1 will add 2950.00 to each additional quantity (past 1) that is added in addition to the base price of the item. So our item's base price is 3850.00. If the quantity on the Quoted Line Item is 1, the total_amount field will equal 3850.00. But if the quantity is equal to 2, the total_amount field should equal 6800.00 (3850.00 + 2950.00).
Each of my products in the product catalog have the Pricing Factor Option along with the corresponding Pricing Factor Amount selected on the Product Catalog level. When the product is chosen on the quote as a quoted line item, the Pricing Factor Option on the QLI item will auto-populate with a relate logic hook calculation that will get the Pricing Factor Option as well as the Pricing Factor Amount on the QLI. The Pricing Factor Amount field on the QLI can then be used in the calculation of the total_amount when the quantity changes.
I am needing to know how to update the total_amount field on the QLI to incorporate this pricing method/structure.
CURRENT FORMULA IN PLACE:
QLI >> Line Item Total (total_amount)
Look at calculated formula -->
ifElse(and(isNumeric(toString($quantity)), isNumeric(toString($discount_price))),
currencySubtract(
ifElse(isNumeric($subtotal), $subtotal, multiply($discount_price, $quantity)),
ifElse(equal($discount_select, "1"),
currencyMultiply(ifElse(isNumeric($subtotal), $subtotal, multiply($discount_price, $quantity)), currencyDivide($discount_amount, 100)),
ifElse(greaterThan($quantity, 0), ifElse(isNumeric(toString($discount_amount)),
ifElse(greaterThan(0, $discount_price), negate($discount_amount), $discount_amount), 0),
ifElse(isNumeric(toString($discount_amount)), negate($discount_amount), 0))
)
),
""
)