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:
- Login as Openbravo/Openbravo
- Change the role to “System Admin” by clicking the button “User Info”.
- Go to General Setup -> Application -> Module Management.
- Click the tab Add Modules -> Browse File System. Install Module pop-up window will be opened.
- Browse the "Advanced Matching Algorithm" obx file and click continue.
- Click Install Now.
- To Verify, as "System Admin" navigate to “Applicatio Dictionary // Module", once there check that the new module of "Advanced Matching Algorithm" is shown as active in there.
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:
- Manual Reconciliation from a paper Bank Statement
- for getting this one working end-user must do not select any matching algorithm at the application path:
"Financial Management // Receivables & Payables // Transactions // Financial Account // Account - Matching Algorithm field" - The system will then show a process button named "Reconcile" at the application path:
"Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Transactions"
- for getting this one working end-user must do not select any matching algorithm at the application path:
- Automatic Reconciliation using an Imported Bank Statement
- for getting this one working end-user must select a matching algorith at the application path: br> "Financial Management // Receivables & Payables // Transactions // Financial Account // Account - Matching Algorithm field"; by example the "Advanced Matching Algorithm".
- The system will then show a two process buttons at the application path:
"Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Transactions":- "Import Bank Statement"
- "Match Using Imported Bank Statement"
User Interface changes
End-user must be informed of the type of document/transaction being matched with a bank statement line, therefore:
- there is a new column named "Matched Document" at the "Match using imported bank statement lines" window, as shown below:
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:
- the end-user needs to register in the system financial account transactions to be later on matched by taking any of the below two actions:
- "Process Made Payment(s) and Withdrawal", that means a payment out which has been also withdrawn.
- "Process Received Payment(s) and Deposit", that means a payment in which has been also deposited.
- Navigate to the corresponding "Financial Account" and from the Transaction tab start the reconciliation process:
- first, by importing the corresponding bank statement
- second, by matching the imported bank statement
- third, by checking that the corresponding financial account transactions have been automatically matched by the system.
- Once the financial account transactions have been matched, their status will changed to "Cleared" = yes.
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:
- The end-user needs to register in the system the corresponding payments out/in, by taking any of the below two actions:
- "Process Made Payment(s)", that means a payment out made but not withdrawn.
- "Process Received Payment(s)", that means a payment in received but not deposited.
- Navigate to the corresponding "Financial Account" and from the Transaction tab start the reconciliation process:
- first, by importing the corresponding bank statement
- second, by matching the imported bank statement
- third, by checking that the corresponding payment in/out transactions have been automatically matched.
- forth, by checking that after matching, the corresponding financial account transactions have been automatically created by the system at the "Transactions" tab, with a description such as "Payment Nº:...."
- Once the financial account transactions have been matched, their status will changed to "Cleared" = yes.
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 end-user needs to register in the system the corresponding payments out/in, by taking any of the below two actions:
- "Process Made Payment(s)", that means a payment out made but not withdrawn.
- "Process Received Payment(s)", that means a payment in received but not deposited.
- Navigate to the corresponding "Financial Account" and from the Transaction tab start the reconciliation process:
- first, by importing the corresponding bank statement
- second, by matching the imported bank statement
- third, by checking that the corresponding purchase/sales payment plan transactions have been automatically matched.
- forth, by checking that after matching, the corresponding financial account transactions have been automatically created by the system at the "Transactions" tab, with a description such as: "Invoice Nº:......"
- Once the financial account transactions have been matched, their status will changed to "Cleared" = yes.
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 end-user needs to register in the system the corresponding payments out/in, by taking any of the below two actions:
- "Process Made Payment(s)", that means a payment out made but not withdrawn.
- "Process Received Payment(s)", that means a payment in received but not deposited.
- Navigate to the corresponding "Financial Account" and from the Transaction tab start the reconciliation process:
- first, by importing the corresponding bank statement
- second, by matching the imported bank statement
- third, by checking that the corresponding purchase/sales payment plan transactions have been automatically matched.
- forth, by checking that after matching, the corresponding financial account transactions have been automatically created by the system at the "Transactions" tab, with a description such as: "Order Nº:......"
- Once the financial account transactions have been matched, their status will changed to "Cleared" = yes.
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 end-user needs to navigate to the corresponding "Financial Account" and from the Transaction tab start the reconciliation process:
- first, by importing the corresponding bank statement
- second, by matching the imported bank statement
- third, by checking that a "Credit Payment" has been automatically created and matched to every single Imported Bank Statement line for which there is no transaction in the system of any type (Financial Account Transaction, Payment In/Out, Invoice Payment Plan and Order Payment Plan), to which a bank statement line can be matched against.
- forth, by checking that after matching, the corresponding financial account transactions have been automatically created by the system at the "Transactions" tab, with a description such as: "Amount left as credit:......"
- Once the financial account transactions have been matched, their status will changed to "Cleared" = yes.
The Advanced Matching Algorithm also sums up as "Available Credit" every "Credit Payment" created while matching, as shown in the screens below:
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:
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:
- Navigate to the "Transactions" tab at the Financial Account window and then press once more the process button "Match Using Imported Bank Statement".
- Matching shown could be unmatched.