Skip to Content
0
Former Member
Oct 21, 2010 at 06:27 AM

Rounding Off in Billing Plan Lines

236 Views

Dear Experts,

We have the following requirement -

In our contracts we have 3 items (Each has a validity date 01.01.2010 - 31.03.2010):

Line 10 - Regular Service Material - Periodic Billing Plan - Let us say, Periodic Value is $1000.00

Line 20 - Regular Service Material - Mile Billing Plan - Let us say, Entire contract Value is $2000.00

Line 30 - Fund Item (We created a material code called FUND) This line is identified with a WBS element- This line item also has periodic billing line line 10.

The Milestone item (20)'s net value which is 2000 has to be split among the 3 billing plan lines** of Line 30.

(**Line 30 as mentioned before is valid from 01.01.2010 - 31.03.2010 with periodic billing plan)

However the system is not splitting as expected.

The system behaviour is as follows:

2000/3 = 666.66

Billing Plan 1 (JAN 2010) - 666.67

Billing Plan 2 (FEB 2010) - 666.67

Billing Plan 3 (MAR 2010) - 666.67

Total - 2000.01

This is incorrect. Somewhere we need to adjust this 0.01 difference in any one of the billing plan lines for this item.

Is there any user exit available or a standard way to achieve this ?

Looking forward to hearing from you

Regards

Siddharth.