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.
Aged Inventory Report
Since NetSuite does provided a standard Aged Inventory Report, I'm building a saved search. The formula fields on my search are failing. Here is what I have built so far.
1) Transaction type saved search
2) Criteria
Posting = T
Account type = any of Other Current Asset and Other Current asset
Quantity = greater than 0
3) Results
Item
Summary Type: Group
Formula Field
Summary Type: Sum
Formula: Sum CASE WHEN TRUNC ({today})-{trandate} > 60 THEN {quantity} END
My output for the formula field is ERROR: Invalid Expression. What am I missing in my formula??
0