Milestone Billing

[former_member657193]

I have created one Milestone billing and defined four stages, as Advance received , Project stage 1 , Project Stage 2 and final Settlement. For the Advance payment i am using FAZ as the document type and for the rest of the stages i am using F1 as the billing document as this is order-rel-Billing.

NOw when i am creating a billing for Advance say 10 % of the total value i am able to create the down payment Invoice FAZ.

Now when i am creating a INVOICE F1 for the project stage 1 60 % , the system is picking up the total value of the order which is 561,800. Infact this total value has been broken into two parts, 60 % and 40 %

which is 337,080 and 227,720.

Also i want to know what will happen for the final settlement invoice as this is the fourth stage for which i don't have any percentage defined

it like

Stage % Doc type Total value ---561,800

Advance 10 % FAZ 56180

Project St 1 60% F1 337,080

Project st 2 40 % F1 227,720

Final Settlement F1 No values

Plz Help as why the system is creating invoice with full value of the order for Project st 1 that is 561800

and how the Advace payment will be settled against the Final sttlement.

Also let me know whether while creating the individual invoice for each can i change the value of the invoice.

Cheers

[former_member657193]

thnx

[Former Member]

Dear Rishi,

Just a query:

Is your pecentage gonna calculate, always on base value, i.e. 561800 or its reducing?

I mean, is it like:

Case 1:

Advance - 10 % * 561800 = 56180

Stage1 - 60% * 561800 = 337080

Stage 2 - 40% * 561800 = 224720

Final Settlement - Against Advance + Variable (+/-) as Returns/ Credit/ Debit, if any

Or,

Case2:

Advance - 10% * 561800 = 56180

Stage 1 - 60% * 505620 = 303372

Stage 2 - 40% * 202248 = 80899

Final Settlement - remaining Ammt. i.e. 121350 (+/- any returns/ order cancellation/ credit/ debit etc..)

Best Regards,

Amit.

Note: Also, how have you define your Qunatity for each line-item?

Suggestion: If, this is Case 1, then

Take Advance as Direct FI-entry of 56180 (in to Customer Account)

For Stage 1 & Stage 2; create a sales order with two line items, i.e.

item no.--MaterialQty-UoM--Rate--

---

Total

10--

---

Stage 10.6-EA

---

561800--337080

20--

---

Stage 20.4--EA---561800--224720

And Advance of 56180 will get settled via FI, directly.

More inputs, could be provided, once scenerio is more clear.