I wish to create a AP aging dashboard in the Intelligence Reporting module.  The issue is the table "APAGED" is only populated when the A/P aging report is run for all vendors.

Hence if the report was run for one vendor that is what you will get when the report is run from IR.  Is there a way to run the aged payable report from within Intelligence Reporting, whether by a macro or populate the table "APAGED" or some other way.   One that my be set up as a scheduled event.

Open to all ideas:

Regards,

Edmund