Calculation of Ranking for Reconciliation Recommendations 
When you perform semiautomatic external reconciliation, SAP Business One provides you with ranked recommendations for reconciliations, which you then perform manually. The ranking calculation for each recommendation is comprised of the summary of the ranking for the three parameters: the amount, the date, and the reference.
The priority weighting and the maximum deviation you specify for each parameter in the selection criteria for the external reconciliation determine how the ranking is calculated.
Specifying the priority determines the maximum rank for a parameter.
Priority Weighting |
Value |
|---|---|
High |
45 |
Medium |
35 |
Low |
20 |
Skip |
0 |
The rank for each parameter is calculated using the following formula:
Parameter |
Formula |
Comment |
|---|---|---|
Amount |
Priority Weighting – (absolute amount difference / Max. Deviation) X Priority Weighting |
If Max. Deviation is zero, the parameter rank is the Priority Weighting value if both transactions have the same amounts; otherwise it is zero |
Date |
Priority Weighting – (absolute date difference in days / Max. Deviation) X Priority Weighting |
If Max. Deviation is zero, the parameter rank is the Priority Weighting value if both transactions have the same date; otherwise it is zero |
Reference |
Priority Weighting |
Rank is zero if the transactions do not have the same reference number. |
Note
The result of [amount/date difference / Max. Deviation X Priority Weighting] is rounded down to the nearest whole number.
If SAP Business One recommends reconciling a few transactions together, the calculation of the amount rank is based on the summary of the amounts of those transactions. The calculation of the date rank is based on the summary of the transactions’ date rank.
The total ranking for a recommended reconciliation is calculated as follows: rank = amount rank + date rank + reference rank
Example
You prioritized the parameters as follows:
Parameter |
Priority Weighting |
Max. Deviation |
|---|---|---|
Amount |
High |
50 |
Posting date |
Medium |
30 |
Reference 1 |
Skip |
Not applicable |
You want to reconcile the following transaction:
Transaction Number |
Posting Date |
Reference 1 |
Balance Due |
|---|---|---|---|
100 |
October 5 2009 |
54 |
50 |
SAP Business One displays the following ranked recommendations:
Rank |
Transaction Number |
Posting Date |
Reference 1 |
Balance Due |
|---|---|---|---|---|
72 |
304 305 |
October 15, 2009 October 29, 2009 |
10 22 |
20 35 |
55 |
306 304 |
November 1, 2009 October 15, 2009 |
9 10 |
50 20 |
49 |
306 |
November 1, 2009 |
9 |
50 |
42 |
304 |
October 15, 2009 |
10 |
20 |
39 |
305 |
October 29, 2009 |
22 |
35 |
The following table details the calculations for the rank of each of the recommendations:
Transaction Number |
Amount Rank |
Date Rank |
Rank |
|---|---|---|---|
304 |
45 – |20 – 50| / 50 X 45 = 45 – 27 = 18 |
35 – 10 / 30 X 35 = 35 – 11 = 24 |
18 + 24 = 42 |
305 |
45 – |35 – 50| / 50 X 45 = 45 – 13 = 32 |
35 – 24 / 30 X 35 = 35 – 28 = 7 |
32 + 7 = 39 |
306 |
45 – |50 – 50| / 50 X 45 = 45 – 0 = 45 |
35 – 27 / 30 X 35 = 35 – 31 = 4 |
45 + 4 = 49 |
304, 305 |
45 – |20+35 – 50| / 50 X 45 = 45 – 4 = 41 |
24 + 7 = 31 |
41 + 31 = 72 |
304, 306 |
45 – |50+20 – 50| / 50 X 45 = 45 – 18 = 27 |
24 + 4 = 28 |
27 + 28 = 55 |
Note
The combination of transactions 305 and 306 is not included in the recommendations since their balance due, which is 85, deviates from the balance due of transaction 100 by more than 30, which is the value of the maximum deviation.