SAP Knowledge Base Article - Public

3731931 - Separate retention amount as distinct line item in manage customer line items for customer invoices

Symptom

  • Clarification is required on handling retention Amount in customer invoices.
  • The business needs to identify the retention amount separately in the "Manage Customer Line Items" as Special G/L or normal line item.
  • The retention amount using a pricing/condition type in SD billing cannot be posted as a separate customer account line item.

"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. Create a customer invoice with a retention amount determined in SD billing (for example, via a retention condition type).
  2. Post the billing document to Accounting.
  3. Open the Manage Customer Line Items app and review the posted items for the customer.
  4. Observe that the retention is not available as a separate customer line item (or is posted to a non-customer G/L), preventing dedicated tracking in customer line items.

Cause

  • The retention is configured to credit the customer reconciliation account while the customer account is also debited for the full invoice during SD billing posting. This design causes a logical discrepancy. Retention postings should use a separate G/L account that is not a reconciliation account and should not credit the customer account in the SD billing posting.

Resolution

  1. Maintain a separate G/L account (non-reconciliation) for sales retention and assign the appropriate posting key for retention so that retention is not credited to the customer reconciliation account during SD billing posting.
  2. Post the retention amount separately using the Create Outgoing Invoices app (Accounts Receivable) to record the retention on the designated retention G/L. This ensures retention is managed independently from the original invoice. Process is explained in the attachment.
  3. Verify the postings in the Manage Customer Line Items and related reports to confirm that:
  • The original invoice is posted as one customer line item.
  • The retention amount is posted as a separate, traceable line item (per the chosen accounting design).

Keywords

retention, customer invoice, manage customer line items, separate line item, special gl, spl, sd billing, reconciliation account, retention gl, posting key, create outgoing invoices, ar posting, s/4hana public cloud, retention condition, invoice posting , KBA , FI-FIO-AR-IS-2CL , Reporting Apps: Public Cloud , Problem

Product

SAP S/4HANA Cloud Public Edition all versions

Attachments

Posting Retention amount using FB70.docx