Showing results for 
Search instead for 
Did you mean: 

Project Billing- Retention money due after project end

Former Member
0 Kudos


We have PS, FI and SD integration. We have different contract for projects, which we are handling through PS.

We are doing billing for the contract project each month. Project duration is long and each month we are doing billing to customer.

We require that in each billing some part is belongs to retention---which is kept by customer from each bill and that will be payable by customer only after project end.

So when doing billing each month retention amount should be separate line item for each billing and due date for that retention should be the date after project end date. Bcz customer will release the all retention amount together only after project end.

If I take one example for the scenario:.........

Total Project Revenue (Contract Amount) 36000

Duration for Project : 36 month

Billing to Each Month : 1000

Retention = 10% from each billing (Due after project end)

Payment term : 90% due immediately, 10% retention due after project end date (means after 36 month)

When I am doing 1st month billing and maintain payment term as installment (90%+10%) than for this month system create two line item for billing i. e 900 (90%) due immediately and 100 (10%) due after 36 month.

When I will do 2nd month billing system again create two line item i.e. 900(90%) due immediately and 100(10%) due after 36 month........means this 10% will be due after 36 month from the date of billing.

I am doing billing in 2nd month so retention for 2nd billing will be due 1 month after the project end date......same will be continue for 3rd 4th.......36th month billing and retention amount will be due after 36 month from the billing date.

But for project related billing my all retention should be due on same date, which is project end date.

How to do this.....Please reply.



Edited by: Bharat Gadkar on Nov 22, 2008 10:24 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


You can define an instalment payment term with 90% & 10%. You can assign different payment terms for these two items so that the payment date can be met according to your requirements. so make your payment date requirements in the payment terms and assign the same to the instalments.