The purpose of this document is to demonstrate how to force a price per square foot override using a modifier.
Concept
Basic Discussion of Approach
Cautions
Warning or areas where the approach might not work as expected
Steps
- Create the modifier, name it SQFTOverride.
- Define your Question/Label something like “SqrFt Override:”
- Default entry option should be a numeric spinner.
- Go to PRODUCTS tab and add which ever product(s) you wish to add the modifier to.
- You may ignore other tabs, SAVE modifier.
WARNING: The next step will involve editing the systems default pricing plan. Carelessly editing the pricing formula can affect pricing in negative ways. If you have any questions, contact implementation services before proceeding.
- Go to whichever product you added the modifier to: Setup\System Setup\All Pricing Setup\Products
- For this example, we are using Roll Sign Print.
- Click on the products PRICING tab.
- Select EDIT.
- By default, the Formula will appear as this:
- Adding the code to use the modifier to override the square foot price, the code would look like this:
if MODIFIERVALUE(“SQFTOverride”) 0 then printedarea in unitarea * MODIFIERVALUE(“SQFTOverride”) else
IF ListPriceValue(PricingMethod) = 1 then
AreabasedPrice + AreaBasedMountingPrice + AreaBasedCuttingPrice + AreabasedLaminatePrice
+ AreabasedFinishingPrice
Else PartBasedPrice EndIf
endif
- As you can see, we have just added an IF statement before the original formula, and the ENDIF at the bottom. The rest of the formula remains unchanged.
This document is complete.
Source
Contributor: Peter, Cyrious Date: 12/01/2010 Version: Control 4.5