Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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??