Balances table

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

Balances table

Post by imranhad »

Dear all

Can any one tell me,

In receivables, is there any table or view exists which shows customers monthly balances.

In parables, is there any table or view exist which show suppliers balances month wise.

In inventory or cost mgt , is there any table or view exist which shows Item quantitative balances month wise.

Regards
Imran
Pirzada
Posts: 30
Joined: Fri Dec 07, 2007 2:04 am
Location: Pakistan

Post by Pirzada »

Dear Imran,
you can get your required data from AR_PAYMENT_SCHEDULES_ALL for Receivables and AP_PAYMENT_SCHEDULES_ALL for payables, but it does not store the data month wise, you will need to query it month wise on the basis of TRX_DATE and amount can be picked from AMOUNT_DUE_REMAINING.

Regards,
Ali Pirzada
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest