Use this window to specify matching criteria for reconciling sales and purchasing documents with their respective payments.
To open this window, choose
.You can set a combination of up to three rules for each round. Each rule can consider one of the parameters described below.
Note
Each parameter can be used for only one rule in a specific round. Once you assign a parameter to a rule, it is removed, for the same round, from the dropdown lists of the other rules.
Selecting this parameter:
Example The variation in days is defined as 3. The posting date of a specific invoice is 01.05.2007, and there is a payment for the exact amount with the posting date of 06.05.2007. The difference is five days. In this case reconciliation does not take place. End of the example. |
Selecting this parameter:
Example The variation in days defined as 3. The due date of a specific invoice is 01.05.2007, and there is a payment for the exact amount with a posting date of 03.05.2007. The difference is two days. In this case reconciliation takes place. End of the example. |
Selecting this parameter:
|
Selecting one of these references:
Note You can use only one reference as a rule in a given round of reconciling business partner journal entries. When you select one of the references as a rule, the other references are not available for the other rules in the same round. End of the note. Example You select Ref. 1 for Rule No. 1 in Round 1. In the Relate to XXX Last Characters field you specify the value 3. When you continue to Rule 2, the options Ref. 2 and Ref. 3 do not appear in the drop-down box. SAP Business One scans the manual journal entries created for a business partner, looking for a match for transaction 96 785. It finds a journal entry with the value of 4785. Since the last three characters are identical, it can be matched. End of the example. |
Select this parameter to reconcile documents and payments with identical document numbers. |
Select this parameter to reconcile documents while comparing the value set in the Name field in sales or purchasing documents with the value set in the bank statement line. Selecting this field displays the Relate to XXX Last Characters field. Specify a number to define a corresponding (lower/higher) level of accuracy of this parameter. SAP Business One checks the defined number of characters, starting from the right. Note Leaving this field empty prompts SAP Business One to look for a complete match of customer or vendor name. End of the note. |
SAP Business One uses the values defined in the Bank Code and Account No. fields in the Business Partner Bank Accounts – Setup window. To view the window, from the SAP Business One Main Menu, choose (Choose from List) next to the Bank Country field. tab, and chooseNote This match works only if both the Bank Code and the Account No. fields in the Business Partner Bank Accounts – Setup window are populated. End of the note. Note In the Netherlands, the bank code is not sent, and so it is possible to search by bank account number only. End of the note. |
Selecting this parameter prompts SAP Business One to reconcile bank statement rows with documents according to the value set in column BP IBAN of the Business Partner Details section in the bank statement, with documents posted to business partners with matching value set in the IBAN field in tab.When selected, the field Relate to XXX Last Characters appears. Specify a number to define the level of accuracy of this parameter. Lower number indicates low level of accuracy, while high number indicates high level of accuracy. SAP Business One checks the defined number of characters starting from the right. |
SAP Business One uses the values defined in the BIC/SWIFT Code and Account No. fields in the Business Partner Bank Accounts – Setup window. To view the window, from the SAP Business One Main Menu, choose (Choose from List) next to the Bank Country field. tab, and chooseNote This match works only if both the BIC/SWIFT Code and the Account No. fields in the Business Partner Bank Accounts – Setup window are populated. End of the note. Note In the Netherlands, the bank code is not sent, and so it is possible to search by bank account number only. End of the note. |
Select this parameter to reconcile documents while comparing the value in Customer Ref. No. or Vendor Ref. No. in sales and purchasing documents, with the value in the Reference field in payment documents. Selecting this field displays the Relate to XXX Last Characters field. Specify a number to define a corresponding (low/high) level of accuracy of this parameter. SAP Business One checks the defined number of characters, starting from the right. Note If you leave this field empty, SAP Business One looks for a complete match of BP reference numbers. End of the note. Example The Customer Ref. No. in A/R Invoice No. 100 is CR123456. The value set in Relate to XXX Last Characters is 1. SAP Business One looks for incoming payments whose reference number ends with the character 6. In this case, there may be many that comply with this criteria. If the value set in Relate to XXX Last Characters is 3, SAP Business One looks for all incoming payments whose reference number ends in 456. The number of incoming payments ending in 456 is much smaller than those ending in 6, raising the accuracy of this criteria. End of the example. |