Accounting Value - Split Up

Hi,

We have requirement like, While booking the expenses in Payables Department  wise system should automatically allocate the expenses as predefined.

Example :

Expenses value : 100,000

Nature Of Account : Electricity Charges

Department  : 00 - General

                       01 - Admin

                       02 - IT

                       03 - Accounts

Enter the expenses in AP Invoice Distribution is : 00 (General) - 40001 (Electricity Charges)

Expected is :

01 (Admin)       - 40001 (Electricity Charges)  - 50,000 (50%)

02 (IT)              - 40001 (Electricity Charges)  - 25,000 (25%)

03 (Accounts)  - 40001 (Electricity Charges)  - 25,000 (25%)

How to achieve this requirement..? Can you please guide on this.

Regards

Kumar