Skip to main content

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

Reply


Terms & ConditionsCookie settings