Disable automatic calculation of Detail amount (totallineitemamount) of Opportunities in Dynamics CRM
I want to disable the automatic calculation of Detail amount in Opportunities in Dynamics CRM
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
Below is a screenshot of entity details page
dynamics-crm crm microsoft-dynamics dynamics-crm-2013 dynamics-crm-online
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
|
show 1 more comment
I want to disable the automatic calculation of Detail amount in Opportunities in Dynamics CRM
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
Below is a screenshot of entity details page
dynamics-crm crm microsoft-dynamics dynamics-crm-2013 dynamics-crm-online
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
1
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
Nov 23 '18 at 11:52
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
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
Nov 25 '18 at 6:08
|
show 1 more comment
I want to disable the automatic calculation of Detail amount in Opportunities in Dynamics CRM
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
Below is a screenshot of entity details page
dynamics-crm crm microsoft-dynamics dynamics-crm-2013 dynamics-crm-online
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
I want to disable the automatic calculation of Detail amount in Opportunities in Dynamics CRM
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
Below is a screenshot of entity details page
dynamics-crm crm microsoft-dynamics dynamics-crm-2013 dynamics-crm-online
dynamics-crm crm microsoft-dynamics dynamics-crm-2013 dynamics-crm-online
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
edited Nov 23 '18 at 16:47
Vignesh Subramanian
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
asked Nov 23 '18 at 11:20
Vignesh SubramanianVignesh Subramanian
3,824641109
3,824641109
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
1
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
Nov 23 '18 at 11:52
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
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
Nov 25 '18 at 6:08
|
show 1 more comment
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
1
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
Nov 23 '18 at 11:52
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
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
Nov 25 '18 at 6:08
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
1
1
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
Nov 23 '18 at 11:52
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
Nov 23 '18 at 11:52
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
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
Nov 25 '18 at 6:08
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
Nov 25 '18 at 6:08
|
show 1 more comment
1 Answer
1
active
oldest
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.
answered Nov 24 '18 at 12:51
AronAron
2,37031019
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
add a comment |
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53445753%2fdisable-automatic-calculation-of-detail-amount-totallineitemamount-of-opportun%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
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.
answered Nov 24 '18 at 12:51
AronAron
2,37031019
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
add a comment |
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.
answered Nov 24 '18 at 12:51
AronAron
2,37031019
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
add a comment |
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.
answered Nov 24 '18 at 12:51
AronAron
2,37031019
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.
answered Nov 24 '18 at 12:51
AronAron
2,37031019
edited Nov 24 '18 at 13:42
answered Nov 24 '18 at 12:51
AronAron
2,37031019
answered Nov 24 '18 at 12:51
AronAron
2,37031019
answered Nov 24 '18 at 12:51
AronAron
2,37031019
2,37031019
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
add a comment |
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
If we create a new opportunity line entity, would that reflect in the Quotes as well?
– Vignesh Subramanian
Nov 24 '18 at 14:01
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
You could create an N:1 relationship from that entity to the Quote entity too. Of course you will be losing all the OOB functionality on Opp and Quote lines, so proceed with caution. I would consider this to be a "last resort" type of idea. It would be better to continue to use the OOB line entities if you can figure out a way to make them work. Why do you want to disable the automatic calculation?
– Aron
Nov 24 '18 at 15:22
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
I want to calculate the total based on resource bookings
– Vignesh Subramanian
Nov 24 '18 at 15:53
1
1
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
Then you might want to create a separate total field, like "Total Bookings", add an Opportunity lookup on the resources bookings entity (if that's possible), and then use OOB rollups or a custom rollup plugin to calculate.
– Aron
Nov 24 '18 at 16:09
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53445753%2fdisable-automatic-calculation-of-detail-amount-totallineitemamount-of-opportun%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
check if it is a calculated field
– ASpirin
Nov 23 '18 at 11:29
yeah I checked that, its a currency field and type is simple added this detail to question
– Vignesh Subramanian
Nov 23 '18 at 11:30
1
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
Nov 23 '18 at 11:52
I thought there was a system setting to disable OOB calculations.
– Daryl
Nov 24 '18 at 17:12
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
Nov 25 '18 at 6:08