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

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
274
Views
1
Comments

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

Tagged:

Answers

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    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.