Search for Custom Duties applied in Item Receipt.

Requirement:

User need a report that shows computation of the custom duties added to an item through Item Receipt Transaction to help better understand the breakdown of costs of inventory and a summary of landed costs. 

Solution

A saved search can be customized to show total landed cost assigned to an item receipt transactions.

1. Navigate to Transactions > Management > Saved Searches > New 
2. Click Transaction
3. Click Criteria 
4. Click Standard
5. Filter:
   • Select Type 
     • Select Item Receipt
   • Select Item Fields…
     • Select Track Landed Cost
     • Select Yes
   • Select Main Line 
     • Select No
   • Select Shipping Line 
     • Select No
   • Select Tax Line 
     • Select No
   • Select Created From fields… 
     • Select Type 
     • Select Purchase Order

1. Click Criteria
2. Click Columns
3. Field:
   • Select Item Fields…
     • Select Name
     • Summary Type : Select Group
   • Select Number 
     • Summary Type: Select Group
   • Select Quantity 
     • Summary Type: Select Maximum
     • Summary Label: Enter Quantity
   • Select Applied to Transaction Fields… 
     • Select Amount 
     • Summary Type: Select Sum 
     • Summary Label: Enter Purchase Price
   • Select Formula (Numeric)
     • Summary Type: Select Sum
     • Formula: Enter ABS(CASE WHEN {‌account} = ‘[ACCOUNT USED FOR Custom Duties ]’ THEN {‌amount} ELSE 0 END (Account can be seen in the GL impact of the Item receipt)
     • Summary Label: Enter Landed Cost

Result