How to Setup for Discount Amount

Set up for Discount Amount

NOTE: Please perform back up first before the setting below

Step 1- Customization Centre – Sales invoice Detail – Own Members – Add – Calculated

Step 2 - Update Caption : Discount 1 Amount

ID: Discount1Amount

Select Type as Decimal

Alias Express Operator:

Iif(EndsWith(Discount1, '%'), [Amount] * ToDecimal(Replace(Discount1, '%', '')) / 100 , ToDecimal(Discount1))

Step 3 -  Completed setting for Discount 1 Amount. Continue setting for Discount 2 Amount

Update Caption : Discount 2 Amount 

ID                           : Discount2Amount

Alias Express Operator:

Iif(EndsWith(Discount2, '%'), ([Amount] – [Discount1Amount]) * ToDecimal(Replace(Discount2, '%', '')) / 100 , ToDecimal(Discount2))

Step 4 - Continue setting for Discount 3 Amount

Update Caption : Discount 3 Amount 

ID                           : Discount3Amount

Alias Express Operator:

Iif(EndsWith(Discount3, '%'), ([Amount] - [Discount1Amount] - [Discount2Amount]) * ToDecimal(Replace(Discount3, '%', '')) / 100 , ToDecimal(Discount3))

Step 5 - Save All and Exit Customization Centre then Exit and login again the system

In Sales Invoice – Drag all the fields in the transaction screen – create an item and save it