JohnCirocco — NetSuite Community

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!

Re: Joins between Transactions and Entity record fields in SuiteAnalytics just as they are available in

JohnCirocco

Jun 10, 2019 1:53PM

Yes they are and in many cases, NetSuite has already joined many of the common obvious joins (on transaction, the Item Join is already made and the fields available) Also, because they changed the wa…

1
Re: Data tab- Quantity is negative number.

JohnCirocco

May 13, 2019 9:54AM

Yes, it is unfortunate (unlike searches) but I just use more formula fields with Absolute Value.

2
Re: Looking for the statement that will evaluate the difference between two fields and if negative, retu

JohnCirocco

Apr 29, 2019 4:57PM

you could try Case when {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} > 0 then {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} else 0 end

2
Re: How do I show sourced field in report?

JohnCirocco

Apr 22, 2019 1:57PM

Yes, easiest way is to create another custom field (as stored) and a scheduled workflow (which can read unstored fields) and populate the Stored version of the field.

2