Payable Accounting process

I am assuming you use Accrual basis accounting and will describe that process. The Payables Accounting Process is the name in 11i. In R12, this is now called Create Accounting. I will also refer to the 11i tables because of the specific name of the program. 

The Payables Accounting Process selects unaccounted invoice events, and payment events, and payment clearing events with an accounting date within the parameters you have selected. For example, an invoice event can be Invoice Created, Invoice Cancelled, Prepayment Applied. Payment events can be Payment Created, Payment Cancelled. Payment history events are Payment Cleared or Payment Uncleared.

Each of these events stored in one of the following base tables:

 - ap_invoice_distributions_all
 - ap_invoice_payments_all
 - ap_payment_history_all

The event is also in the ap_accounting_events_all table.

When the Payables Accounting Process runs, it picks up the events, and creates one or more records in the ap_ae_headers_all table (one header is created for each event in every set of books). It also creates 2 or more records in the ap_ae_lines_all table, at least one debit and one credit for each event.

The process also updates the base tables ap_accounting_events_all tables, as well as the posted_flag on the base tables. Updating the status of the posted_flag shows on the workbench screens and will show Accounted, Partial, or Unaccounted, depending on the status of all the events.

The posted_flag should be 'Y' for yes once it is successful. If there are multiple events to account, and some are Y and some are N, then the status on the workbench will be Partial.

I hope this helps.