SUPPLIER INVOICE DUE FOR PAYMENT BASED ON DUE DATE

This is possible in 2 ways:

1. Creating a new report layout using Excel as the output in “Report Definition” under Solution Manager. More notes on how to do this are available in IFS Help - Technical Documentation
2. Create a quick report based on the operational report. This is often set up to also always open the latest ran report automatically but an example of the steps in Apps 10 is below. With this setup, the user has to first run the operational report, then run the quick report and export all rows to Excel

•  Open Debug Control
• Run the report you wish to output into Excel, take note of the report key

• 

  Find the Report name in the last server invoke line from the Debug

• 

  Create a new quick report

• 

  Run the quick report entering the result key (once you’ve done the setup, the end users can use the pre-created quick reports, don’t need to do this again so it’s much quicker than the steps above)