Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
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.
0