Delete Remittances for SEPA Direct Debit

In the SEPA Direct Debiting process, remittance proposals are created in 'Bank Remittance. Open' (ARS300), and once confirmed, are transferred to (ARS350).

The remittances must remain in (ARS350) to make it possible for the user to reverse the remittance of a specific invoice at a later stage if the customer decides not to accept direct debiting withdrawal of the invoice.

When the remittance is no longer used and it is certain that a remittance, or one of its payments, will never need to be reversed, the remittances must be deleted and closed for reversal.

This document explains how to delete and close these SEPA remittances.

Where the payment transaction associated with the SEPA remittance requires to be reversed, the existing process for reversing and deleting remittances should be followed as defined in Reconcile Payments for Customer Invoices through Direct Debiting and Factoring.

Outcome

Remittances are closed and no longer displayed in 'Bank Remittance. Open' (ARS300) or 'Bank Remittance. Reconcile Payment' (ARS350).

Restrictions

The functionality for selection and deletion of remittances in (ARS350) is only available for SEPA Direct Debiting. When the selection is made using F17 in (ARS350/S), remittances are only returned for selection if:

  1. The remittance concerns a payment type connected to payment class 5 (Direct Debiting) and defined for SEPA Direct Debiting in 'Payment Type. Open' (CRS078).

  2. The remittance is in status 09, indicating that the remittance proposal has been confirmed in (ARS300).

Before you start

  1. When a remittance proposal is created in (ARS301/F) for SEPA Direct Debiting, the parameter 'Only SEPA payments' must be ticked. These invoices are blocked for reminders and interest invoicing and updated with remittance status 15.

  2. When a remittance proposal is confirmed in (ARS300), the parameter for electronic confirmation in (ARS300/E) must not be ticked. This ensures that the invoices included are updated as paid and displayed in (ARS350) as status 09.

Follow these steps

  1. Open (ARS350) and use function key F17 to return (ARS350/S).

  2. Select the remittances to be deleted. It is mandatory to select at least one payment type with other fields left blank if required. It is however recommended to narrow down the selection further by selecting a range of remittance numbers, bank account identities, currencies and/or remittance dates.

    1. If all payment type fields are left blank a message will be returned to say that 'payment type must be entered'.

    2. As this functionality is only available for SEPA Direct Debiting, it is only possible to select a payment type that is used for this purpose. If a payment type is selected that is connected to a payment class other than 5 = 'Direct Debiting' a message will be returned to say that 'the payment type belongs to an invalid payment class'.

    3. If a payment type is selected that is used for Direct Debiting, but not defined for SEPA Direct Debiting (field SDDS set to value 1, 2 or 3) in 'Payment Type. Open' (CRS078), a message will be returned to say that 'this payment is not a SEPA type'

  3. Selected remittances are then returned in (ARS350/B).

  4. These options are then available:

    1. Cancel out of the selection by choosing 'End the selection'. This clears the selection and all remittances will once again be listed in (ARS350/B).

    2. Delete selected remittances individually by selecting related option 20 'Delete remittance proposal' against one or many highlighted remittances. For each remittance, a warning message must be accepted before it is deleted.

    3. Delete all selected remittances by choosing 'Delete all selected'. After acceptance of a warning message, the selection will be deleted in batches of 33 remittances. Where the list of selected remittances contains more than 33 records, follow these instructions:

      Click 'Delete all selected'.

      Refresh the screen.

      Click 'Delete all selected' again.

      Repeat until all the selected remittances in (ARS350/B) are deleted.

  5. All invoices associated with the deleted remittances remain fully paid and can be viewed in 'Customer Invoice. Display Separate' (ARS215).

How the system is affected

If the warning message is confirmed, the selected remittances are deleted from tables FARREM and FARRED in this order:

  1. The record in table FARREM is read first.

  2. For each record in table FARREM all related records in table FARRED are read and deleted.

  3. Finally, the record in table FARREM is deleted.

  4. The next record in table FARREM is read and the steps are repeated until all the selected remittances have been deleted.

Note

Minimal reverse time frame for SEPA Direct Debiting is not considered. The user must decide whether the remittance can be removed or not.

Related topics