Discussions
Don't miss out on the opportunity to boost sales and customer satisfaction. Elevate your business with NetSuite's Intelligent Recommendations.
NSC | Saved Search for Item Receipts without Landed Cost
Scenario
User needs to create a list of Item Receipts without Landed Cost applied to the transaction.
Solution
Create a Transaction Saved Search with the following details:
- Criteria > Standard tab:
- Criteria > Summary tab:
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.
- Results tab:
Note: Add fields/columns as necessary. Atleast 1 column should have the Summary Type = Group since we are using Summary Criteria.
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!