Hi @Seko 

You can’t use MUSTERI_ADI as the filter. Because MUSTERI_ADI is not a list. You can use IDENTITY as the filter.

Change customer_name LIKE '&MUSTERI_ADI' with identity ='&CUSTOMER_ORDER.CUSTOMER_NO' in your SQL query.

Hi @hhy38,

I tried this method yesterday bu my issue is not resolved :( 

The filter screen is not appearing the way I want it to.

@Seko 

Can you share the SQL query? Let me check.

@hhy38, of course.

SELECT identity AS musteri_id,
invoice_id AS fatura_id,
invoice_no AS fatura_no,
customer_name AS musteri,
creators_reference AS siparis_no,
(SELECT ifsapp.kontek_department_api.get_department_desc (MAX (department_id))
FROM ifsapp.customer_order co
WHERE co.order_no = creators_reference) AS departman,
invoice_date AS fatura_tarihi,
due_date AS odeme_vadesi,
currency AS doviz_cinsi,
curr_rate AS fatura_kuru,
net_amount AS kdv_haric_fatura_tutari,
vat_amount AS kdv_tutari,
invoice_amount AS toplam_fatura_tutari,
open_amount AS acik_tutar,
TO_DATE (
TO_CHAR (
TRUNC (
(SUM (open_amount * TO_NUMBER (TO_CHAR (due_date, 'J'))) OVER (ORDER BY invoice_date, invoice_id))
/ (SUM (open_amount) OVER (ORDER BY invoice_date, invoice_id)))),
'J') AS ortalama_vade_tarihi
FROM ifsapp.invoice_ledger_item_cu_qry
WHERE open_amount > 0 AND identity ='&CUSTOMER_ORDER.CUSTOMER_NO'
ORDER BY identity, invoice_date, invoice_id

@Seko 

The query that you send is correct right now. The person checking the Quick Report can search by customer name with this filter. The example is below.

It was fixed when I created a new report, thank you. 

How can I add the department filter in the same way?

SELECT IDENTITY                                                                            AS MUSTERI_ID,
         INVOICE_ID                                                                          AS FATURA_ID,
         INVOICE_NO                                                                          AS FATURA_NO,
         CUSTOMER_NAME                                                                       AS MUSTERI,
         CREATORS_REFERENCE                                                                  AS SIPARIS_NO,
         (SELECT IFSAPP.KONTEK_DEPARTMENT_API.GET_DEPARTMENT_DESC (DEPARTMENT_ID)
            FROM CUST_ORD_CUSTOMER
           WHERE CUSTOMER_NO = IDENTITY)                                                     AS DEPARTMAN,
         INVOICE_DATE                                                                        AS FATURA_TARIHI,
         DUE_DATE                                                                            AS ODEME_VADESI,
         CURRENCY                                                                            AS DOVIZ_CINSI,
         CURR_RATE                                                                           AS FATURA_KURU,
         NET_AMOUNT                                                                          AS KDV_HARIC_FATURA_TUTARI,
         VAT_AMOUNT                                                                          AS KDV_TUTARI,
         INVOICE_AMOUNT                                                                      AS TOPLAM_FATURA_TUTARI,
         OPEN_AMOUNT                                                                         AS ACIK_TUTAR,
         SUM (OPEN_AMOUNT) OVER (PARTITION BY IDENTITY,CURRENCY ORDER BY INVOICE_DATE, INVOICE_ID)    AS TOPLAM_ACIK_TUTAR,
         TO_DATE (
             TO_CHAR (
                 TRUNC (
                       (SUM (OPEN_AMOUNT * TO_NUMBER (TO_CHAR (DUE_DATE, 'J')))
                            OVER (PARTITION BY IDENTITY,CURRENCY ORDER BY INVOICE_DATE, INVOICE_ID))
                     / (SUM (OPEN_AMOUNT) OVER (PARTITION BY IDENTITY,CURRENCY ORDER BY INVOICE_DATE, INVOICE_ID)))),
             'J')                                                                            AS ORTALAMA_VADE_TARIHI
    FROM IFSAPP.INVOICE_LEDGER_ITEM_CU_QRY
   WHERE OPEN_AMOUNT > 0
     AND NVL(IDENTITY = '&CUSTOMER_ORDER.CUSTOMER_NO', 'NA') LIKE '%' || '&CUSTOMER_ORDER.CUSTOMER_NO' || '%'
     AND NVL((SELECT IFSAPP.KONTEK_DEPARTMENT_API.GET_DEPARTMENT_DESC (DEPARTMENT_ID)
          FROM CUST_ORD_CUSTOMER
          WHERE CUSTOMER_NO = IDENTITY) = '&DEPARTMAN' , 'NA') LIKE '%' || '&DEPARTMAN' || '%'
ORDER BY IDENTITY,CURRENCY, INVOICE_DATE, INVOICE_ID