How to Setup for Discount Amount

Created by Cheng Kah Poh, Modified on Tue, 8 Sep, 2020 at 10:09 AM by Cheng Kah Poh

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



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article