How to Display Landed Cost per Category Columns In Transaction Search

Needed Cost Categories are Freight, Import fees.

Perform the following to create Saved Search:

1. Navigate to Lists > Search > Saved Searches > New
2. Select Transaction
3. Under the Criteria tab > Standard subtab add the following fields:
   • Account Type – Other Current Asset
   • Type – Item Receipt 
   • Memo Description: does not contain Cost of Sales Adjustments
4. Under the Results tab > Columns subtab, add the following:
   • Add the Required fields to the saved search.
   • Formula(Currency) | Summary Type = Sum |  Formula = DECODE(NVL(SUBSTR({memo}, 0, INSTR({memo}, ‘:’)-1), ‘Cost’),’Freight’,{amount}) | Give Custom and Summary labels name
   • Formula(Currency) | Summary Type = Sum |  Formula = DECODE(NVL(SUBSTR({memo}, 0, INSTR({memo}, ‘:’)-1), ‘Cost’),’Import Fee’,{amount}) | Give Custom and Summary labels name
5. Click Save & Run

NOTE: Need to replace with required Cost Category (e.g. ‘Shipping’, ‘Duty’ etc.)