Scenario
User wants to create list of Item Receipts with no Landed Cost applied. This can help them easily identify which Item Receipts need to be adjusted.
Solution
To do this, you can try and follow the steps documented in SuiteAnswers 12611.
If the search there did not work for you, here is another Transaction Saved Search you can try:
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!