The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Adding field to opportunity_product
Posted: 28 Aug 08 5:22 PM
|
I have added a column to productprogram table that will hold a value that will be used for a calculation in the opportunity_product table. I am running into an issue when I try to copy the value from the productprogram table over to the opportunity_product table. I don't need the value to display anywhere for the end users to see (with the exception of the manage products view, which I already have working). Has anyone been able to do this, if so could you point me in the right direction.
I have looked at this posting http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=98 which seems to be along a similar direction but dosen't seem to get me where I need to be. |
|
|
| |
|
Re: Adding field to opportunity_product
Posted: 04 Sep 08 3:25 PM
|
| What database field is this new ProductProgram field being stored to in Opportunity_Product.....or do you simply need it in the recordset for your calculation? |
|
|
|
Re: Adding field to opportunity_product
Posted: 04 Sep 08 3:41 PM
|
| I need it in the record set to perform the calculation; but I also need to have the calculation field update if the record changes (i.e. Selecting a different price level, updating the discount %). I believe that Kris's suggestion will work, I just have not had a chance to fully implement it as of yet. |
|
|
|