2 Replies Latest reply: Nov 20, 2012 2:32 AM by 975131 RSS

    Fast Formula Calculation logic

    877722
      I'm working on R12.

      I have a requirement where the employee should not be deducted
      more than 25% of his earnings.
      if for example the employee takes car loan and salary advance
      we have priorities defined that gosi has the highest priority
      in the deduction elements followed by salary advance and car loan

      now if the emp takes salary advance as well as loan

      i need to handle this in the calculation such a way that
      if the total deduction should not exceed 25% of total earnings

      I have an information element that has the inputs as
      No of installments,
      amount to be paid,
      installments remaining
      deduction amount remaining

      this element passes the indirect results to the
      deduction element .

      If the amount is exceeding 25% it should skip the deduction in the current period and
      proceed the deduction in the next pay period.

      here it should follow like if the total doesnt exceed 25% until the first two deductions
      it should go ahead and deduct them and for the third it should do in the next installment
      either increasing the installment amount or increasing no of isntallments by one more.

      How do I achieve this..

      Thanks in advance
        • 1. Re: Fast Formula Calculation logic
          877722
          Gurus,

          Any help on the issue.

          Your help is much appreciated

          Thanks
          • 2. Re: Fast Formula Calculation logic
            975131
            Hi,
            It's a little hard to show how to do it. Let me try to explain as below.
            The most concept about Fast Formula working is Fast Formula is based on Element calculation order.
            As your requirement:
            1.A element for deducting current period.
            2.Need to accumulate deduction amount over past periods.
            3.Need to calculate base earnings at current period to calculate 25% amount limited.
            4.Rest Deduction Amount = (Total Deduction Amount - Accumulated Deduction Amount)
            IF Rest Deduction Amount <= current period earnings 25% amount then
            Current deduction amount = Rest deduction amount
            Else
            Current deduction amount = current period earnings 25% amount
            is that right?

            Here are steps suggested:
            1.create a "Voluntary Deductions" element A, and two input values:
            Pay Value : stored fast formula calculation results
            Total Deduction Amount : fixed total amount you need to deduct. When you add this element to a assignment, you should enter this amount at the same time.
            This Element's Priority should be setted bigger than those earnings elements' priority.
            2.create a balance A for base earnings.
            Inorder to get base earnings total amount for calculating 25% amount.
            3.create a balance B for accumulating deduct amounts of element A.
            4.create fast formula of element A:
            (1) Get Total Deduction Amount from element A's input value "Total Deduction Amount"
            (2) Get Balance Amount of balance A
            (3) Get Balance Amount of balance B => Accumulated Deduction Amount
            Dimensions: Assignment Inception To Date / Assignment Processing Period to Date
            (4) Calculate current period earnings 25% amount = Balance Amount of balance A * 25%
            (5) Calculate Rest Deduction Amount = Total Deduction Amount - Accumulated Deduction Amount
            (6) Calculate:
            IF Rest Deduction Amount <= current period earnings 25% amount then
            Current deduction amount = Rest deduction amount
            Else
            Current deduction amount = current period earnings 25% amount
            (7) Return Current deduction amount to element A's input value.

            Best Regard's,
            Changhua