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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Formula Causes Unexpected Error on Transaction Search Drill-Down
Well, here's a big challenge for you formula gurus!
I have a Summary Transaction Search filtered to Invoices, Credit Memos and Journals.
I have one complex formula that works well and behaves properly when you click on a Grouped Field to drill down to the details for that Group:
ROUND(SUM(NVL({amount},0) - 1.15*( NVL({custcol_cogs_line},0) + NVL({custcol_freight_line},0))) / NULLIF(SUM({amount}), 0), 3) Unfortunately, I have about 5 very complex formulas which cause an "Unexpected Error" when you drill-down on a Group field. Here's an example:
ROUND(SUM( 0.15 * (NVL({custcol_cogs_line},0) + NVL({custcol_freight_line},0)) ) / NULLIF(SUM(NULLIF(CASE {type} WHEN 'Credit Memo' THEN -1 * NVL({custcol_product_weight_ff_line},0) WHEN 'Journal' THEN 0 ELSE NVL({custcol_product_weight_ff_line},0) END, 0)),0), 3) 0