Javascript to sum Qty field

(0) Share

Report

Posted on by Community Member

Hello all, is there a way to sum values using javascript?

There is a custom Batch Number which can have products. The same product can be in different Batch, but the code below is only getting the latest Qty value, I need to sum them.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

JohnAnonymous 5,241 on at

Like (0)

Report

I don't understand your question completely, but it should be the following process:

1. Create a variable to store your Qty

2. Create a query that returns all applicable product / batch combinations

3. Iterate over the collection results and add the Qty from on record to the variable created under 1.

Was this reply helpful? Yes No
Verified answer

Alagunellaikumar 6,212 on at

Like (0)

Report

Create a Qty in the global variable

Create a query for product entity filter by product number.

Iterate the collection of return value from the above the query

Qty += result.quantity;

Was this reply helpful? Yes No
JohnAnonymous 5,241 on at

Like (0)

Report

Did any of the responses help? If not, any questions? If so, could you please mark an answer as verified?

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 4 on at

Like (1)

Report

Hi Tekwise,

I would suggest using a rollup field for what you are trying to accomplish here if you have a 1-N relationship between the Product and the Batch. You should be able to do this in CRM without any custom code.

Hope this helps.

Thanks,

Was this reply helpful? Yes No
Verified answer

Jharana Baliyar Singh 2,667 on at

Like (1)

Report

Hi Tekwise,

You can use Rollup fields for ur requirements.

Plz have a look around below link:

www.softwareanswers.co.uk/.../aggregate-calculations-in-microsoft-dynamics-crm-2015.html

Thanks,

Was this reply helpful? Yes No