SAP Knowledge Base Article - Public

3834504 - Addenda Record Indicator in record type 6 of US_ACH format shows 0 when one payment pays multiple Invoices - SAP S/4HANA Cloud Public Edition

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

  1. Open the Manage Payment Media app.
  2. Download a payment media file generated with the US_ACH standard format.
  3. 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.
  4. 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

  • KBA 3418313 - Adjusting payment format US_ACH
  • SAP Note 2820775 - Source of Information for Field in structures FPAYH-FPAYHX-FPAYP

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

Product

SAP S/4HANA Cloud Public Edition all versions