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
Hello
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.