Problem/Business Requirement/Unique Question:
Transactions > Management > Saved Searches > New > Item Search > Display Sum of the Member Items' cost in a Kit/Package
Symptoms/Details of Business Requirements/Any Additional Information:
This item search will help customers to know approximately how much is the cost of a kit/package. This will help them analyze how much their sales price would be for the kit/package item.
Solution/Workaround/Gotcha/Recommendation:
To create the item saved search, do the following steps:
1. Go to Lists > Search > Saved Searches > New > Item
2. In the Criteria tab, add Type = Kit/Package
3. In the Results tab, add the following:
Name
Member Item
Member Item (fields) = Average Cost
Formula Numeric = {memberitem.averagecost}*{memberquantity}
4. To show a particular kit, add Name in Available Filters and mark Show in Filter Region.
5. Also, in the Results tab, check on Show Totals, so that when a particular kit is entered, it will show the total cost for the kit at the bottom of the page
6. Give the item search a different name and click on Save and Run
No comments:
Post a Comment