View source | View content page | Page history | Printable version   

Projects:Aprmadvancedmatching/User Documentation paymentpriorities

Contents

Introduction

The main goal of this module is to allow Imported Bank Statement lines to be matched not only with existing financial account transactions but also with existing payments, invoices, orders or by registering credit for the Business Partner.

There is already a "Standard" Matching Algorithm" which allows Imported Bank Statement lines to be matched just with existing financial account transactions, but that behaviour do not covers the fact that there are other type of transactions subject to be matched to an imported bank statement early in the process of reconciliation.

Installation

Follow below steps to get the "Advanced Matching Algorithm" module installed in your system:

Configuration

The objective of the reconciliation process is to explain (reconcile) any difference in the end balance shown for the financial account in Openbravo and the end balance shown on the bank statement.

There are two reconciliation processes in Openbravo:

User Interface changes

End-user must be informed of the type of document/transaction being matched with a bank statement line, therefore:

Match window.png

User scenarios

Financial Account transaction matching

The "Advanced Matching Algorithm" allows matches to existing financial account transactions same way as the "Standard" matching algorithm does, for getting that done:

Payment In/Out transaction matching

The "Advanced Matching Algorithm" allows matches to either a "Payment in" or a "Payment out" transactions as applicable, if the corresponding "financial account transaction" has not been created yet and therefore,
it can not be found/matched, for getting that done:

Sales/Purchase invoices payment plan transactions matching

The "Advanced Matching Algorithm" allows matches to either a "Purchase/Sales Invoice payment plan" as applicable, if the corresponding payment out/payment in has not been created yet and therefore,
it can not be found/matched, for getting that done:

The advanced matching also creates the corresponding "payment in" or "payment out", as applicable to be later on posted; and besides changes the Outstanding amount field as appropriate.

Sales/Purchase order payment plan transactions matching

The "Advanced Matching Algorithm" allows matches to either a "Purchase/Sales Order payment plan" as applicable, if the corresponding Purchase/Sales Invoice payment plan has not been created yet and therefore,
it can not be found/matched, for getting that done:

The advanced matching also creates the corresponding "payment in" or "payment out", as applicable to be later on posted; and besides changes the Outstanding amount field as appropriate.

The order payment plan information will be inherit by the invoice payment plan, if the invoice is created by using the option "Create Lines From".

Credit Payments matching

Finally, the "Advanced Matching Algorithm" also allows matches to no existing transaction in the system of any type, by creating a "Credit Payment" for the Business Partner to be later on used, for getting that done:

The Advanced Matching Algorithm also sums up as "Available Credit" every "Credit Payment" created while matching, as shown in the screens below:

Available credit.png

The business partner BP "Alimentos y Supermercados, S.A." has a total available credit of 2267.42, which can be used while adding a payment for that particular BP, as shown in the screen below:

Available credit 1.png

Unmatching

The "Advanced Matching Algorithm" also allows unmatching at any time, by just un checking the proposed matchings at the "Match using imported bank statement lines" window.

Unmatching can even be done once a matching has been accepted and therefore the corresponding financial account transactions have been automatically created by the system at the "Transactions" tab,
for getting that done the end-user must:

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Aprmadvancedmatching/User_Documentation_paymentpriorities"

This page has been accessed 1,368 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.