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!
|
|
Recording history on a datagrid
Posted: 27 Jan 10 4:49 AM
|
Can anyone explain why the 'record changes' check box on a datagrid (in my case Opportunity Products) doesnt record any changes made to the values in it.
Also, can anyone recommend an alternative to record any chnages made to a product here.
Thanks all  |
|
|
|
Re: Recording history on a datagrid
Posted: 28 Jan 10 3:17 AM
|
| Yep, RecordChanges only works on 1:1 tables and products/grids are typically 1:M and, therefore, won't work. You'll have to trap that yourself and write the old values/new values prior after the change is committed. |
|
|
|
Re: Recording history on a datagrid
Posted: 28 Jan 10 3:27 AM
|
Thanks for your reply i have managed to get this working now (sort of). I have created a new form with text boxes that are populated with the product details the user has chosen to edit. I only want to cature changes made to Quantity and Adj. Price so all other boxes are read only.
When a user changes the quantity value the changes get recorded (the box is linked to OPPORTUNITY_PRODUCT:QUANTITY), a record is inserted into the history table, the change can be viewed in the notes history tab, and most importantly the datagrid updates with the quantity value for that product.
Unfortunately this is not working for Adj. Price. I have the text box linked to OPPORTUNITY_PRODUCT:CALCPRICE, the database updates with the change,a record is inserted into the history table, the change can be viewed in the notes history tab, but the datagrid does not update and still shows the old value.
Any idea why? When i look at the PopulateDataGrid sub in the Opportunity:Products plugin the Adj.Price does come from the CALCPRICE field. |
|
|
| |
| |
| |
|