Preliminary payment report in AP


Reputable Poster
We are on E1 9.0, tools,

We have 8 or 10 Create Payment Group versions all of which have a limit of 1,000,000 dollars. If we have a payment that will exceed that, it will not be included in the Payment Group, but AP will get approval and we will increase that limit in the processing options so that it can be paid.

However, AP would like to run a report daily that shows any payments that will exceed the 1,000,000 limit.

Any ideas as to an existing report that would provide this info? We have asked AP to just look at the payment group report and it will note if a payment will exceed that limit. They can then take the vendor number and look up what will be paying this vendor. However, AP does not like that solution. They are looking for a report that will just list the upcoming payment amounts and either only show them over a certain amount, or list all but be sorted by payment amount.

Any thoughts would be appreciated.