Use this window to specify matching criteria for selecting sales and purchasing documents for manual reconciliation with their respective payments. You can set a combination of up to three rules. Each rule can consider one of the parameters described below.
Note
Each parameter can be used for only one rule. Once you assign a parameter to a rule, it is removed from the dropdown lists of the other rules.
Note
SAP Business One adds open documents with posting dates that are earlier than or the same as the posting date of the bank statement row in the Bank Statement Details window. If the Posting Date field of the bank statement row is empty, SAP Business One adds open documents with posting dates that are earlier than or the same as the current system date.
To open this window:
From the SAP Business One Main Menu, choose
.Double-click a row number whose posting method is Business Partner from/to Bank Account.
Choose Add Open Documents.
Select a document type from the dropdown list:
|
Selects a document if its due date is within a specified number of days of the bank statement row. Displays the Variation in Days field, in which you specify the number of days to be considered as a legitimate difference within which transactions are selected for reconciliation. If Posting Date is blank, the Variation in Days field is set to zero. Example Variation in Days is defined as 3. The posting date of a specific invoice is 01.05.2007. There is a payment for the exact amount with a posting date of 06.05.2007. Because the difference is 5 days, the invoice is not selected for reconciliation. End of the example. |
Selects a document if its due date is within a specified number of days of the bank statement row. Displays the Variation in Days field, in which you specify the number of days to be considered as a legitimate difference within which transactions are selected for reconciliation. If Due Date is blank, the Variation in Days field is set to zero. Example Variation in Days is defined as 3. The due date of a specific invoice is 01.05.2007. There is a payment for the exact amount with a due date of 03.05.2007. Because the difference is 2 days, the invoice is selected for reconciliation. End of the example. |
Select this parameter to assign documents for reconciliation according to their total amounts. Displays the Matching Difference field, in which you specify the maximum variance in amounts (local currency) that should be tolerated by SAP Business One. If the variance between amounts is greater than the value specified, these amounts are not selected for reconciliation. To increase the degree of accuracy of the reconciliation, define a low value. Amount matching is always against the amount specified in the bank statement row and never against the amounts specified in the Multiple Payments window. |
Select this parameter to assign documents for reconciliation with payments with identical document numbers. |
Select this parameter to assign documents for reconciliation while comparing the value set in the Name field in sales or purchasing documents with the value set in the bank statement row in the BP Name field. Displays the Relate to XXX First Chars field, in which you specify a number to define the level of accuracy of this parameter. The lower the number, the lower the level of accuracy, and vice versa. SAP Business One checks the defined number of characters starting from the left. Note If you leave this field blank, SAP Business One looks for a complete match of the 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 clickNote This match only works if both the Bank Code and Account No. fields in the Business Partner Bank Accounts – Setup are populated. End of the note. Note In the Netherlands, the bank code is not sent, so you can only search by bank account number . End of the note. |
SAP Business One selects documents for reconciliation to bank statement rows according to:
Displays the Relate to XXX First Chars. field, in which you specify a number to define the level of accuracy of this parameter. The lower the number, the lower the level of accuracy, and vice versa. SAP Business One checks the defined number of characters starting from the left. |
Select this parameter to assign documents for reconciliation according to their discount amounts. Displays the Matching Difference field, in which you specify the maximum variance in amounts (local currency) that should be tolerated by SAP Business One. If the variance between amounts is greater than the value specified, these amounts are not selected for reconciliation. To increase the degree of accuracy of the reconciliation, define a low value. |
Lets you assign documents for reconciliation while comparing the value set in the Customer Ref. No. or Vendor Ref. No. field in sales and purchasing documents with the value set in the Reference field in payment documents. Displays the Relate to XXX First Chars. field, in which you specify a number to define the level of accuracy of this parameter. The lower the number, the lower the level of accuracy, and vice versa. SAP Business One checks the defined number of characters starting from the left. If the field is left blank, SAP Business One looks for a complete match of business partner reference numbers. Example The Customer Ref. No. in A/R Invoice No. 100 is CR123456. The value set in Relate to XXX First Chars. is 1. SAP Business One looks for incoming payments with reference numbers that begin with the character C. There may be many incoming payments that comply with this criterion. If the value set in Relate to XXX First Chars. is 3, SAP Business One searches for all incoming payments with a reference number that begins with CR1. The quantity of incoming payments that begin with CR1 is much smaller than the quantity of incoming payments that begin with C. This is why the higher the value set in this field, the greater the accuracy of this criterion. End of the example. |