Create a report that shows breakdown of landed cost for an item

Report that shows computation of the landed cost added to an item through Item Receipt Transaction will help to understand if breakdown of costs of inventory and a summary of landed costs. However, this report is currently not available and logged under Enhancement 138943: Inventory related Reports/Searches > Provide option to show landed cost fields as columns

However, a saved search can be customized to show total landed cost assigned an item receipt transactions. The steps are as follows:

- Navigate to Transactions > Management > Saved Searches > New > Transaction
- Under the Criteria subtab:
     - Filter : Type | Decription : is Item Receipt
     - Filter : Item Fields... > Track Landed Cost | Decription : is true
     - Filter : Main Line | Decription : is false
     - Filter : Shipping Line | Decription : is false
     - Filter : Tax Line | Decription : is false
     - Filter : Created From fields... > Type | Decription : is Purchase Order
- Under the Results subtab:
     - Field : Item Fields... > Name | Summary Type : Group
     - Field : Number | Summary Type : Group
     - Field : Quantity | Summary Type : Maximum | Summary Label : Quantity
     - Field : Applied to Transaction Fields... > Amount | Summary Type :Sum |Summary Label : Purchase Price
     - Field : Formula (Numeric) | Summary Type : Sum | Formula : case when {account} = '[ACCOUNT USED FOR LANDED COST such as FREIGHT/INSURANCE/DUTIES]' then {amount} else 0 end | Summary Label : Landed Cost
     - Field : Formula (Numeric) | Summary Type : Sum | Formula : {appliedtotransaction.amount} + (case when {account} = '[ACCOUNT USED FOR LANDED COST such as FREIGHT/INSURANCE/DUTIES]' then {amount} else 0 end) | Summary Label : Total Cost

Note: Replace [ACCOUNT USED FOR LANDED COST such as FREIGHT/INSURANCE/DUTIES] with Actual Account Name and retain the quotation marks.