| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Description
VPB Formulas are a feature of the Framework ECM VPB module which allows both VPB item cost and retail prices to be defined by simple arithmetic formulas, across VPB versions.
...
| Tip |
|---|
All VPB items should have retail price formulas that refer to the item cost and the variable to create the sell price. All VPB items and formulas should be calculated using figures inclusiveof GST (use of a GST variable is also an option). |
VPB Version Variables
Multiple VPB variables are recommended where different default margins are desired for different VPB sections eg: for base houses, appliances, structural upgrades, etc. The use of multiple VPB variables will allow you to update appliances without having to update base houses or structural upgrade item formulas (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 |
To add a VPB Item-area variable
Double-clicking a VPB variable pops up the Variable dialog, where the name, reference, value and notes for a variable can be updated.
...
Modifying the Value field and clicking OK/Apply will apply the change to all VPB item formulas using the updated variable, automatically updating all affected item prices.
VPB Item Formula fields
...
VPB Item formulas are accessible on the VPB item dialog within the Framework ECM VPB module.
...
Clicking the Select VPB Variable button on the item dlg toolbar pops up a list of variables to select for insertion into the currently selected formula:
...
| 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
...
If the formula couldn't be validated arithmetically, the following message is displayed and the formula is not applied to the item's pricing:
...
The price formulas are also validated and subsequently applied when the dialog's OK and Apply buttons are clicked.
...