x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 76 subscribers
  • Views 326 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
murni

Tax and Discount percentage in Quote item did not auto calculate

Posted By

Hi All,

I make the tax and discount percentage and value field available on display on Quote free text item, but it seems I can only enter value on the fields, and it did not auto calculate the tax or discount value. How do I set these value to be calculated automatically accordingly, by sequence? I.e to auto calculate the discount value by percentage, then calculate tax value by percentage?

Thank you

  • 0

    try this on insert record table level script on quote items 

    function InsertDiscVAT()
    {



    var sum=Values('quit_quotedpricetotal');
    var calcDiscamnt=(parseFloat(sum)*(parseFloat(discperc)/100));
    var taxperc=Values('quit_taxperc');
    var calcTaxamnt = (parseFloat(sum)*(1-(parseFloat(discperc)/100))*(parseFloat(taxperc)/100));


    Values('quit_discountamnt')=calcDiscamnt.toFixed(2);
    Values('quit_taxamnt')=calcTaxamnt.toFixed(2);

    }

*Community Hub is the new name for Sage City