The Query provided in this post can be used to reconcile a Payables control Account to GL. This may be a liability account or a prepayment account:
The query provided in this post will provide you with the complete list of transactions that sum up to make your AP Accrual Balance in General Ledger. You may amend the query to run for whatever date range/GL Accrual Account you require, and any other columns you see fit:
This post will provide you with the complete detailed method on how to Create a WebADI Integrator and to upload Suppliers into your Oracle EBS R12 instance through WebADI.
This post will provide you with the query to calculate “Projected” payment withholding of a single or multiple AP Invoices.