...
The formulas may contain hard-coded values and/or variables which can be updated independently of the VPB items which use them.
Incorporating VPB variables into an item's pricing formula enables the item's pricing to be updated by simply updating the value in these variable(s) at the version level.
The use of VPB Variables provides a simple way to achieve consistent and fast bulk pricing updates, with maximum flexibility and minimal mass editing over time. Establishing VPB Variables should be established is recommended for margins (or perhaps components of a margin), these can then be adjusted on demand as needed. Incorporating VPB variables into an item's pricing formula enables the item pricing to be updated by simply updating the value in these variable(s) at the version level.
| Tip |
|---|
All VPB items should have retail price |
...
formulas that |
...
refer to |
...
the item cost |
...
and the variable to create |
...
the sell price. |
...
| Tip |
|---|
All prices VPB items and formulas in the VPB should be calculated using figures inclusive of GST . The (use of a GST variable is also an option). |
VPB Version Variables
Multiple VPB variables are recommended where different default margins are desired in for different section of the VPB sections eg: for base houses, appliances, structural upgrades, etc. The The use of multiple VPB variables will allow you to update appliances without having to update base houses or structural upgrade item formulas as an (example).
VPB Variables are accessible on the VPB Version dialog within the Framework ECM VPB Module (Versions screen - Variable Tab):
| Tip |
|---|
There are 2 system default VPB variables available in every VPB version. These include [Item_cost_price] and [Item_quantity], in yellow above. These variables cannot be edited or deleted. When used in a formula for an item price, they represent the item's cost price and quantity, as entered on the VPB item dialog's General tab |
...
Click OK to add the selected variable to current place in the currently selected formula:
VPB Formula Rounding Function
Rounding Up
Syntax:
Rounding up to 50 cents: roundup .5
...