Skip to Content
0

Opening and Closing balance of a leave

Mar 09, 2017 at 03:33 AM

90

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sikindar T Mar 21, 2017 at 10:37 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Rémi Corriveau Mar 21, 2017 at 04:56 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 21, 2017 at 11:06 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Victor,

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

Thank you

0