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:
- Select a billing element with the Time and Expenses or Usage-Based billing method and choose Prepare Billing.
- Click the Edit button.
- Change the needed values in the "Amount to Write Off/Postpone" or "Quantity to Write Off/Postpone" columns.
- Click the Save button.
- 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)
- 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
Attachments
Pasted image.png |