Payment Batches

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Payment Batches

Post by anu_uma »

Hi All,
What are the stages in Payment Batches?
ramkic
Posts: 34
Joined: Fri Sep 15, 2006 3:41 pm
Location: USA

Post by ramkic »

Hi,
The following processes will be performed when you create a payment batch.

1. Select Invoices
When a payment batch is started one row for each record is created in the
AP_INV_SELECTION_CRITERIA_ALL table.
This table stores the criteria that a payment batch uses to select invoices for payments.
The module name for the AutoSelect process is APXPBSEL. The Select Invoices, or
AutoSelect, is the first step in the payment batch process.
The AutoSelect process starts by loading records that meet the invoice selection criteria
into the table AP_SELECTED_INVOICES_ALL from the tables
AP_INVOICES_ALL and AP_PAYMENT_SCHEDULES_ALL.
The criteria that AutoSelect uses to determine which record to select from
AP_INVOICES_ALL and AP_PAYMENT_SCHEDULES_ALL
is stored in AP_INV_SELECTION_CRITERIA_ALL.
To be sure that no duplicate invoices get selected, invoices that are already selected in
another payment batch are not selected. Invoice payments that have no remaining
payment amounts are not selected either.

2. Build Payments
The module name for the Build Program is APXPBBLD. From the list created by
AutoSelect, the Build program determines which invoices will be paid on each
payment document, and lists this information on the Preliminary Payment Register if
selected. The Build program is spawned when AutoSelect has completed. When the
Build Program starts, the application uses information from the table
AP_SELECTED_INVOICES_ALL to create rows in the table
AP_SELECTED_INVOICE_CHECKS_ALL. In addition to creating rows in the
AP_SELECTED_INVOICE_CHECKS_ALL, the build payments program also
performs the following tasks:
? Assigns document numbers for payments
? Assigns Check Ids
? Renumbers the remaining documents starting from the first_available_document
? Updates the payment batch status to BUILT
? Resets the prososed_amount to the payment_amount.

3. Modify
Modify allows you to change what was done in the AutoSelect and Build processes. You
can modify the payment amount of an invoice, prevent payment to a supplier, prevent
payment of a particular invoice, or add an invoice that was not originally selected. If
you add invoices to a payment batch, it will automatically be rebuilt.

4. Format
The module name for the format process is usually either APXPBFEG or APXPBFOR.
Many customers create their own Format program. The Format program creates the
output file that is used to print checks. This process inserts the payment record from
AP_SELECTED_INVOICE_CHECKS_ALL into AP_CHECKS_ALL.

5. Confirm
Confirm is the final step in processing a payment batch and should be done prior to
sending out the checks. Invoices are not considered paid, even if checks are printed, until
confirm has been done. If you have any unconfirmed payment batches, you cannot close
a period or use the same payment document for any other payments until you confirm the
payment batch.

6. Canceling Payment Batches and Voiding
Payments
When you cancel a Payment Batch, the Payment Batch?s payment document becomes
available for another payment batch. You cannot cancel a Payment Batch if it has been
confirmed. Once the payment batch is confirmed, you would have to void individual
payments, taking the desired action on the invoice. Voiding payments will update the
invoice(s) to a status of unpaid.
Major Tables Involved In Payment Batch Process
AP_SELECTED_INVOICES_ALL
AP_INV_SELECTION_CRITERIA_ALL
AP_INVOICES_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_SELECTED_INVOICE_CHECKS_ALL
AP_CHECKS_ALL
AP_INVOICE_PAYMENTS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_INVOICES_ALL

-----------------

Hope this will help

Thanks
Regards
ramkic
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Steps and Statuses
1) Select Invoices = New > Selecting > Selected
2) Build Payments = Built
3) Format Payments = Formatting> Formatted
4) Confirm Payment Batch = Confirming > Confirmed
Arjunn
Posts: 62
Joined: Sat Jan 06, 2007 11:18 am
Location: India

Post by Arjunn »

In order to schedule payments of multiple Invoices in AP, we use the batch payment. They have various stages

Select/Build: If you want to review and modify the invoices selected in the payment batch before you format payments, choose Select Invoices and Build payments to have Payables select invoices and build payments. (Payables automatically builds payments when you initiate invoice selection.)

Format: If you want to format the payments without modifying them, also select Format payments to have Payables automatically format payments, here payment document will be prepared

Confirm: Select Confirm payment Batch to confirm electronic payments. You cannot select this option if any payment batches in the set use payment documents set up for checks. Through confirmation only your making known to oracle payables that the payment batch is successfully completed
riza
Posts: 1
Joined: Tue Nov 11, 2008 12:43 am
Location: Malaysia

Post by riza »

After confirm the payment.. how to set <b>document number to</b> to be cauted automatically.
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Post by siva sankar »

Hi,

Find the following stages in payment batch satuses.

1.New
2.Selecting
3.Selected
4.Built
5.Formatting
6.Formatted
7.confirmaing
8.Conformed.

Thanks & Regards,

Siva
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 13 guests