SELECT
   transaction.id AS id,
   transaction.tranid AS document_number,
   transaction.recordtype AS type,
   customrecord_nsts_ci_gen_ci_links.custrecord_nsts_cil_ci_number AS ci_number,
   transaction.trandate AS date,
   transaction.duedate AS due_date,
   transaction.entity AS bill_to_id,
   BUILTIN.DF(transaction.entity) AS bill_to,
   customer.custentity_cs_customer_cc AS bill_to_acc,
   customer.custentity_cs_payer_number AS bill_to_ledger_number,
   transactionAccountingLine.amount AS amount,
   ROUND(transaction.foreignamountunpaid * 1 * transaction.exchangerate, 2) AS amount_remaining,
   transaction.currency AS currency_id,
   transaction.exchangerate AS exchange_rate 
FROM
   transaction 
   JOIN
      transactionline 
      ON transaction.id = transactionline.transaction 
      AND transactionLine.mainline = 'T' 
   JOIN
      transactionAccountingLine 
      ON transactionAccountingLine.transactionline = transactionLine.id 
      AND transactionAccountingLine.transaction = transactionLine.transaction 
   JOIN
      customer 
      ON transaction.entity = customer.id 
   LEFT OUTER JOIN
      customrecord_nsts_ci_gen_ci_links 
      ON transaction.custbody_nsts_ci_link = customrecord_nsts_ci_gen_ci_links.id 
WHERE
   transaction.recordtype = 'invoice' 
   AND transaction.foreignamountunpaid > 0 
   AND transactionline.subsidiary = 3 
   AND NVL(transaction.duedate, transaction.trandate) <= TO_DATE('2021-6-12', 'YYYY-MM-DD') 
   AND customer.custentity_cs_payer_number NOT IN ('XXX')  -- if this line is removed search returns error: Search error occurred: Invalid or unsupported search
   AND ROUND(transaction.foreignamountunpaid * transaction.exchangerate, 2) < 20
ORDER BY
   transaction.duedate ASC,
   transaction.trandate ASC