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