How to change IFS Applications 10 filter setting for quick reports?

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

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