Hi,
I am having trouble customizing Add Opportunity Product and Manage Product screens in SLX. I am making use of Product, C_Product_det table and Opportunity_product not using all other tables.
I am entirely using a different set of fields from SLX except for Productid and Name from product table. Rest of the items I join with C_Product_det table using producctid. I have unique set of associations with C_Product_det table with C_Product_detId.
My C_Product_det table look like this:
C_PRODUCT_DETID, CREATEUSER, CREATEDATE, MODIFYUSER, MODIFYDATE, PRODUCTID, DEPART_PORT, DURATION, ITINERARY, STATUS
While selecting Available list of products in Add Opportunity Product screen, I use C_PRODUCT_DETID as as a tag. Problem is, it is getting not getting added in Selected Products grid.
To be precise, in the following subroutine, the addnew feature of the grid doesnot seem to work.
Sub AddProductToGrid(objRS, intQty)
With grdProducts.Recordset
.AddNew
.Fields("C_PRODUCT_DETID").Value = "" & Application.BasicFunctions.GetIDFor("C_PRODUCT_DETID")
.Fields("PRODUCTID").Value = "" & objRS.Fields("PRODUCTID").Value 'DNL
Fields("PRODUCT").Value = objRS.Fields("NAME").Value 'DNL
End With
End Sub
Any help in this regard would be useful..
Thanks,
|