BankStatement Enhancements

From AdempiereWiki

New Fields

In the 'Statement Line' tab of the 'Bank Statement' window some fields where added to allow the creation of payments with discount, write-off and over/underpayment amounts as in the 'Payment' window and to have the ability to reference more than one invoice or payment in a bank statement line.

Discount Amount, Write-Off Amount, OverUnder Payment (boolean) und OverUnder Payment (amount) are in accordance with the same fields in the 'Payment' window. They have the same functionality (callouts) as the fields in the 'Payment' window. If an invoice is selected the Discount Amount field is filled according to the invoices payment term (same behaviour as in the 'Payment' window).

If the flag 'Multiple Payments or Invoices' is set you can enter several invoices and/or payments referencing the bank statement line to represent scenarios like:

• A customer pays several invoices with one payment (one bank statement line)
• One bank statement line references several payments (e.g. credit card payments where you get a lump sum of all payments of the last week - reduced by the banks charge)

If the flag 'Multiple Payments or Invoices' is set, the field 'More than one payment' is shown to descriminate the two cases. If you have more than one payment the fields 'Payment' and 'Create Payment' are hidden since the payments have to be entered in the 'Reference' tab. The fields Transaction Amount, Discount Amount, Write-Off Amount and Over-Under Payment are readonly. The amounts are summed up from the reference line amounts. If you have only one payment (but several invoices) the 'Create Payment' button will create one payment and allocates all referenced invoices.

Reference Lines

At the 'Reference' tab you can enter all payment amounts analog to the 'Statement Line' tab. If an invoice is selected all amount fields and the business partner field is set. The 'Create Payment' button creates a payment and an allocation (if an invoice is selected). If the bank statement line has only one payment (but several invoices) the 'Payment' field and the 'Create Payment' button are hidden.