Description
Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payable’s equal those in the general ledger. Before closing a period, you can compare the cumulative total liability provided by this report with the full responsibility offered by your general ledger to reconcile these balances.
The Trial Balance Report lists and subtotals by supplier all unpaid and partially paid invoices for which Payable’s created journal entries-payable list and subtotal the invoices by the Accounts Payable Liability account.
Script To Use Accounts Payable Trial Balance Report
–Query#1
SELECT pv.vendor_name supplier_name, ai.invoice_num invoice_number,
ai.invoice_date invoice_date, ai.invoice_currency_code invoice_curr,
atb.invoice_amount invoice_amount,
atb.remaining_amount remaining_amount,
atb.code_combination_id code_combination_id,
atb.vendor_id third_party_id,
fnd_flex_ext.get_segs (‘SQLGL’,
‘GL#’,
:p_chart_of_accounts_id,
atb.code_combination_id
) concat_segments,
ai.description invoice_description, atb.invoice_id source_invoice_id,
atb.org_id, atb.set_of_books_id, pvs.attribute1
FROM ap_trial_bal_gt atb,
po_vendors pv,
ap_system_parameters_all asp,
ap_invoices_all ai,
po_vendor_sites_all pvs
WHERE NVL (atb.org_id, -99) = NVL (ai.org_id, -99)
AND NVL (atb.org_id, -99) = NVL (asp.org_id, -99)
AND atb.vendor_id = pv.vendor_id
AND atb.invoice_id = ai.invoice_id
AND atb.set_of_books_id = :p_set_of_books_id
AND atb.request_id = :p_conc_request_id
AND pv.vendor_id = pvs.vendor_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND ( NVL (pvs.attribute1, ‘X’) = NVL (:p_ap_owner, ‘X’)
OR pvs.attribute1 = NVL (:p_ap_owner, pvs.attribute1)
)
–Query#2
SELECT fnd_flex_ext.get_segs (‘SQLGL’,
‘GL#’,
p_chart_of_accounts_id,
atb.code_combination_id
) s_concat_segments,
SUM (atb.invoice_amount) s_invoice_amount,
SUM (atb.remaining_amount) s_remaining_amount
FROM ap_trial_bal_gt atb, ap_system_parameters_all asp,
ap_invoices_all ai
WHERE NVL (atb.org_id, -99) = NVL (ai.org_id, -99)
AND NVL (atb.org_id, -99) = NVL (asp.org_id, -99)
AND atb.set_of_books_id = :p_set_of_books_id
AND atb.invoice_id = ai.invoice_id
AND atb.request_id = :p_conc_request_id
GROUP BY fnd_flex_ext.get_segs (‘SQLGL’,
‘GL#’,
p_chart_of_accounts_id,
atb.code_combination_id
)
What we expect in the script.
This script helps us to comprehend How Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payables equal those in the general ledger Couple of tables which is being used in the scripts are
ap_trial_bal_gt,po_vendors,ap_system_parameters_all,ap_invoices_all,
po_vendor_sites_all pvs etc.
Summary
This Post described the script Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payable’s equal those in the general ledger. In Oracle EBS R12.
Got any queries?
Do drop a note by writing us at venkatesh.b@doyensys.com or use the comment section below to ask your questions.
