Hi Friends,
I have two variable : i.e - for Total Collectable Amt and Total Reason Code Amt.
and Twelve Different - 12 Reason Code Amt.
i.e are following :
Reason_Land
Reason_LD Claim
Reason_Generation Claim
Reason_NOC
Reason_Projects
Reason_ROW
Reason_PE
Reason_Early RR
Reason_Others
Reason_Invoice / DCLR
Reason_RM
Reason_Fin Closure
vRCA = Sum(Reason_Land + Reason_LD Claim + Reason_Generation Claim + Reason_NOC + Reason_Projects + Reason_ROW + Reason_PE
+ Reason_Early RR + Reason_Others + Reason_Invoice / DCLR)
vCollectableAmt = Sum (Net Collectable)
Condition is :
1. If (vCollectableAmt > vRCA) and any one Reason Code Amt > 0 then replace that vCollectableAmt to that Reason Code Amt.
2. Else If Check (vCollectableAmt > vRCA) and Reason_RM_Amt = '0' and Reason_Fin_Closure_Amt = '0', then Add the difference of (vCollectableAmt - vRCA) in the behalf of max( Another 10 Reason Code Amt)
3.Else Check (vCollectableAmt > vRCA) and Reason_RM_Amt <> ' 0' and Reason_Fin_Closure_Amt <> ' 0' then Add the difference of (vCollectableAmt - vRCA) in the behalf of max( Another these two Reason_RM_Amt or Reason_Fin_Closure_Amt).
Thanks
Akumar
