View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:Aprmadvancedmatching/Functional Documentation advancedmatching

Contents

Advanced Matching Algorithm

Introduction

The existing "Standard" Matching Algorithm allows Imported Bank Statement lines to be matched just with existing financial account transactions.

The "Advanced Matching Algorithm" new feature must 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.

Process Overview and Assumptions

It is possible to import a "Bank Statement" file for a given "Financial Account" at the application path:
" Financial Management // Receivables & Payables // Transactions // Financial Account",
as the first step for Reconciliation process.

It is also possible to select a "Standard" Matching Algorithm for a given "Financial Account", at the application path:
"Financial Management // Receivables & Payables // Transactions // Financial Account // Account - Matching Algorithm field",
which allows to match the imported bank statement lines to existing financial account transactions.

There should be a new "Advanced Matching Algorithm" which allows matches to:

  1. existing financial account transactions (current behaviour), and..
  2. "Payments in/out" if the financial account transaction is not found
  3. "Invoice payment plan" if a payment in/out is not found
  4. "Order payment plan" if an Invoice payment plan is not found
  5. and finally to generate a credit for a Business Partner in case there are no transactions to match found.

Besides the "Advanced Matching Algorith" must also:

Design Considerations

A new module needs to be created for the "Advanced Matching Algorithm"
The new "Matching Algorithm" could be setup as by default "Matching Algorithm" for a given Financial Account at the application path:
"Financial Management // Receivables & Payables // Transactions // Financial Account // Account - Matching Algorithm field"

This new module must contain a new mathing logic as described in the section below.

Overall Module Information

Advanced Matching Algorithm

There should be a new "Advanced Matching Algorithm" which allows matches to:

and it should also allow matches to:

and finally, in case there is no transaction of any of the transaction types detailed above created, the advanced maching must alow to:

All the matches should be highlighted in Green and be already checked as Matched.

Besides the "Advanced Matching Algorith" must also alow unmatching at any time, as described below:

Once the user has completed the matching process they click on the "Reconcile" button. This then triggers the accounting events defined by the accounting workflow.

Matching Criteria

User Interface changes

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

Match window.png

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

This page has been accessed 2,076 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.