In cases where users are looking for a report that will give them a comparison or evaluate the difference between how much they are charging for shipping and how much they are paying to ship, they can create a Saved Search that can help them track these Amounts.
Here are the steps to create the Saved Search:
1. Navigate to Lists > Transactions > Search > Saved Searches > New
2. Select Transaction as Search Type
3. Under Criteria Tab > Standard subtab, add the following fields:
- Type = Sales Order
- Status = Sales Order: Billed
- Tax Line = false
- Shipping Line = false
- Main Line = false
4. Under Criteria Tab > Summary subtab, add this field:
Summary Type | Field | Description | Formula
- Maximum | Formula (Numeric) | is 1 | CASE WHEN {item} = 'Shipping' THEN 1 ELSE 0 END
5. Under Results tab > Columns subtab, add the following fields: Field | Summary Type | Formula | Custom Label
- Document Number | Group
- PO/Check Number | Group
- Formula (Text) | Maximum | CASE WHEN {item} = 'Shipping' THEN {item} END | Shipping
- Formula (Numeric) | Maximum | CASE WHEN {item} = 'Shipping' THEN {amount} END | Shipping Charged
- Applying Transaction : Cost of Shipping Charge (Custom Body) | Maximum | Shipping Cost
6. Rename the Saved Search.
7. Click Save & Run.
I hope this helps!
Share your insights about this in the comments below! 😊