how to END an element ?

[jamal]

Assalamu-ali-kum,

We have a scenario as the following.
Element: Miscellenous Services
Element : Miscellenous Service Recovery
Balance : Misc_Serv_Bal

Forexample if an employee takes loan as Miscellenous Services so i have to deduct from him through Miscellenous service recovery.
in the above it will be like this.
for Air Ticket January:
Miscellenous Service : 5000
Micellenous Service Recovery : 1000

for Hous January :
Miscellenous Service : 4000
Micellenous Service Recovery : 1000

Now we have one Balance ofcourse , So what i want here is when the employee pays back for Hous he should be deducted 1000 after that but in our case it is deducting 2000 , i want to stop one element how can i do this.

Thanks
Jamal

[admin]

Pl check Fast Formula and see what is code there? tks

[jamal]

Thanks alot admin....i have checked the formula, the formula is ending all the elements but i want to end one of the entry...thanks.
any other way

[eng_ahmad_2007]

Hi Jamal,

As I understand from your scenario, one element is used in two loans so if you stop one loan you will stop the whole element (both)... I guess you need to define two indirect elements ans stop each one according to the loan specified.

Regards,

[johnsmith22]

Please run this updated query to see if there is any run results attached to the element.
SELECT ET.ELEMENT_NAME,psp.PROCESSING_RULE, ff.FORMULA_NAME, pfr.RESULT_NAME,
pfr.RESULT_RULE_TYPE, et1.ELEMENT_NAME et_to_end_date,iv.NAME,iv.UOM, et.REPORTING_NAME,RESULT_RULE_TYPE ,
Psp.EFFECTIVE_START_DATE rule_start_date,PSP.EFFECTIVE_END_DATE rule_end_date
FROM
PAY_STATUS_PROCESSING_RULES_F psp,
PAY_FORMULA_RESULT_RULES_F pfr,
ff_formulas_f ff,
PAY_ELEMENT_TYPES_F ET,
PAY_ELEMENT_TYPES_F ET1,
PAY_INPUT_VALUES_F IV
WHERE
psp.FORMULA_ID=ff.FORMULA_ID
AND pfr.STATUS_PROCESSING_RULE_ID=psp.STATUS_PROCESSING_RULE_ID
AND et.ELEMENT_TYPE_ID=psp.ELEMENT_TYPE_ID
AND et1.ELEMENT_TYPE_ID=pfr.ELEMENT_TYPE_ID
AND iv.INPUT_VALUE_ID=pfr.INPUT_VALUE_ID
--AND pfr.RESULT_RULE_TYPE = 'I'
AND ET1.ELEMENT_NAME = --'Pension Adjustment'


___________________________
Software Testing Training