on 03-09-2017 3:33 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.