Symptom
- Payment medium file generated with US_ACH: In some lines, the Addenda Record Indicator in record type 6 displays as 0, and record type 7 does not exist when the Addenda Record Indicator is 0.
- Other lines show the Addenda Record Indicator in record type 6 as 1, and record type 7 exists when the Addenda Record Indicator is 1.
- In the payment run details, the Addenda Record Indicator in record type 6 shows as 0 when one payment includes multiple invoices.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Manage Payment Media app.
- Download a payment media file generated with the US_ACH standard format.
- Review record type 6 lines and observe that in some lines, the Addenda Record Indicator in record type 6 displays as 0, and record type 7 does not exist. Record type 7 line only exists when the Addenda Record Indicator is 1.
- Check payment run details in Manage Automatic Payments app, the Addenda Record Indicator in record type 6 shows as 0 when one payment includes multiple invoices.
Cause
This is the standard behavior in the US_ACH format. In US_ACH format, the parameter addenda record indicator contains the number of lines of the note-to-payee for each payment. By definition, the US_ACH format allows a maximum of 1 line (a record line starting with '7') per payment.
- If a payment clears one invoice, the system creates one note-to-payee line with the most important data, such as the amount and invoice number. In that case, the system sets the value of addenda record indicator to '1'.
- If a payment clears several invoices, there is not enough space to put all the information from the cleared invoices into a single note-to-payee line. Therefore, the system skips the note-to-payee line completely, resulting in zero lines of note-to-payee (lines with record type '7') for that payment. Hence, addenda record indicator = '0'.
Resolution
It is standard behavior of US_ACH format that for multi-invoice payments, the addenda record indicator is 0. The US_ACH format does not use the DME engine; therefore, it cannot be edited via Map Format Data for Payments, as mentioned in this KBA 3418313 - Adjusting payment format US_ACH.
If a different output is required, the workaround is to copy the standard US_ACH_DD format into a custom format under configuration ID 100558 (Map Format Data for Payments) and adjust it to meet the bank's requirements. In the standard US_ACH_DD format, the addenda record indicator is set to 1 when the number of items in the payment is greater than zero. Consequently, whether a payment clears a single invoice or multiple invoices, the addenda record indicator is set to 1 in both cases.
See Also
Keywords
US_ACH, ACH CCD, addenda record indicator, record type 6, record type 7, CCD10, note-to-payee, FI_PAYMEDIUM_ACH_30, DMEEX, US_ACH_DD, payment medium, NACHA, multi-invoice payments, payment file, addenda indicator, public cloud, FPAYHX, REF04, 0, 1, 100558, Map Format Data, payments. , KBA , FI-BL-PT-US-2CL , US-bank statement/lockbox (Public Cloud) , Problem
SAP Knowledge Base Article - Public