Receipts Workbench: Wrong Amount in SEPA Pre-Notification Letter

(Doc ID 1609427.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

When running SEPA Direct Debit Batch, the pre-notification letters are printed with the wrong receipt amount and total.
The receipt amount for each in the pre-notification relates to the batch total not the invoice amount.

The format is good if the receipt grouping is one receipt / invoice but you will collect 50 invoices for a single customer in one procedure, so you do not want to create 50 receipts and 50 pre-notification letters.

This occurs when a receipt has paid more that one invoice.

Example:
Pre Notification Letter

Bank account number 0000062663Q with VIDAL VGES LCL_30002 will be charged through direct debit for the amount EUR 2106.92 on 24 July 2013 towards following transactions

Transaction Number Amount Receipt Amount

100211588198 142.08 1053.46
100211585629 911.38 1053.46

Total 2106.92

Steps to Reproduce
Enter three (3) invoices for a SEPA Direct Debit customer (cutomer must have a SEPA bank account, a valid mandate authorization and the flag print pre-notification letter set to yes).
ex. 100 and 150 euros 200 with an immediate due date
(all invoices entered on the same customer) validate your invoices
Run Receipts > Batches (for an Automatic Batch Type) choose an automatic receipt method when you have "Direct Debit Pre-Notification Letter" as automatic print program

Pre-notification letter should have a total amount of 450 euro.  In this case, it is (450 * 3).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms