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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Need Date And Item value Formula Help - Suggestions?
Anyone out there have any advice for this formula I need? NetSuite says they got this formula to work, but it does not. I am getting killed by the limitations on formula characters and have had to resort to all kinds of tweaks just to get the formula under 3000 characters.
Basically, I have a NetSuite item that I need to assign a value to depending on when it was sold. So if item1 was sold between 07/01/13 and 10/15/13, then it is worth 100. If it was sold between 10/16/2013 and 12/31/2013, it is worth 150. I have 16+ items with prices that change every quarter, which leads to a lengthy formula. I would greatly appreciate any advice. I cannot even get the formula below to work - it might be a syntax error.
0