SAP Knowledge Base Article - Public

3395612 - Error "Sum of To be Postponed, To be Billed, To be Written-off Qty Should not exceed Open Qty" while creating Billing Document Request - S/4HANA Cloud

Symptom

During BDR creation, end-user is encountering an error "Sum of To be Postponed, To be Billed, To be Written-off Qty Should not exceed Open Qty", when setting up 'Write off' and 'Postpone' fields.

"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

Reproducing the Issue

  • Go to Manage Project Billing App
  • Search for Project, and filter on Journal Entry
  • Input desired amount towards for "Write off" and for "Postpone"
  • Try to save
  • System throws error message

Cause

The amounts entered are not determined correctly as they are exceeding the rates in the calculating formula.

Please check the sum of quantities ('To be Postponed', 'To be Billed', 'To be Written-off') as they cannot exceed the amount in 'Open Qty'.

Resolution

In order to write off/postpone a partial billing amount:

  1. Select a billing element with the Time and Expenses or Usage-Based billing method and choose Prepare Billing.
  2. Click the Edit button.
  3. Change the needed values in the "Amount to Write Off/Postpone" or "Quantity to Write Off/Postpone" columns.
  4. Click the Save button.
  5. After changes applied, click the Submit button.

The To Bill amount of the billing element, seen in the header section of the Prepare Billing page, gets updated with the new amount calculated as follows:

For postponing:

  • To Bill (after postponing) = To Bill (before postponing) - Amount postponed
    Where:
        • Amount postponed = (Sum of (Quantity to Postpone * Sales Rate) for those items where Quantity to Postpone is not 0) + (Sum of Amount to Postpone for those items where Quantity to Postpone is 0)

Same applies for write off:

  • To Bill (after write off) = To Bill (before write-off) - Amount written off
    Where:
        • Amount written off = (Sum of (Quantity to Write Off * Sales Rate) for those items where Quantity to Write Off is not 0) + (Sum of Amount to Write Off for those items where Quantity to Write Off is 0)

See this example for reference.

Please be sure that the calculation for both formulas applied correctly, and the amounts in each section are not incompatible with each other. 

See Also

Keywords

BDR, Billing Document Request, Write off, postpone, manage project billing, quantity, to bill, formula , KBA , SD-BIL-IV-2CL , Processing Billing Documents (Public Cloud) , PPM-SCL-BIL , Project Billing (Public Cloud) , Problem

Product

SAP S/4HANA Cloud 2308

Attachments

Pasted image.png