Show TOC

Object documentationManage Previous Internal Reconciliations Window Locate this document in the navigation structure

 

This window lists the previous internal reconciliations that match the selection criteria you specified in the Manage Previous Internal Reconciliations – Selection Criteria window.

This window has two sections:

  • Reconciliation History – lists the previous reconciliations.

  • Reconciliation Details – lists the transaction rows associated with the selected reconciliation from the Reconciliation History section

Reconciliation History
Recon. No.

The reconciliation number assigned to the internal reconciliation by SAP Business One when the reconciliation took place.

Recon. Amount

The total amount of the reconciliation.

Recon. Type

Indicates the type of reconciliation, based on whether the reconciliation is a result of document creation or user initiation:

  • Deposit - Reconciliation is the result of creating a deposit document for check(s), cash, credit card voucher(s), or bill(s) of exchange.

  • Automatic - Reconciliation was performed by selecting the Automatic option in the BP Internal Reconciliation – Selection Criteria window.

  • Bank Statement Processing - Reconciliation was performed by the bank statement processing functionality, according to the user-defined matching rules.

  • Cancellation - Reconciliation was cancelled by using the Cancel Reconciliation button in this window.

  • Payment - Reconciliation is the result of creating an incoming or outgoing payment for specific documents/transactions.

  • Credit Memo Reconciliation is the result of copying an A/P or A/R invoice to an A/P or A/R credit memo.

  • Manual - Reconciliation was performed manually.

  • Semi-Automatic - Reconciliation was performed by selecting a transaction from the Reconciliation recommendations window that opens if you selected the Semi-Automatic option in the BP Internal Reconciliation - Selection Criteria window.

  • Period Closing - Reconciliation was automatically performed when a period-end closing adjustment was created at the year end.

Reconciliation Date

The date on which reconciliation took place. For manual reconciliation, this is the date specified in the Reconciliation Date field in the Internal Reconciliation window. For reconciliations resulting from document creation (payments, credit memos), the reconciliation date is the posting date of the latest document to be included in the reconciliation.

Example Example

An incoming payment is created for two different A/R invoices that were created a week ago and two days ago. The posting date of the incoming payment is the current date. This is considered as the reconciliation date in this case.

End of the example.
Canceling/Cancelled Reconciliation Number

If reconciliation is the result of cancelling a former reconciliation and then re-reconciling, the number of the former reconciliation is displayed.

Reconciliation Details
Origin

Indicates the document or transaction type that initiated the posting of each transaction. For example, IN represents a transaction resulting from the creation of an A/R invoice. For a complete list of origins, see XX in the online help.

Origin No.

The number of the document that initiated the creation of the transaction, for example, the number of the A/R invoice.

G/L Acct/BP Code

The code of the G/L account or business partner to which the reconciled transaction row was posted.

Ref. 1

The value in the field Ref. 1 in the reconciled transaction.

Due Date

The due date specified in the reconciled transaction row.

Amount

The original amount of the reconciled transaction row. Amounts in brackets reflect negative amounts. If the option Display Credit Balance with Negative Sign is selected in Administration   System Initialization  Company Details  Basic Initialization tab   amounts in brackets represent credit amounts.

Applied Amount

The amount from the transaction row that was reconciled in this reconciliation. When the applied amount is different from the value displayed in the Amount field, it indicates that the transaction row is partially reconciled by this reconciliation.

Cancel Reconciliation

Choose to cancel the marked reconciliation. You cancel one reconciliation at a time.

Note Note

Reconciliations resulting from the following scenarios can not be cancelled, and therefore when marking such reconciliation, the Cancel Reconciliation button is disabled:

  • Creating incoming or outgoing payments for specific transactions.

  • Creating A/P or A/R credit memo based on existing document.

  • Reversing transaction by using the Reverse option in the Journal Entry window.

  • Cancelling transaction by using the Cancel option in Data menu.

End of the note.

For more information see Cancelling Reconciliations in the online help.