Recurring rolled-up fields

These feature gives user ability to use rolled-up fields (rolled-up recurring list price, rolled-up recurring extended list price, rolled-up recurring net price, rolled-up recurring extended amount, rolled-up recurring cost, rolled-up recurring extended amount, rolled-up recurring gross margin, rolled-up recurring discount amount, rolled-up recurring discount percent, rolled-up recurring net difference from base item, rolled-up recurring end customer unit price and rolled-up recurring end customer extended price). Rolled up fields for main item are calculated as summary of all items’ field amount belonging to same configuration (for example, rolled up list price is a summary of all items' list prices).

Recurring rolled-up fields can be displayed in generated document and sent to CRM. These fields are calculated only if application flag is set that recurring prices are used in the system.

For each of these fields, new CTX tag are developed on the CurrentItem tag. Tag name is same as for non-recurring fields, with prefix MRC added (example - <*CTX( Quote.CurrentItem.MRCRolledUpDiscountAmount.DefaultDecimal )*>

Editing rolled-up recurring net price

When user edit rolled-up recurring net price recurring discount is recalculated for all (main and line) items.

Example:
Product total price is 1200 and product cost is 720. Recurring discount percent is 10%.
User edit rolled-up recurring net price and enters 900.
Recurring discount is calculated for all line items to 25%.
Rolled-up recurring GM is calculated to 20%.

Editing rolled-up recurring extended amount

When user edit rolled-up recurring net extended amount recurring discount is recalculated for all (main and line) items.

Example:
Product total price is 1200 and product cost is 720. Recurring discount percent is 10%.
User edit rolled-up recurring extended amount and enters 1000.
Recurring discount is calculated for all line items to 16.67%.
Rolled-up recurring GM is calculated to 28%.

Editing rolled-up recurring gross margin

When user edit rolled-up recurring gross margin recurring discount is recalculated for all (main and line) items.

Example:
Product total price is 1200 and product cost is 720.
Recurring rolled-up extended amount is 1080. Recurring discount percent is 10%.
User edit rolled-up recurring gross margin and enters 25.
Rolled-up recurring extended amount is calculated to 960.

Editing rolled-up recurring discount percent

When user edit rolled-up recurring discount percent recurring discount is recalculated for all (main and line) items.

Example:
Product total price is 1200 and product cost is 720.
Recurring rolled-up extended amount is 1080. Rolled-up recurring discount percent is 10.
User edit rolled-up recurring discount percent and enters 25.
Rolled-up recurring extended amount is calculated to 900.

Editing rolled-up recurring discount amount

When user edit rolled-up recurring discount amount recurring discount is recalculated for all (main and line) items.

Example:
Product total price is 1200 and product cost is 720.
Recurring rolled-up discount amount is 120. Recurring discount is 10. Rolled-up recurring extended amount is 1080.
User edit rolled-up recurring discount amount and enters 100.
Recurring discount is calculated to 8.33. Rolled-up recurring extended amount is calculated to 1100.

Editing rolled-up recurring net price (relative)

When user edit rolled-up recurring net price relative recurring discount is recalculated for all (main and line) items according to their max and min discount percents.

Example:
Product total price is 1200 and product cost is 720. Recurring discount is 10%.
Max discount percent for main and line items is 40% and min discount percent for main and line items is 5%.
User edit rolled-up recurring net price and enters 1000.
Recurring discount for main and line items is calculated to 16.67%.

Editing rolled-up recurring extended amount (relative)

When user edit rolled-up recurring extended amount relative recurring discount is recalculated for all (main and line) items according to their max and min discount percents.

Example:
Product total price is 1200 and product cost is 720.
Recurring discount percent is 10% for main and line items.
Max discount percent for main and line items is 40% and min discount percent for main and line items is 5%.
User edit rolled-up recurring net price and enters 1000.
Recurring discount for main and line items is calculated to 16.67%.

Editing rolled-up recurring gross margin (relative)

When user edit rolled-up recurring gross margin relative recurring discount is recalculated for all (main and line) items according to their max and min discount percents.

Example:
Product total price is 1200 and product cost is 720.
Recurring discount percent is 10% for main and line items.
Max discount percent is 40% and min discount percent is 5% for main item.
Max discount percent is 20% and min discount percent is 5% for line item.
Rolled-up recurring gross margin is 33.33.
User edit rolled-up recurring gross margin and enters 25.
Recurring discount for main item is calculated to 26%. Recurring discount for line item is calculated to 14%.
Rolled-up recurring extended amount is calculated to 960.

Editing recurring rolled-up discount percent (relative)

When user edit rolled-up recurring discount percent relative recurring discount is recalculated for all (main and line) items according to their max and min discount percents.

Example:
Product total price is 1200 and product cost is 720.
Recurring discount percent is 10%.
Max discount percent is 40% and min discount percent is 5% for main item.
Max discount percent is 20% and min discount percent is 5% for line item.
User edit rolled-up recurring discount amount and enters 17%.
Recurring discount for main item is calculated to 21.8%. Recurring discount for line item is calculated to 12.2%.
Rolled-up recurring extended amount is calculated to 996.

Editing recurring rolled-up discount amount (relative)

When user edit rolled-up recurring discount amount relative recurring discount is recalculated for all (main and line) items according to their max and min discount percents.

Example:
Product total price is 1200 and product cost is 720.
Recurring discount percent is 10%.
Max discount percent is 40% and min discount percent is 5% for main item.
Max discount percent is 20% and min discount percent is 5% for line item.
Rolled-up recurring discount amount is 120.
User edit rolled-up recurring discount amount and enters 100.
Recurring discount for main item is calculated to 15.5%. Recurring discount for line item is calculated to 9.5%.
Rolled-up recurring extended amount is calculated to 1050.

You are here: CallidusCloud SAP CPQ Online HelpAdmin Page HelpPricing/CalculationsCart Fields AdministrationRecurring rolled-up fields