Hello,
Can you please help me in creating custom script for mathematical calculations.
Scenario: I have created a template as per customers requirement. There are fields like “consumption in metres”, “fabric price usd per metre”, “total fabric cost”.
So when I enter the values in above fields, it should calculate and display the value in the total fabric cost.
Also, there is another field called “Other cost” and “cost”. So when i enter the values in above field it should calculate sum of total fabric cost + Cost and display the value in Total1.
Total fabric cost=(based on “consumption in metres”, and “fabric price usd per metre”)
Total1= (Total fabric cost + Cost)
Can you please share me the sample custom script for this scenario, as I dont have any idea of Codings. Please help.
I want to add script to already created script for costing template.
I want to know how to write script for the below calculations.
Total 2 = Sum of all the fields of (Sewing+Labels+Trim/Accessories)
Total 3 = Sum of all the fields of (Embillishments+Packaging+Other Cost)
CMT = SMV Multiplied by RATE
TOTAL= (Total 1 + Total 2 + Total 3) + CMT
FINANCE 6 PERCENTAGE = 6% of TOTAL
FOB USA = TOTAL + FINANCE 6 PERCENTAGE
I have attached the screenshots of Costing template page and also the doctype created for tables.
I want to add script to already created script for costing template.
I want to know how to write script for the below calculations.
Total 2 = Sum of all the fields of (Sewing+Labels+Trim/Accessories)
Total 3 = Sum of all the fields of (Embillishments+Packaging+Other Cost)
CMT = SMV Multiplied by RATE
TOTAL= (Total 1 + Total 2 + Total 3) + CMT
FINANCE 6 PERCENTAGE = 6% of TOTAL
FOB USA = TOTAL + FINANCE 6 PERCENTAGE
I have attached the screenshots of Costing template page and also the doctype created for tables.