This server behavior is used to setup an extra order amount. I add 3 extra amount to give you the possibility to add some others amount on the cart after the standard discount and shipping amount. You can use this value to add and extra shipping cost, for example if you have a fix value and a variable value or if you have a packing cost, or some other taxes or amount to add.
There are 3 of this extra amount: "Other Taxes 1" - "Other Taxes 2" - "Other Taxes 3" To give you the max flexibility you must create the recordset with the standard Dreamweaver recordset behavior so you can define the recordset filter like you need, besed on the user account or other methods.
To search the Other Taxes my asp code scan all the records in the recordset and get the value from the record where the value of the "Calculate on" is between the value of the "From Field" and the value of the "To Field" and use the filter method like you setup in the filter combo box so you can setup if use the formula:
"Calculate on" > "From Field" and "Calculate on" <= "To Field"
or the formula
"Calculate on" >= "From Field" and "Calculate on" < "To Field"
after my code find the right record get the value of the "Value Field" and calculate the Other Taxes in percentage or in absolute value like you select in the "Value Type".
The recordset name where get the Other Taxes setup
The recordset field where find the From Value used to detect the right record where get the Other Taxes value
The recordset field where find the To Value used to detect the right record where get the Other Taxes value
The filter method used to compare the "Calculate On" with the "From Field" and "To Field" values
The recordset field where find the Other Taxes value
You can select if the value find in the recordset is a percentage or an absolute value
The column cart sum used to calculate the Other Taxes
If checked the VAT is calculated also on the Other Taxes cost
The number of decimal you need have for the VAT amount
You can choose if this extra amount is a positive or negative amount, so you can use this to add an extra discount (sign=negative) or an extra amount (sign=positive)