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

Hello all, I need help on this, I want only one bank, but it returns list. Can anyone help please?
select concat(concat(bank.name, (case when bank.custrecord_2663_parent_vendor is null then bank.custrecord_2663_parent_cust_ref else bank.custrecord_2663_parent_vendor end)), bank.custrecord_cmb_bank_id)
from CUSTOMRECORD_2663_ENTITY_BANK_DETAILS bank,
    entity
where
    bank.custrecord_2663_parent_vendor = entity.id
    and BUILTIN.DF( entity.type ) like '%Customer%'
    and BUILTIN.DF( entity.type ) like '%Vendor%'
    and entity.isinactive = 'F'
group by concat(concat(bank.name, (case when bank.custrecord_2663_parent_vendor is null then bank.custrecord_2663_parent_cust_ref else bank.custrecord_2663_parent_vendor end)), bank.custrecord_cmb_bank_id)
having count(*) = 1