I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client. I client had requested additional columns in the “Add” Lookup dialog. I had added the Price column as a field in the Lookup Columns collection. I could see that the constructed OpportunityProducts.js file contained my Price column markup when it was deployed. However, the column was not displaying in the Lookup result set. The Lookup by Field drop down did have my field, and I was able to filter by my field, I just could not see the column in the results grid.
It turns out the constructor that generates the OpportunityProduct.js file adds a style attribute to numeric column data types. You can see the markup it generates here:
name: OpportunityProductslueProduct_Strings[‘lueProduct_LookupProperties_Price_PropertyHeader’] || ‘Price’,
field: ‘Price’,
propertyType: ‘System.Decimal’,
styles: ‘text-align: right’,
excludeFromFilters: false,
width: 9,
formatter: function (value, rowIdx, grid) {
return Sage.Utility.SDataLookup.childObjectFormatter({
value: value, rowIdx: rowIdx, grid: grid,
fieldName: ‘Price’,
includeButton: false,
childentity: ‘PackageKitChildViews’
});
},
sortable: true
It turns out that that style attribute is what was preventing the column from displaying. Changing the deployed js file to this code, allowed the field to show:
name: OpportunityProductslueProduct_Strings[‘lueProduct_LookupProperties_Price_PropertyHeader’] || ‘Price’,
field: ‘Price’,
propertyType: ‘System.Decimal’,
//styles: ‘text-align: right’,
excludeFromFilters: false,
width: 9,
formatter: function (value, rowIdx, grid) {
return Sage.Utility.SDataLookup.childObjectFormatter({
value: value, rowIdx: rowIdx, grid: grid,
fieldName: ‘Price’,
includeButton: false,
childentity: ‘PackageKitChildViews’
});
},
sortable: true
Unfortunately this is not a very feasible solution as it requires modifying the deployed js file after each deployment. I will be contacting Saleslogix support to report this as a bug to hopefully allow these types of fields to show.
