Matching
These processing options specify whether the system considers invoices with discounts and credit memos for matching.
- 1. Open Invoice Amount
Use this processing option to apply the receipt to the open invoice amount and ignore any discounts. Values are:
Blank: Apply the receipt to the open invoice amount, less the discount amount. You must enter a value in either processing option 2 (Less Available Discount) or processing option 3 (Less Earnable Discount) if you use this value.
1: Apply the receipt to the open invoice amount and ignore discounts.
- 2. Less Available Discount
Use this processing option to apply the receipt to the open invoice amount, less the available discount. The system subtracts the available discount amount from the open invoice amount before it applies the receipt. Values are:
Blank: Apply the receipt to the open invoice amount and ignore any discounts. You must enter 1 for the Open Invoice Amount processing option if you select this value.
1: Apply the receipt to the open invoice amount, less the available discount.
- 3. Less Earnable Discount
Use this processing option to apply the receipt to the open invoice amount, less the earnable discount. The system subtracts the earnable discount amount from the open invoice amount before it applies the receipt. The G/L date of the receipt must be on or before the invoice discount due date for the discount to be earned. Values are:
Blank: Apply the receipt to the open invoice amount and ignore any discounts. You must enter 1 for the Open Invoice Amount processing option if you select this value.
1: Apply the receipt to the open invoice amount, less the earnable discount.
- 4. Match by Exclusion
Use this processing option to determine which invoices are not being paid (excluded) and to apply the receipt to the remaining invoices. You set this processing option when the possibility exists that a significant percentage of open invoices are paid by one receipt. The system calculates the difference between the receipt amount and the total open invoice amount, and then attempts to find a combination match for this amount. If a match is found, the system applies the receipt to all invoices that are not part of that combination.
For example, you have a receipt for 900.00 and these invoices:
100 for 50.00
102 for 150.00
103 for 200.00
104 for 500.00
105 for 30.00
Total = 930.00
The system calculates the total of 930.00 and searches for a 30.00 invoice or any combination of invoices that equal 30.00. When it finds the invoices that equal 30.00, it applies the receipt to the remaining invoices instead of adding each invoice to the next until the payment amount is reached.
Values are:
Blank: Do not match by exclusion.
1: Match by exclusion.
When using match by exclusion, consider sorting the invoices in descending order by invoice date so that the newest invoices enter the algorithm first.
- 5. Credit Memos Included
Specify whether to include credit memos in the matching process. Values are:
Blank: Do not include credit memos.
1: Include credit memos.