Custom script queries

Sujay · August 21, 2018, 6:27am

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.

Thanks & Regards,
Sujay

bhavikpatel7023 · August 21, 2018, 6:59am

@Sujay

You can refer this:

Sujay · August 21, 2018, 8:11am

Hello,

I am not able to understand.

Can anyone help me on my scenario with custom script.

Sujay · August 21, 2018, 9:42am

Hello,

Can you write a script for me for my scenario, because I am not able to
understand it.

Also, I have Many fields created in that costing Template.

So, if you create it for me for only 1 section as specified in the
screenshot, then I can refer to it and create the other ones on my own.

If I enter the values of consumptions in meters and fabric price, it
should calculate and display in total fabric cost.

Also, it should calculate the total fabric cost and cost and display in
the Total 1.

bhavikpatel7023 · August 21, 2018, 1:10pm

Show your custom script.

Sujay · August 22, 2018, 4:07am

Hello,

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.

Please help.

Thanks and Regards,
Sujay

Sujay · August 22, 2018, 6:07am

Hello,

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.

Please help.

Thanks and Regards,
Sujay