×

Warning

JUser: :_load: Unable to load user with ID: 43

Rules

invoicing matching rules

 

How matching rules work

 

When automatically processing imported payments, the system goes through the payment matching rules and looks for an invoice or client that meets the criteria set out in the individual rules. A given payment will be matched with an invoice or added to a client’s credit on the basis of the first rule that finds a match. There are six system rules that help to maintain the functionality of this part of the system. They work in the same way that payment matching worked earlier. These rules cannot be deleted or edited. You can activate icon check ko / deactivate icon check ok a particular rule in the Active column.

 

 

You can add a new rule by clicking on . The form that you have to complete on this page consists of three parts:

 

Payment matching type

 

  • Match payments on the basis of the data given in: Client
    Payments will be matched on the basis of the data given in the Client card (Client number, Assigned VS)
  • Match payments on the basis of the data given in: Invoice
    Payments will be matched on the basis of the data given in invoices issued (Invoice number, Client number, Assigned VS).

 

Criteria

 

The criteria used to match payments At least one must be used. If there is more than one, all must be met for payment matching to succeed.

 

  • The VS of a payment has to be the same as: Invoice number, Client number, Assigned VS
  • The SS of a payment has to be the same as: Invoice number, Client number, Assigned VS
  • The payment note has to be the same as: Invoice number, Client number, Assigned VS
  • A client’s bank account number has to be the same as the the bank account number stated in the payment details: Yes, No
  • Payment Amount:
    • = Invoice – The payment amount has to be the same as the invoiced amount (Invoice settled).
    • < Invoice – The payment amount has to be less than the invoiced amount (Invoice partially settled).
    • > Invoice – The payment amount has to be greater than the invoiced amount (Invoice settled and the rest added to credit).

 

What happens when criteria are met

 

  • Action:
    • Match with the oldest invoice - Match a given payment with the oldest invoice of a given client.
    • Match with the newest invoice - Match a given payment with the newest invoice of a given client.
    • Add to credit - Match a given payment and add it to a given client’s credit .
  • Note: The note that will appear in a payment matched according to this rule

 

 

Having created and ordered rules, you can check whether they work correctly by clicking on Test rules for payment matching. A form appears into which you can enter payment details (Payment VS, Payment SS, Bank account number, Amount, Note). You can start the test itself by clicking on Test. Once the test is finished, a table appears in which you can see individual rules with lists of invoices or clients found. The rule according to which a given payment would have been matched is highlighted in green.

 

 

In the overview, you can find all the necessary attributes related to individual rules. You can order these rules (according to your needs) with the help of the arrows in the Priority column. When matching payments, the system goes through the rules in the order that you have set.

 

Priority The order in which individual rules will be employed to match payments
Match payments according to the data in Payment data are compared with invoice data / client data.
Payment VS (Variable symbol) has to equal to Invoice number / Client number / Assigned VS 
Payment SS (Specific symbol) has to equal to Invoice number / Client number / Assigned VS 
Payment note has to equal to Invoice number / Client number / Assigned VS
Account number A client’s bank account number is / is not the same as the bank account number stated in the payment details.
Payment amount The payment amount is equal to / greater than / less than the invoiced amount
Note The note that will appear in a matched payment 
Action What happens when there is a match between a payment and a rule 
Active Activate/deactivate a rule
Editing and deletion Your own rules can be edited or deleted. System rules can only be deactivated. Rules can be edited only when they are active.

Mikrotik guide

This document approximates crucial information necessary for proper understan...

Removing records from ISPadmin

Delete client Deleted client is not deleted from the system, instead its rec...

Download burst

http://wiki.mikrotik.com/wiki/Manual:Queues_-_Burst (http://wiki.mikrotik....

Binary backups of MikroTik routers not working

The most common error messages regarding binary backups are: Mikrotik E...

Add / Edit Router

HardwareRoutersAll, + Add new router or Edit in the details box of a particul...

Limited data consumed / Traffic graphs are high

If you experience one/both of the following problems Limited data gets consum...

Router connection test

Hardware Routers All Click on Update all routers (test connection to all router...

Router monitoring

If router is monitored, the system does not copy any configurations, it barely p...

Service activation on MikroTik routers

An active communication between router and ISPadmin is a prerequisite for its...

Installation Modems

There are two different ways of adding cable TV clients to the system: A new ...

User rights to access MikroTik router

Also, to ensure correct communication between a router and ISPadmin you have ...

Can the system monitor latency and packet loss rate for each device?

Yes, all devices (including client devices, if you want) are monitored and gr...

How to set up a UBNT router

1. Define the IP address range for clients on the router where shaping is don...

Under what conditions does the WiFi Clients at AP section appear in the overview of routers?

Set up a particular device as an access point and specify where shaping is ...

Supported routers and interfaces

Router SNMP SSH API IPv6 Wlan MAC filter Firewall MAC filter Firewa...

Retrieving routing table from MikroTik routers

If there are more than 1,000 rows in the routing table on a Mikrotik router, ...

Creating ACCESS LIST

In a situation where the router Mikrotik is only an AP without any routed networ...

How to mass delete clients' MAC addresses

You can see the following icon - MAC FILTER - in the header of a router with the...

«
»

CONTACT

NET service solution, s.r.o.
Žerotínova 3056/81a
787 01 Šumperk
Czech Republic