Skip to main content
Question

General Ledger Transaction Report - File generated type

  • April 11, 2024
  • 1 reply
  • 167 views

Forum|alt.badge.img+9

Hello, 

 

I have a question about the reports generated in IFS.

For example we would need the General Ledger Transaction Report in xls or csv type although the file is generated in pdf type.

 

Is there a way to change the file type generated ?

 

Best regards

1 reply

Furkan Zengin
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 703 replies
  • April 12, 2024

Hello @Abdessamad 

You can create a quick report for it. See a sample quick report below. Enter a result key or leave the parameter empty to get the latest report for the user. 

SELECT * FROM IFSAPP.GEN_LED_TRANSACTION_REP  X
 WHERE X.RESULT_KEY LIKE NVL('&RESULT_KEY', (SELECT MAX(A.RESULT_KEY)
                       FROM IFSAPP.ARCHIVE A
                      WHERE A.REPORT_ID = 'GEN_LED_TRANSACTION_REP' AND A.SENDER=IFSAPP.FND_SESSION_API.GET_FND_USER()))

 

Another option is to create a business reporter excel report based on information source GL Transaction. With business reporter you can use formulas and formatting in excel.

 

Hope this helps


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