Purpose of this article is to provide information regarding generating Payables Trial Balance Report and different parameters needed in Fusion Payable Application.

Purpose of Payable Trial Balance Report

Payables Trial Balance Report lists and subtotals by supplier and liability account all unpaid and partially paid invoices that Payables transferred to the general ledger. Accounts Payable Trial Balance Report helps to verify that total accounts payable liabilities in Payables equal to those in the Fusion General Ledger. Before closing a period, we can compare the cumulative total liability provided by this report with the total liability listed in General Ledger to reconcile these balances. The Trial Balance Report lists and subtotals by supplier all unpaid and partially paid invoices for which Payables created journal entries. Payables lists and subtotals the invoices by the Accounts Payable Liability account. These invoices represent organization's outstanding accounts payable liability. Therefore, to obtain the most up-to-date trial balance, we should create journal entries for payment and invoice activity before submitting this report. Since this report presents outstanding accounts payable liability information, it is only valid for an accrual set of book.

Run this report from the Reports and Analytics work area or the Manage Scheduled Processes page.

This process flow diagram is taken from Oracle

Prerequisites

When defining natural account values, assign the financial category of Payables to all accounts to include in the Payables Trial Balance. To report invoices that are paid with bills payable as outstanding as long as the bills payable status has not changed to Negotiable, assign the financial category of Payables to the bills payable account and post invoice and payment activity to the General Ledger.

Parameters

Ledger
Specify the ledger for which to run the report. We can select a primary or secondary ledger, or a reporting currency ledger. Run the Accounts Payable Trial Balance for primary and secondary ledgers, and for reporting currencies. However, the original invoice amount is only provided when the report is run for the primary ledger. The reason is that Payables only stores transaction base amounts in the primary ledger currency

Business Unit

Specify the business unit for which to run the report or leave blank to include all business units.

Liability Account As-of Date

Specify the date as of which to report the liability account.

Party Name

Enter a party to limit the report to a single supplier or party.

Account Range

Select the accounts.

Negative Balances Only

Select Yes to limit the output of the report to suppliers with negative balances.

Include Bills Payable

Select Yes to include bills payable.

How it Works

When the Create Accounting and Post Journal Entries to General Ledger programs are run, the Payables Trial Balance Maintenance Program is launched and updates the AP_TRIAL_BALANCES table. This is a permanent table that keeps all history. It is from this table that the balances are retrieved when the Payables to General Ledger Reconciliation report is run.

The AP_TRIAL_BALANCES_GT table is a global temporary table and is used to aggregate balances from the permanent table for use in the Payables Trial Balance Report. When a user submits the Payables Trial Balance Report, based on the parameters selected (e.g. ledger or supplier), the data is fetched from the permanent table and aggregated in the GT table. The GT table is only temporary and gets truncated.

The AP_TRIAL_BAL_LOG table is used to track the maintenance program activity and used for recoverability in case of failure.

The Payables Trial Balance Report comes with four seeded report templates: 

• Group by Account, Summary
• Group by Account, Detail
• Group by Third Party, Summary
• Group by Third Party, Detail

Add comment