Scenario
User needs to create a list of Item Receipts without Landed Cost applied to the transaction.
Solution
Create a Transaction Saved Search with the following details:
Formula Used: CASE WHEN {memo} LIKE '%LandedCost1%' OR {memo} LIKE '%LandedCost2%' OR {memo} LIKE '%LandedCost3%' OR {memo} LIKE '%LandedCost4' THEN 1 ELSE 0 END
Note: Replace "LandedCostX" with the name of the Landed Cost Categories in your account. Repeat the OR {memo} LIKE '%LandedCost4' clause in case you have more Landed Cost Categories.
Note: Add fields/columns as necessary. Atleast 1 column should have the Summary Type = Group since we are using Summary Criteria.
Alternatively, in the Criteria > Summary tab, you can use a formula that uses the Account used in the Landed Cost Categories:
Formula: CASE WHEN {account} IN ('6090 Freight & Delivery') THEN 1 ELSE 0 END
If you use more than 1 account in Landed Cost Categories, just add it in the list of values in the parenthesis. Example: ('6090 Freight & Delivery','6091 Landed Cost Account')
-----
If you find this information useful, let us know by reacting or commenting on this post!