Symptom
Incorrect calculation for Invoice Schedule when specify the List price per unit in months and enter the Invoice schedule date in days. For example, you have set the List price for item as 1000 USD per month and Invoice schedule you add a date for 10 days, calculated amount is not as expected.
Environment
SAP Business Bydesign
Reproducing the Issue
- Work center: Sales Orders.
- View: Contracts
- Show: All Contracts
- Search for contract ID XXX(XXX is the ID of the affected Product)
- Go to Items tab, you have maintained the List price as 1000 USD per month
- Now to Pricing and Invoicing tab
- Under Invoice Schedule sub-tab, add the quantity as 10 days.
- The amount calculated for 10 days is not the expected amount.
Cause
The calculation is as below:
So the Amount for 1 month is 1000 USD
Amount for 1 day 1000/30.436875=32.8548840
Amount for 10 days: 328.5488408386209,
Rounded off to 2 decimal value would be 328.55
The reason being the months do not have always the same quantity of days. Also, the conversion between days and months is a known conversion and is not necessary to maintain this conversion in the master data.
This is a business decision to have the definition of 1 month = 30,436875 days. This is based on the Gregorian calendar, where a month length is defined as 30.436875 days.
Resolution
This is expected system behavior. In order to make number of days an integer (30 or 31 days), you will have to manually edit the data in the UoM field in the business document.
Keywords
Contract; Month; Days; Calculation , KBA , AP-SLO-SO , Sales Order , Problem