Milestone Billing Plan Change after First Milestone

[former_member1230642]

Hi All

We are trying to implement milestone billing functionality for a Rental Service client which rents its space for Exhibitions. They have a Billing plan created for each customer. For E.g. If ABC Customer is renting its space on some XX/YY/ZZZZ date then they collect 100 percent advance in some 3-4 installements prior to the exhibition date. The amount is collected on the basis of the the total amount of area rented (they have rate of some 267 per sq mt).We have suggested to use milestone billing plan for the same wherein they can enter total area required in the sales order and the then create proforma invoices for the customer downpayment based on the milestones(30%,40%, 30%). Now here is the catch

For e.g One customer ABC requires a total of 100 sq mt of area by some 20/01/2020 and we have milestones set accordingly. Total amount to be billed 26700 (considering 267 per sq mt rate)

16/04/2019: 30% = 8010

20/06/2019: 40% = 10680

30/11/2019: 30% = 8010

I created first Proforma Invoice on 16/04 and accordingly receive 8010 from customer. Now the same line is grayed out in the header billing plan. Now the customer asks client for change in total area required due to some changes in their internal event plannings. For e.g now he requires total area of 200 sqmt now(increase of 100). So total quantity to be billed now would be 267*200 = 53400. Now if u check the billing plan the plan would be

16/04/2019: 30% = 8010 (It wont change and is grayed out as it is already billed(downpayment))

20/06/2019: 40% = 21360 ( It calculated on total 53400 and not on the (53400-8010) )

30/11/2019 : 30 % = 16020 (It calculated on total 53400 and not on the (53400-8010))

Total of this three = 8010+21360+16020= 45390

Difference of 53400 - 45390 = 8010

Can somebody plz help me in resolving this problem in SAP ?

[former_member609580]

Hi Prathamesh,

Once you changed the quantity in sales order net value is updated accordingly,for the difference amount add new line item in billing plan tab system will not propose any error.Instead of using % in billing relevance use 2(Milestone based on value basis) for the new line item in sales order billing plan tab.

Regards,

Sangeetha Shanmugam