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