Oracle Analytics and AI

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

opening and closing balances in supplier ledger advances summary(Account Payables) in BI Publisher

Summary

supplier ledger balances summary

Content

Hi,

Have got some custom BI Publisher requirement where i want to get the supplier number, name , opening balance of selected from date parameter , debit , credit and closing balance.

opening balance should be previous date closing balance. This is custom build not standard report. can anyone help me the query.

Regards,

Reddy

Find more posts tagged with

Reporting

Accepted answers

All comments

User910243567

You can refer the standard oracle report 'Supplier Open Balance Letter' for your query. The program is using package AP_GET_SUPPLIER_BALANCE_PKG to derive the balances.