Skip to Content

Opening and Closing balance of a leave

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 21, 2017 at 10:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2017 at 04:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 21, 2017 at 11:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded