Service Tax

We have following requirement for internal process in oracle EBS, pls suggest the way it can be achieved. We are thinking using mass allocation to transfer the same on montly basis by incremental method . Request your guidance and advice to achive this using  available features.

 

1.       Finance will continue to enter the  receipts in AR which would either be applied Unapplied or Unidentified. Here we will consider only Unapplied and Unidentified receipts balance only.

2.       Upon entering of  receipts, on monthly basis outstanding balance in Unidentified and Unapplied receipts accounts would be considered.

 

3.       Based on the receipts dates system will accumulate and create monthly Journal Voucher which would Credit (Cr) Service Tax final Liability account and Debit (Dr) Unapplied and Unidentified Accounts. If the receipts date(s) is before 31-MAR-2012 then separate journal voucher for those amounts and above accounts would be created in the system.