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

Fast Formula Calculation logic

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..

• 1. Re: Fast Formula Calculation logic
Gurus,

Any help on the issue.

Thanks
• 2. Re: Fast Formula Calculation logic
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.
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