Symptom
The 'To Bill' value differs by 0.01 between two similar entries, even though both have the same net rate and quantity in the app 'Manage Project Billing'.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Create a customer project with work packages and record time for it.
- Open the Manage Project Billing app, click on Prepare Billing against a Time and Expense Billing element.
- There are multiple time postings posted by the same resource (for example, several items with 0.5 hours) sharing the same hourly rate (for example, 148.75 EUR per hour).
- Review the To Bill for the time entries and notice a difference of 0.01 between two entries.
Cause
This is a standard behaviour. The application calculates the net amount at an aggregated level using two decimal places and then distributes this total back to individual postings; the rounding difference is allocated across items so the sum of item amounts equals the aggregated total.
Resolution
To explain the calculation of why there is a difference of 0.01 between two similar entries.
- Consider that a user has recorded 2 time entries, each time entry with a quantity of 0.5 hour. And for our example consider the net rate maintained as 148.75 EUR/per hour.
- So there are 2 postings each for 0.5 hour. The aggregated total quantity is 1 hours.
- The net rate 148.75 EUR/1H is applied to the aggregated quantity of 1 hour 148.75 * 1 = 148.75 EUR (only two decimal places are supported).
- When Project Billing receives the aggregated amount of 148.75 EUR, this amount needs to be distributed back to the 2 individual postings of 0.5H each.
- For each 0.5 hour posting, this results in 148.75*0.5 = 74.375 EUR, which rounds off to 74.37 EUR. However, if 74.37 EUR were assigned to all 2 postings, the total would be 74.37 * 2 = 148.74 EUR and would be 0.01 EUR lower than the calculated aggregated amount of 148.75 EUR.
- Therefore, the 0.01 EUR rounding difference is distributed between two postings, resulting in one posting being 74.38 EUR and the other one 74.37 EUR. This is expected behavior to ensure consistency between item sums and the aggregated billing amount.
See Also
SAP Community - Understand and influence data preparation behind Project Billing in SAP S/4HANA Cloud Public Edition.
Keywords
Project billing, Manage Project Billing, rounding difference, Difference of 0.01 between entries, To Bill, SAP S/4HANA Cloud Public Edition, To Bill value differs, Time and Expense entries, PPM-SCL-BIL, PPM-SCL-BIL-FIO, CA-TS-S4. , KBA , PPM-SCL-BIL , Project Billing (Public Cloud) , PPM-SCL-BIL-FIO , Fiori UI for Project Billing (Public Cloud) , CA-TS-S4 , Cross Application Timesheet in S/4HANA , Problem
SAP Knowledge Base Article - Public