Our company works mostly off of a net revenue number for opportunties. While the gross number is important I need to capture the actual close value in net terms. Currently the form opens and the Actual Amount is populated with the Salespotential.

I have been trying to find where this is coming from.. does anyone have an idea of where I can look to find how this is being populated, so I can change it to represent the new number.

I tried to add code to the Onload event changing the text property to 0 which worked fine however if it was saved it reverted to the salespotential.

Thanks

If you look at the opportuunity object itself and specifically the properties you will see some are code properties.

This is one way that it can be done, but it isn't a stored DB field, just an entity field (sdata can see it not the db).

Another option is to add a new field in the db and then add On?????? events to calculate the value as needed.

You mean like the SLX business rule? Add your own business rule after their's during the on open of the Close Opportunity form and populate whatever number you want.....we often have to distribute cash flow numbers over months for a deal....just because you make a $100,000 sale in June doesn't meant that the number is 100% of that value in July.....

THanks everyone, we already had field in database and calculations were made to get netrevenue numbers, the issue was SLX was populating the ActualClose Amount with the Salespotential number amd there was no code in the OnLoad function of the form.

I added code to change the text property of the control and then set the entity property to the value I needed, was easy enough solution the hard part was trying to ensure that while I added this code somehow my vlaues would be overwritten because Sage was working with that default value but it doesn't appear that way.

Thanks for the help