Example:
|
Internal ID |
Price Level |
|
1 |
Base Price |
|
2 |
Online Price |
|
3 |
Retail Price |
To get the Internal ID of your price levels:
- Navigate to Setup> Accounting > Accounting Lists.
- Expand the Filters and set the Type to Price Level*
*If the Internal ID is not exposed on the page:
- Navigate to Home> Set Preferences.
- Under the General tab, mark the Show Internal IDs checkbox and hit Save.
To create the search, kindly follow the steps below:
- Navigate to Lists> Search > Saved Searches > New.
- Select Item as the Search Type.
- On the Results tab, click the Remove All button and add the following fields:
|
Field |
Summary Type |
Formula |
Summary Label |
|
Name |
Group |
|
|
|
Formula (Currency) |
Maximum |
CASE WHEN {pricing.pricelevel.id}=1 THEN {pricing.unitprice} END |
Base Price |
|
Formula (Currency) |
Maximum |
CASE WHEN {pricing.pricelevel.id}=2 THEN {pricing.unitprice} END |
Online Price |
|
Formula (Currency) |
Maximum |
CASE WHEN {pricing.pricelevel.id}=3 THEN {pricing.unitprice} END |
Retail Price |
- Rename the Search Title.
- Click Save & Run.