Results 1 to 1 of 1

Thread: Calculating the CPP Exemption

  1. #1

    Calculating the CPP Exemption

    Does anyone know the best way to calculate the CPP Exemption?

    I am trying to extract the data from E1 for a conversion to Oracle HCM and the Exemption isn't stored in E1

    I know that to calculate the CPP Exemption, it should be 134.62 * Number of Pays the employee has received (what is the best way to get this number)

    I have an employee that hasn't maxed out and should be calculated normally
    If I used the above method
    (3500/26)*14 (Number of pays) = 1884.62

    I have tried calculating it by doing the following
    1) Taxable Earnings * 4.95% = Total Taxable
    2) Total Taxable - Total Withheld = Total
    3) Total/4.95% = Exemption

    If I use this method:
    1) 46386.74 * 0.0495 = 2296.14363
    2) 2296.14363 - 2202.82 (CPP Withheld) = 93.32363
    3) 93.32363/0.0495 = 1885.3258

    As you can see the 2 methods generate different amounts

    I need to get this calculation figured soon as we are in the middle of a data conversion.


    For the most part this calculation works EXCEPT if the person was on leave during the year; turned 70 in the year or filled out the CPT30 form in the year

    Is there any where in JDE that I can validate that my calculation is correct?

    Last edited by pbare; 04-10-2019 at 06:17 AM.
    EntrpriseOne 9.1
    On Windows 7 Platform

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.