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.
NSC | SAID: 35633 > Landed Cost Formula Error
Scenario
User is using the Suite Answer Article: 35633 Create a Report That Shows Breakdown of Landed Cost for an Item but is getting an error following the Landed Cost formula provided in the article
Solution
Instead of using:
- Select Formula (Numeric)
- Summary Type: Select Sum
- Formula: Enter ABS(CASE WHEN {account} = '[ACCOUNT USED FOR LANDED COST such as FREIGHT/INSURANCE/DUTIES]' THEN {amount} ELSE 0 END
- Summary Label: Enter Landed Cost
Use this instead:
- Select Formula (Numeric)
- Summary Type: Select Sum
- Formula: Enter CASE WHEN {account} = '[ACCOUNT USED FOR LANDED COST such as FREIGHT/INSURANCE/DUTIES]' THEN ABS({amount})ELSE 0 END
Niks Blando-Oracle | Ask A Guru?️
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!
Expand your NetSuite knowledge by joining this month'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!
Tagged:
0