6/26/2025 2:29:12 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
Filter Opportunity Products by Price Level
Posted: 22 Jun 06 4:56 AM
|
how to buy abortion pill buy abortion pill over the counter open fiogf49gjkf0d Greetings one and all,
I am looking for some help. When creating an opportunity and adding individual product lines (Add Opportunity Product form), you can filter the products by various different options e.g. name, description, sku etc.
I would like to be able to filter the products by Price Level i.e. wholesale or retail (or any other pricing level I have set up). Can anyone show me how to do this?
Thanks,
Darren |
|
|
|
Re: Filter Opportunity Products by Price Level
Posted: 29 Jun 06 12:55 PM
|
fiogf49gjkf0d It should be doable, with some tweaking of the code. It will requre some experimentation on your part, but I think I can point you in the right direction:
There are a couple areas in the code of the Add Opportunity Product view, which will need to be modified:
ShowResults
Basically launches the "DisplayProductsByFilter" function (below).
This method probably wouldn't need to be modified.
CheckForFilters
Method which builds the where clause.
This method looks for the checkboxes on the form, and includes the appropreate section when the checkboxes are true. To follow this model, you would have to add a checkbox for the user to "enable" that aspect of the filter, as well as a control to contain and pass the value to filter by. You would have to make sure to use the proper table alias (from the modified DisplayProductByFilter function), when referring to the Program field (which holds the pricing level values)
DisplayProductsByFilter(strWhere)
Runs a SQL Query (with the Where of the clause as a parameter) and populates the tree on the products form.
The filtering functionality does not normally consider product pricing information. You would have to include a join to the productprogram table in SalesLogix so that you can be including that tables' Program field in the query.
|
|
Without actaully working through the code modifications myself, I think that you can accomplish what you are trying to do, just by modifying the Method and Function I listed, as well as some minor changes to the form itself. I hope this helps get you started, at least... |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|