Difference between revisions of "Form Revenue Header"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 23: | Line 23: | ||
* The system then will add the '''Price''' and the '''VAT''' to store the value in the '''Total''' | * The system then will add the '''Price''' and the '''VAT''' to store the value in the '''Total''' | ||
* Whatever value is in the '''Cost''' field is then subtracted from the '''Price''' to give the '''Net Margin''' | * Whatever value is in the '''Cost''' field is then subtracted from the '''Price''' to give the '''Net Margin''' | ||
| − | * Whatever | + | * Whatever value is in the '''Cost''' field is also subtracted from the '''Total''' to give the '''Gross Margin''' |
| Line 33: | Line 33: | ||
The VAT Rate will always be stored with a % in it | The VAT Rate will always be stored with a % in it | ||
| + | |||
| + | |||
| + | = Control = | ||
| + | |||
| + | ''* For developers'' | ||
| + | |||
| + | All fields, TDs, TRs and tables are uniquely named to allow total control styling. | ||
| + | |||
| + | |||
| + | The calculation function is fn_Revenue_Recalc_X where X is the Id of the question added. | ||
| + | |||
| + | |||
| + | The system has been built to support multiple Revenue Headers on the same form with no conflict. | ||
[[Category:Module Specific:Form Management]] | [[Category:Module Specific:Form Management]] | ||
Revision as of 13:40, 27 September 2017
1 Overview
A Revenue Header is a complex question type which is used for allow the storage of margin on an amount to be easily recorded.
The fields are
2 Logic
The fields themselves are formatted as currency with , used to separate thousands.
Worked example:
- Where a Price is given 1000, the system will multiply the value in the VAT Rate percentage to calculate the VAT
- The system then will add the Price and the VAT to store the value in the Total
- Whatever value is in the Cost field is then subtracted from the Price to give the Net Margin
- Whatever value is in the Cost field is also subtracted from the Total to give the Gross Margin
The Currency fields are currently provided for reporting purposes, not calculation purposes.
All of the calculation fields are recalculated and reformatted on any attempted change.
The VAT Rate will always be stored with a % in it
3 Control
* For developers
All fields, TDs, TRs and tables are uniquely named to allow total control styling.
The calculation function is fn_Revenue_Recalc_X where X is the Id of the question added.
The system has been built to support multiple Revenue Headers on the same form with no conflict.
