Please help me on customer retention process.

[dileepkurupk]

Hi Experts,

Please help me on customer retention process.

My scenario is as follows:-

Customer will pay 90% of invoice amount and 10% will pay once the project finished. It also includes VAT/Tax amount.

For example:

Total Invoice amount = 1050 (Sale Revenue 1000 + VAT 50). But the customer will pay 945 (1000*90% + VAT 5%) and the remaining 105 (100+VAT) will pay after project completion.

Accounting entries (Invoice) are

Customer A/C Dr 945 (900+45)

Retention A/C Dr 105 (100+5)

Sales Revenue A/C Cr 1000

Output VAT A/C Cr 50

Accounting entries (Customer Payment) are

Bank A/C Dr 945 (900+45)

Customer A/C Cr 945 (900+45)

Accounting entries (Customer Retention Payment) are

Bank A/C Dr 105 (100+5)

Retention A/C Cr 105 (100+5)

I would like to track VAT amount (collected and pending), customer amount (collected + VAT amount), Retention amount (pending + VAT amount) etc. Do I need to activate the document splitting to track the details?

Please help me, how to carry out customer retention process in SAP System with system generated accounting entries.

Thanks & Regards,

Dileep