where to find calculated fields

Hello,

I am a CRM newbie. I did a little SQL development a long long time ago in a
galaxy far far away. I am very rusty. I am trying to figure out how
calculated fields are handled so that I can copy the process.

I am looking at Customize Entities, Oppurtunity, Form and Views and the
Attributes. I am trying to figure out how the attribute Revenue
(isrevenuesystemcalculated) is calculated. I don't see anything on the forms
or the attributes. Is the value calculated in the SQL databas somewhere?

I would appreciate it if someone could point me in the right direction.

Dave
Fri Jun 29 14:51:28 CDT 2007

you have a few options - you can use javascript to do calculations in the
onchange event for any of the numeric fields involved in your calculation,
or you can use a Post Callout library to do those calcs in the background
when the users commits the form. Download the SDK from
microsoft.com/downloads for more info.

any direct sql changes will quickly wind you up in unsupported territory
with Microsoft.

Dave

"Michael P. Lindekugel" <MichaelPLindekugel@discussions.microsoft.com> wrote
in message news:52F1ED84-6FE1-4FD3-8E9B-F3E01A862FB3@microsoft.com...
> Hello,
>
> I am a CRM newbie. I did a little SQL development a long long time ago in
> a
> galaxy far far away. I am very rusty. I am trying to figure out how
> calculated fields are handled so that I can copy the process.
>
> I am looking at Customize Entities, Oppurtunity, Form and Views and the
> Attributes. I am trying to figure out how the attribute Revenue
> (isrevenuesystemcalculated) is calculated. I don't see anything on the
> forms
> or the attributes. Is the value calculated in the SQL databas somewhere?
>
> I would appreciate it if someone could point me in the right direction.

Sanjay
Fri Jun 29 19:23:39 CDT 2007

I agree. You better off following Client Side Scripting and hooking your
code onChange events on the fields in JScript.
Regards,
Sanjay

Dave Ireland wrote:
> you have a few options - you can use javascript to do calculations in the
> onchange event for any of the numeric fields involved in your calculation,
> or you can use a Post Callout library to do those calcs in the background
> when the users commits the form. Download the SDK from
> microsoft.com/downloads for more info.
>
> any direct sql changes will quickly wind you up in unsupported territory
> with Microsoft.
>
> Dave
>
> "Michael P. Lindekugel" <MichaelPLindekugel@discussions.microsoft.com> wrote
> in message news:52F1ED84-6FE1-4FD3-8E9B-F3E01A862FB3@microsoft.com...
>> Hello,
>>
>> I am a CRM newbie. I did a little SQL development a long long time ago in
>> a
>> galaxy far far away. I am very rusty. I am trying to figure out how
>> calculated fields are handled so that I can copy the process.
>>
>> I am looking at Customize Entities, Oppurtunity, Form and Views and the
>> Attributes. I am trying to figure out how the attribute Revenue
>> (isrevenuesystemcalculated) is calculated. I don't see anything on the
>> forms
>> or the attributes. Is the value calculated in the SQL databas somewhere?
>>
>> I would appreciate it if someone could point me in the right direction.
>
>