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
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,
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,
Did any of the responses help? If not, any questions? If so, could you please mark an answer as verified?
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;
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (