How to Create Deposit Calculator in Transaction template

Created by Cheng Kah Poh, Modified on Wed, 28 Feb 2024 at 10:19 AM by Cheng Kah Poh

Scenario:

How to make it auto calculate deposit 40% ?


Solution:

Step 1 - in report Designer > Press Field > at "SalesInvoiceVoucher1" > Press Add Calculated Field.


Step 2 - Once Press Add Calculated Field , System will add 1 new field under "SalesInvoiceVoucher1" .



Step 3 - Then Press Edit, Report Designer will Drop down Edit Info.


Step 4 - Put a new Name, Example : DepositCalculator, then Press Expression 3dot button.


Note: i will take Due Amount field to count.


Step 5 - After Press Expression, System will pop out this box, after fill in expression then press OK.


Note, User can copy expression from here : [DueAmount]*40/100


Step 6 - After Press OK, then User can drag the new added Field to desired column.

Before 


After


Then Press Menu > Press Save.



After Save, we can now Preview the Result



** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software


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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article