Hey there! I'm trying to add a new column (Products.ActualID) to the default Opportunity Products Editable Grid in SalesLogix 7.5.4.

Has anybody had any success with this? Any help would be greatly appreciated, I'm not sure what exactly I'm missing.

Thanks in advance!

Samantha Knigge

What issue are you running into?

Are you able to add the Field, but it remains Read Only?

Logically, I believe the ActualID should not be editable, since it is a Reference from the Product record associated with the OpportunityProduct row you are displaying.

Again, knowing how far you have gotten, or what kind of error or problem you are experience would help to be able to give you a hand.

Thanks so much for the quick response!

I'm looking at the properties for the editable grid (grdOppProducts). I assumed (incorrectly apparently) that I could just add a column to the Columns property. In the Columns property (QFDataGridCol Collection Editor), I see the other columns visible in that grid. There are two pulling from the products table: Product.Name and Product.Family both with the IsEditable property set to False. I added a new Editable Field with the same properties as the Product.Family field:

ColumnHeading: SKU; DataField: Product.ActualID; IsSortable: False; IsEditable: False.

When viewing this change in the web client, that column is there, but it's blank.

I'm sure I'm missing what's very obvious, I'm pretty new to the web client, but I can't find anything on this.

Any suggestions?

Thanks so much!

I just wanted to let you know I finally figured it out. Instead of setting the Data Field property for the column to Product.ActualId, I set it to opportunityProduct.ActualId and it shows up the way it's supposed to. Thanks again for your help on this, it is greatly appreciated!