Accounts Payable Trial Balance

 

Accounts Payable Trial Balance is a standard report that displays the data for the creditors according to the parameters given in Report Definition.
Here we can design the Report Definition according to the business requirements.

Below are the steps to create a report definition and then use it in the 'Accounts Payable Trial Balance' standard report.

Step 1: Go to "Open Account Balance Listing Definitions"

Click on Create

Here we give a proper code and naming conventions and select the ledger for which you want to select the values. 
Here we have "Defined By" which has two values "Segment" and "Accounting Flexfield". In Segment, you can select any particular segment of COA for which the report will populate data for all the active code combinations in which that segment value is used. we have taken this in the above example. In Accounting Flexfield, you have to pass the exact Code Combination for which the report will populate the data for that combination only and nothing else.

Now after that select the Journal Source for which data has been posted in GL and then select the Segment and its values for which the business wants the balances.

Now we submit the report with our report definition. Here we can submit both a Summary and a Detail Report.

We can also customize this report and use the same definition we have created above.

#oracle #ebsr12 #accountpayable #trailbalance #payables #reportdefinition #reports