Let me start with how you can develop without writing any script.
The very important is to create a hidden variable on the form so that end user should not understand the logic behind our development. Need to create a variable of type reference and bring the field "PRICE IMPLICATION" on the form and its a true/false field. Checked this field to true. And select the reference to location or vendor catalog item table.
A reference variable includes a Pricing implications field.
If this field is selected and there is a price, u_price, recurring_price, or u_recurring_price field on the referenced table, the value of that field is used to modify the cost of the item being ordered when a reference value is selected.
For example, suppose that computers in Phoenix cost $100 more than the ordering price, and computers in Boise cost $100 less than the ordering price.
- Set up a reference variable to the Location [cmn_location] table.
- Put a u_price field on the Location table.
- Set that field to 100 for the Phoenix location.
- Set that field to -100 for the Boise location.
When ordering a computer, if Phoenix is selected as the location for this variable, the ordering price is increased by $100. If Boise is selected, the ordering price is decreased by $100.
Thanks,
Amarjeet Pal
