Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
WATCH: Saved Search to Show Landed Costs Associated to Item Receipts
This video is on how to create a saved search that shows the landed costs associated to item receipts.
Here's the formula used in the search:
WITH BREAKDOWN PER LANDED COST CATEGORY
- Amount per Landed Cost Category = CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END
- Note: Replace XXXX with the name of the Landed Cost Category on your account. Add as many columns/formula as necessary.
- Total Landed Costs = MAX(CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END)+MAX(CASE WHEN ({memo} LIKE '%YYYY%') THEN {amount} else 0 END)
- Note: Add all the formula of all the Landed Cost Categories
🌟Q2 2026 Community Choice Nominations: Recognize a member who made a difference in our community!
🏆️ Earn Community badges for Refer a Member | Answer Accepter | Content Creator
_______________________________________________________________________________
Michelle Jabanes | NetSuite Support Community Administrator
Tagged:
2