Skip to Content
author's profile photo Former Member
Former Member

Pc00_m40_UPCF program upload template required

Hi

I am unable to find out the upload template/format to be used to update the records in T7INAE.

Pls Guide.

Thanks

Seema

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on Jul 04, 2014 at 09:58 AM

    Dear Seema,

    Please find the details,

    First upload data in development server for one employee & test as per your requirement.

    In this example :- We have used for development client and monthly telephone reimbursement which is carry forward, if there are any balance amount & employee has not taken at end of financial year, reimbursement payable & liable for tax .

    Server Pers. No. Taxcd End Date Start Date RN0 CF amount Paid amt. Flag RAP N0 RAP N0 RAP N0 Pay & Tax CumTyp period Rec Type Date 111 231 ZTEL 20140630 20140601 1800 0 u 0 0 0 0 M 201402 2 20140618
    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 04, 2014 at 01:36 PM

    Dear Seema,

    kindly explain about your reimbursement process details & what problem you are facing?

    In my client they mentained the eligability through IT0589 through offcycle process.

    If any employee eligability increase in back dated then they copy the IT0589 & with effect from then use the carry froward balance PC00_M40_REMC - Claims Balance Carry Forward

    The details you can find :- Payrol India - Utilities-Reimbursements, Allowances & Perks

    Regards,

    Rakesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rakesh

      I tried as mentioned above by you but it does not carry forward the increased eligibility .

      Have you maintained some userexit for this functionality....

      I need urgent help on this.

      My issues in claim functionality are as below:

      1. Eligibility should be monthly and should not carry forward beyond financial year . (31st march)

      2. If there is change in eligibility with past effect, system should take care of that and accordingly reduce or increase the eligibility.

      3. To update the table T7INAE by using program PC00_m40_UPCF.

      In case if all these are not possible by using claim functionality then how can i do this by using some other method .

      Scenario is :

      1. Employee should not be paid more than his eligibity till date.

      2. If his claim value is more than eligibility then paid amount should be equal to Eligibility. and balance claim value should be carried forward and should be paid in next period accordingly.

      3. Unclaimed balance in the year end should be paid as taxable amount.

      Please help me in this.... as i am badly stuck in this.

      Thanks

      Seema


  • Posted on Jul 07, 2014 at 10:22 AM

    Dear Seema,

    Please find the details:-


    1. Eligibility should be monthly and should not carry forward beyond financial year . (31st march)

    Please mention your eligibility in infotype 0589 (Individual Reimbursements) start date and end date should be 31.12.9999 i.e.

    PA30- put 0589 & put reimbursement type, eligibility amount (monthly /annually as per requirement) and start date & end date.


    2. If there is change in eligibility with past effect, system should take care of that and accordingly reduce or increase the eligibility.

    If there are change in eligibility with past effect, then just copy the infotype 0589 and mentioned the effective date (start date) & end date 31.12.999 .Never forget to mentioned the wage type.


    In second steps use the carry forward tcode :- PC00_M40_REMC - Claims Balance Carry Forward

    Through this code you start carry forward the reimbursement with start date.


    3. To update the table T7INAE by using program PC00_m40_UPCF.


    Table T7INAE update automatic after the off cycle process are completed.


    Scenario is :

    1. Employee should not be paid more than his eligibity till date.

    Eligibility are mentioned in infotype 0589 (monthly /annually as per client requirement)

    We mentioned the eligibility & other details in table V_T7INAA

    2. If his claim value is more than eligibility then paid amount should be equal to Eligibility. and balance claim value should be carried forward and should be paid in next period accordingly.


    This activity is done by approver


    3. Unclaimed balance in the year end should be paid as taxable amount.

    In table V_T7INAA, we mentioned that end of the financial year whether the amounts are lapse or paid and taxable.

    As per your requirement taxable and paid the mentioned the wage type . This wage type should be configure for posting purpose also for FI posting (tab v_t52EL)


    For details go though the following url

    http://help.sap.com/saphelp_erp60_sp/helpdata/en/88/d7ec3454674a498dca40f382fa0d1d/frameset.htm

    We can use the following path :-

    SAP Easy Access- Utilities- Reim. allowance & perk

    Regards,

    Rakesh

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Seema,

      I did the same but if the eligibility is monthly and can be forwarded for 12 months . In this case when i carry forward it carries forward to neaxt year e.g june '2014 will carried forward till June2015. which is not correct. It should stop at 31.03.2015. only.

      Check the Table T7INAA whether your wage type is monthly or annual & how much time carry forward

      whether its is taxable & paid at end of financual year

      Suppose employee eligability is Rs. 1000 & entire year s/he has not caimed the totalamount = Rs. 12000 should be paid.

      So for taxable & paid on march month,we should run the tcode-PC00_M40_REMT - Claims Balance Disbursement

      after processingthis tcode amount should be taxable & paid in regular payroll.

      Here the problem is : we can carry forward once for a period. e.g. if my eligibility is Rs.1000 per month. I carried forward for Apr/May /June and the eligibility has become Rs. 3000. Now in July i got salary hike and my eligibility has increased to 1500 per month effective from april.

      But the system is not carrying forward additional rs. 500 per month and still showing theeligibility in july as Rs. 3000 instead of Rs.4500

      Again run the carry forward tcode -PC00_M40_REMC - Claims Balance Carry Forward

      with effect from April

      Regards,

      Rakesh