Avoid Reimporting Payments

Payment Management uses the payment reference id to avoid reimporting the same payments multiple times. However, in rare situations, you may experience the same payment being imported more than one time into Business Central. The following examples may lead to reimport of payments:

  • When using manual communication, the bank file does not necessarily contain a unique reference ID. In such cases, Payment Management cannot determine whether the file has already been imported.
  • When using direct communication, the same file can be called multiple times, in which case the file will get a new reference ID for each call.
  • When a payment line has been created manually in the payment journal, and manually settled with the invoice.

In the event that a payment line is created more than once in the payment journal, the payment cannot be applied to the invoice, as a previous payment line has already been applied to the invoice. In this case, you will receive an error message at the bottom of the cash receipt journal, notifying you that the associated invoice has already been applied to another payment, and then posted.

To delete a duplicate payment line and avoid reimport

  1. Use the Search for page or report icon and search for Cash Receipt Journals, then select the related link.
  2. Open the relevant journal.
  3. Select the payment line that you want to eliminate for reimport.
  4. In the action bar, select Related > Delete and set as imported.

The selected line will now be deleted from the cash receipt journal and the corresponding line in Bank Export Data will be marked as Imported to Company, indicating that it cannot be imported again.