Add Open BP Journal Entries Window

Use this window to specify matching criteria for reconciling manual journal entries posted to business partners. 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 BP journal entries 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 BP journal entries 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 Setup 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 BP JEs.

Add Open BP Journal Entries Window Fields

Posting Date
Select this parameter to assign documents for reconciliation while considering the posting date assigned to them. 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. When this field is left blank, SAP Business One treats the value as zero. Example 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 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
Select this parameter to assign documents for reconciliation while considering the due date assigned to them. Displays the Variation in Days field, in which you specify the number of days to be considered as a valid difference within which transactions are selected for reconciliation. When this field is left blank, SAP Business One treats the value as zero. Example Variation in Days is 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 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 (in 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 in this field. Example You specified `0.5` in the Matching Difference field. SAP Business One scans the manual journal entries posted to a specific business partner, looking for a transaction to be reconciled with a 100.08 debit amount. A credit transaction of 100.7 is found, that is, a difference of 0.62. In addition, a credit transaction of 99.85, that is, a difference of 0.23, is also found. Although both transactions are proposed for internal reconciliation, as neither transaction directly matches the bank statement row amount, neither is automatically selected for internal reconciliation. End of the example.

Ref. 1, Ref. 2, Ref. 3
Select one of the references, 1 to 3, to reconcile journal entries posted to business partners, while using the value defined in the Ref. 1, Ref. 2, or Ref. 3 field in the Journal Entry window as a matching criterion. Displays the Relate to XXX First Chars. field, in which you specify a number higher than 0 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 You can use only one reference as a rule in the matching criteria. End of the note. You selected Ref. 1 for Rule 1. In the Relate to XXX First Chars. field you specified the value `3`. When you continue to Rule 2, the options Ref. 2 and Ref. 3 do not appear in the dropdown list. SAP Business One scans the manual journal entries created for a business partner, looking for a match to a transaction with a reference number of 96785. When it finds a journal entry with the value of 9674785, it considers it a match since the first 3 characters are identical.