Payment Selection (Payment or Check Print and Export)

The purpose of this discussion is to help you create and process automated AP Payments.

2014-05-22 AM Payment Selection

Note: the above video allowed me to create a Payment Selection that included the same invoice multiple times. I created a patch/fix and submitted the fix to the iDempiere community. Hopefully, this issue is resolve in production before you use watch this video :)

Introduction
0:00:45 Ways to use Payment Selection to limit what Invoices you pay
0:02:30 General Process
0:04:30 Payment Selection window discussion
- 0:05:15 Create Lines From filter discussion
- 0:05:45 Payment Selection line
- 0:07:30 Create Lines From filter discussion (more detail)
  - 0:09:45 Tangent: Matched Purchase and Matched Invoice
  - 0:11:15 Tangent: Payment Rule
- 0:18:00 Example usage starting from scratch (new AP Invoice)
- 0:21:15 Modifying an Payment Selection Line to pay an invoice short (less than total amount)
- 0:21:45 Prepare Payment process to create Prepared Payment records (sub-tab)
0:23:15 Payment Print/Export form
- 0:24:00 Current Balance and Balance is pulled from the Bank Account and Bank Account Document
- 0:26:15 Export/Download payments
- 0:32:00 Print payments
- 0:34:00 RE-RUN/PRINT a previously printed Payment Selection
0:36:30 Should you have pre-printed checks have their own check numbers?
0:37:45 What is Direct Deposit and Direct Debit
0:39:30 How to specify your own export processor
0:42:30 Thomas Bayen's adaptation of Payment Selection to Accounts Receivable AR
0:43:45 Including Payment Export as part of a Payment Import process
0:51:00 Payment Selection Manual
0:52:00 Bank Reconciliation - Import Bank Statement - Bank Statement Matching
0:58:45 What happens when you pay the same Invoice twice from the same Payment Selection

Reference:

This is a great conversation about opportunities to improve Payment Selection

Payments Into Batch and Deposit Batch

There are two windows (Payments Into Batch and Payment Batch) that are confusing because they are closely named and related. The purpose of this section is to help clarify what these windows represent and how they are used.

Payments Into Batch window (C_DepositBatch table) - represents a grouping of Payment records into a single collection (with a single total) so that a printed/pdf bank statement line can be associated with a collection of iDempiere => Payments. There are a couple of examples where this situation is applicable:
- Accounts Receivable (AR) Clerk receives 10 checks on a given day. He/She records all 10 receipts (using Payment window with Document Type = "AR Receipt") individually. AR Clerk manually creates a Payments Into Batch record and adds all 10 checks as lines to the Payments Into Batch record. Note that you can use the Payments Into Batch window => Process toolbar icon => Create Lines From process to help automate the creation of these lines.
- Accounts Payable (AP) Clerk creates a Payment Selection for the purpose of executing a Direct Deposit into the bank account of vendors. He/She follows the normal Payment Selection process up until the Payment Print/Export form where he/she click export instead of print. The bank represents an ACH upload as single line on their bank statement (at least this bank does) even though the upload might contain 10 Payments.
Deposit Batch window - I have not used this window before; therefore, I do not have a good understanding as to why it exists.

Payment Print/Export => Deposit Batch

As of iDempiere 4.1, the Payment Print/Export form has a Deposit Batch checkbox field. The purpose of this field is to automate the creation of batches based on successfully executing a Payment Selection. Here are the details:

If checked, both clicking the Print and Export buttons will create Deposit Batch record.
If checked, clicking the exporting (and sometimes printing) will create a Payments Into Batch record. The exact logic as to when a Payments Into Batch record is created is determined by the MPaySelection class => confirmPrint (MPaySelectionCheck[] checks, MPaymentBatch batch, boolean createDepositBatch) method.

Payment Print/Export => Action Buttons

The Payment Print/Export form has three action buttons in the lower left corner:

Export - creates a file export of the appropriate Payments included in the Payment Selection. There is a default export class out of the box. You can create your own custom export by supplying your own Bank/Cash window => Account subtab => Payment Export Class field implementation.
Print - creates a PDF for printing the appropriate Payments included in the Payment Selection
Process - custom EFT process - not used before and does not seem to be fully implemented (see WPayPrint => cmd_EFT() method)