Friday, November 2, 2018

Item Search: Display Sum of the Member Items' cost of a Kit/Package

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