cancel
Showing results for 
Search instead for 
Did you mean: 

Opening and Closing balance of a leave

sami_ullah2
Participant
0 Kudos

Hi Professionals,

My client have 3 types of Leaves, that is, Medical, Casual and Annual for which the quota is granted at the start of the year for Medical and Casual Leave while Annual Leave quota is granted at the end of the year. Client requirement is to develop a report which shows the opening balance of quota for the start of the month and closing balance at the end of the month. Is there any standard report available other than PT_QTA10 as it donot fulfill the requirement. Can this report be developed through a query?

thank you

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I think Remi has given an easy solution to fetch the quota balance at the end of the period by a time type or a time wage type. The report to fetch the balance stored in the time type or time wage type is PT_BAL00

.You can try to write a rule as mentioned below. The rule states that for quota type 02, the balance at the end of the period is pushed to Time WT 9602. In Time Schema use function P2006 to call the rule

ZT10 Get end of pay period Quota Balances
*
****
OUTAQTYP Quota type
**
02
HRS=FR Set
ADDZLM9602 Add to ZL, IFTYP M

Thanks and regards,

Victor

sami_ullah2
Participant
0 Kudos

Hi Victor,

Thanks for sharing the solution. I would appreciate if you please tell me the step by step procedure.

Thank you

former_member193210
Active Contributor
0 Kudos

Have you tought of creating a pcr that would be activated only on the first day of the month to read the Quota Balance and generate an Information Time Type (Quota X - Start) that would be stored in table ZES (or ZL), and a similar one that would generate a different Information Time Type (Quota X - End) but only on the last day of the month?

It would then be easy to make queries on these Time Types and their values.

sikindar_a
Active Contributor
0 Kudos

In Jan month every year we will entitle Casual and Annual Quotas to the employee and we have to bring the medical leave balance in the report

please do let us know if you are using Time evaluation or No Time evlaluation.