Disable automatic calculation of Detail amount (totallineitemamount) of Opportunities in Dynamics CRM

0
votes

I want to disable the automatic calculation of Detail amount in Opportunities in Dynamics CRM

enter image description here

I tried disabling all processes associated with Opportunity but it didn't work. I also checked the javascripts in the form, but none seem to alter its value on save

I also checked the field type and its not calculated

enter image description here

Below is a screenshot of entity details page

enter image description here

1
dynamics-crmcrmmicrosoft-dynamicsdynamics-crm-2013dynamics-crm-online
check if it is a calculated field – ASpirin
yeah I checked that, its a currency field and type is simple added this detail to question – Vignesh Subramanian
It can be also, plugin. In any case you can create your own field and hide this one. Copy calculated data on WF just to keep stuff consistent, nad WF as async job will be executed later than everything else, to be sure you can add a wait step to a WF – ASpirin
I thought there was a system setting to disable OOB calculations. – Daryl
Try to implement plugin which overrides value with PreInsideTransaction scope. It is possible, that value is calculated before, and that you'll be able to change it. – Krzysztof

1 Answers

1
votes

I checked and don't see any plugin that would enable us to turn off the automatic calculation. I'm familiar with the challenges these calculations can raise. I once had a client that had an invoice with over 20,000 lines. Invoice auto-calculation uses the same mechanism in the system as Opportunity calculation.

With the addition of each line, the total amount recalculated. It was like climbing a mountain that got steeper with each step. Our normal invoice automation was timing out. I eventually wrote a console app to add the invoice lines.

One option would be to create a custom Opportunity line entity and do the calculations yourself.