Add Open Documents Window

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 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.

End of the note.

Note 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.

End of the note.

To open this window:

From the SAP Business One Main Menu, choose Banking Bank Statements and External Reconciliations Bank Statement Processing Bank Statement Summary Bank Statement Details .
Double-click a row number whose posting method is Business Partner from/to Bank Account.
Choose Add Open Documents.

Add Open Documents Window Fields

Doc Type
Select a document type from the dropdown list: All A/R Down Payments A/R Invoices A/R Credit Memos A/P Down Payments A/P Invoices A/P Credit Memos

Posting Date
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.

Due Date
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.

Balance Amount
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.

Document Number
Select this parameter to assign documents for reconciliation with payments with identical document numbers.

Customer/Vendor Name
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.

BP Bank Code + Account
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 Business Partners Business Partner Master Data Payment Terms tab, and click (Choose From List) next to the Bank Country field. Note 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.

IBAN
SAP Business One selects documents for reconciliation to bank statement rows according to: Value set in the BP IBAN column under the Business Partner Details section in the Bank Statement Details window Matching value set in the IBAN field on the Payment Terms tab of the Business Partner Master Data window. This applies to documents posted to business partners. 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.

Discounted Balance Amount
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.

BP Reference No.
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.