Hi,
I am trying to cumulate balances in SALDO table (Time Evaluation). Currently using PT_BAL00 for displaying cumulated balances of time types. It works fine for the first semi-monthly pay period like 01/01/2010-01/15/2010. But when I run cumulated balances for second semi-monthly pay period, I get the cumulated balances of entire 01/01/2010-01/31/2010.
I tried creating custom rule by setting monthly balances of time types to zero on the first day of every payperiod. Now the issue is when I run for 01/0/12010-01/15/2010, it works fine. But when I run 01/16/2010-01/31/2010, the cumulated balance for 01/01/2010-01/15/2010 becomes same as that of 01/16/2010-01/31/2010.
Is there any way to make saldo table cumulate on semi-monthly basis?
Thanks for help and time in advance