Query or report for open balances in AP, AR

[Vipparla]

Are there any reports in 11.5.10.2 oracle from front end to get asset balances (like Sundry debtors, advances paid to suppliers or prepayments etc) and Liability balances (like creditors, advances received from customers etc)for an account ( natural account) along with all the below details ( appropriate and suitable)as on a particular date .

a)code combinations ( segment1, Segment2, Segment 3 .. etc)

b) invoice / transaction / receipt / payment number

b) date of invoice / transaction / receipt / payment number

c) GL date , source ( Sub ledger or Gl manual entry)

d) Original Amount

e) remaining balance


f)supplier / customer name)type of invoice / transaction / receipt / payment number


which is very much required several times. Naturally end-users require them several times. Is there any way to get them without depending on back-end? The second problem is some of them are not available in excel format.

Thanks in advance

[oteixeira]

Hello.

For AR, did you try the Aging-7 Buckets by account?
For AP you can try the Accounts Payable Trial Balance.

Octavio