This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

*I have an issue when using the formula case when {ACCOUNTTYPE} = 'Cost of Goods Sold' THEN {AMOUNT} ELSE 0 END, it is returning a 0 for every single line, which obviously isn't correct. Any clues on what I am doing wrong?*

whats the saved search type? if its transaction, are you doing main line true? If its true it will not show you any line level information, so its needs to be False <@UCKNVMLQ4>

Thanks <@U04R3KKC0U8> Main line is set to false, but on review of the results it appears it is only providing main line results

What transaction type?  Item fulfillment?

<@U03GYQZTZDW>  Abrar has kindly found my issue for me