I had a similar situation in PBCS where there is very limited option. since you mentioned Script i am assuming this on On-Premise.
I have created 2 separate load for loading the Credit and Debit and it does works for us, as i said this was for PBCS.
Hi Dayalan, my target application is HFM, neither PBCS nor Planning on premise.
So, it is a little bit different approach I think.