SAP Knowledge Base Article - Public

3419951 - Incorrect Amount calculated for Invoice Schedule in Contracts

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

  1. Work center: Sales Orders.
  2. View: Contracts
  3. Show: All Contracts
  4. Search for contract ID XXX(XXX is the ID of the affected Product)
  5. Go to Items tab, you have maintained the List price as 1000 USD per month
  6. Now to Pricing and Invoicing tab
  7. Under Invoice Schedule sub-tab, add the quantity as 10 days. 
  8. 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

Product

SAP Business ByDesign all versions