Question

SUPPLIER INVOICE DUE FOR PAYMENT BASED ON DUE DATE


Badge +1

Dear All,

There is a PDF report “Supplier Invoice due for payment based on due date”. I need to get this in excel. 

Please help.

Thanks

Rgds


2 replies

Userlevel 6
Badge +16

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
Userlevel 6
Badge +16
  •  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)

 

Reply