...
The use of VPB Variables provides a simple way to achieve consistent and fast bulk pricing updates, with maximum flexibility and minimal 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.
| 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 and formulas in the VPB should be calculated using figures inclusive of GST. The use of a GST variable is also an option. |
...
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
...