NF12 Multiple Payments against statement line by Payment Batch

NOTE: This is not yet integrated into core

Feature: Tag Payment Into Batch to Bank Statement Line and Document Workflow Support for Payment Into Batch

Goal: Functional

Developer: Deepak Pansheriya

Feature Ticket: IDEMPIERE-5329

Description

Due to Direct Debit and Direct Credit features supported by many banks, an instruction is given to the bank, where multiple parties are credited. But such transaction shows a single line in the bank statement. To support the same, allow to select Deposit Batch instead of individual Payments, so that a Bank Statement Line can be reconciled to multiple Payments using Deposit Batch

Use Cases

1. POS Terminal Payments generated by Bank>Processor
2. E-Commerce Payments generated by Bank>Processor
3. Import Payment Batch based on bank csv then payed by 1 statement line

Changes

• added Deposit Batch field to Bank Statement Line to be able to link them
• added document workflow support for Deposit Batch
• updated the Match Bank Statement process to use Payment deposits (set Deposit Batch on Bank Statement Line)
• Marking Payments which are on Deposit batch as reconcilled.

Added Bank Statement field on Bank Statement Line

Main workflow is

1. Entering and completing payments
2. Then create deposit batch and use create from to select payments to add in Deposit batch
3. complete Deposit batch
4. Bank statement matcher try to match completed deposit batch with statement line.

Note: Normally for payment processor, you can manage separate bank account and there you can import Payment gateway statement. When payment gateway run settlement, you can do inter bank account transfer

Notes, regarding to matcher

Bank statement can be matched manually or using matcher automatically. Earlier it was matching to only payments, now matcher can match to payments as well as deposit batch