title: NetSuite query SQL
date: 2023-10-08 23:05:48
tags: [NetSuite]
categories: NetSuite
description:
Netsuite query SQL
SELECT
--top 10
custbody_pri_prj projectid,
max(trandate),
max(trandisplayname),
max(memo),
max(type),
--trandisplayname,
--*
from transaction
where custbody_pri_prj is not null
and trandate >= to_date(add_months(CURRENT_DATE, -6))
group by custbody_pri_prj
Statement used in Saved Search:
CASE WHEN {quantity}-{custcol_pri_fgt_cntr_direct_imp_total} > 0 THEN
CASE WHEN {custcol_pri_fgt_cntr_direct_imp_poloc} IS NOT NULL THEN
'<a class="dottedlink" href="/app/accounting/transactions/purchord.nl?whence=&custbody_pri_fgt_cntr_direct_imp_so='|| REGEXP_REPLACE(, '_\d+', '') || '&entity='|| {custcol_pri_fgt_cntr_po_vendor.id} ||'&location='|| {custcol_pri_fgt_cntr_direct_imp_poloc.id} ||'&custbody_pri_frgt_loc_ult='|| {location.id}|| '">Generate PO</a>'
ELSE
'Not Applicable'
END
ELSE
'Fully Generated'
END