Skip to main content
Solved

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


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 4 replies

Hi, everybody

I want to select the MUSTERI_ADI filter as on the customer screen.

While the Department_Id filter works as I want, MUSTERI_ADI filter does not work as I want.

Department screen is basic data, maybe that's why the screen appears like that on the filter.

Best answer by hhy38

@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.

 

 

View original
Did this topic help you find an answer to your question?

6 replies

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 325 replies
  • May 23, 2024

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.

 

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 4 replies
  • May 24, 2024

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.


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 325 replies
  • May 24, 2024

@Seko 

 

Can you share the SQL query? Let me check.


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 4 replies
  • May 24, 2024

@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


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 325 replies
  • Answer
  • May 24, 2024

@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.

 

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 4 replies
  • May 24, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings