ERPstuff - Oracle EBS Community

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

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