Payables and Cash Management - EBS (MOSC)

MOSC Banner

Need a Query to find all those Invoice which was cancelled Invoices in Ap Aging report in back date

edited May 22, 2017 4:21PM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

Hi Experts,

I need a Query to find all the Prepayment  Invoices which are cancelled  to be shown in back dated date in Ap Aging report.

Example:

Invoice created in Jan-2017

Cancelled in May-2017

When I run the aging for Feb-2017, this Invoice need to be shown in Feb 2017 which was acive

Please provide a Query

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center