Amount based on formula for Flexible Benefits

[anup-dh]

Is your feature request related to a problem? Please describe.

Currently, when is flexible benefit is ticked, conditions and formula tab disappears, and obviously amount based on formula does not work.

This set up is suitable if every employee has same amount of max. Flexible Pay.

We have this legal situation in Nepal:

1. Every employee is entitled to 1 month's pay (basic salary) as Festival allowance which is payable upon Employee's claim during their Festival time (as per their culture). Usually employees (of every religion; I said usually) claim/expect this bonus approximately during September every year (this time is Dashain festival here).

So, this is the salary structure here:

Basic Salary = base
Other allowances if any
Addition by Employer: 8.33% of base (as festival allowance, payable during festival time or as per employees claim)
Addition by Employer: 10% of base (for Provident Fund )
Addition by Employer: 8.33% if base (for Gratuity)
Addition by Employer: 1.67% (other health benefits)

Deductions:
Income Tax - as per slab
Employee's contribution to PF: 10% of base
Employee's contribution to Health benefits: 1% of base

Now, everything else can be handled by salary component except the festival allowance. It is best handled by Flexible benefits. But the problem is, currently flexible benefits accepts only fixed amount.

If we were to use current system, we can leave that to zero and create separate salary structures for each employees and set max benefits there.

and assign all that amount to Festival allowance (salary component) via Employee benefit application.

But doing that for 100's of employees is hectic.

Proposed solution:

Allow formula based amount in flexible benefit.
If Amount based in formula is set for flexible benefit, then max benefit for that salary component should be automatically fetched in Employee benefit claim doctype and employee benefit application doctype.

Also there should be a check during benefit claim, to not allow more benefit claim than the total Employer's contribution towards the Festival allowance.

Also, we should keep in mind that payroll period usually starts at July 15/16. Employees claim such benefits in September. For someone who has been working for a few years at the office, the festival allowance will be 1xbase salary which comes from employer's contribution from october 2024 till sept 2025 before employee claims that benefit on sept 2025. I hope you understand.

Describe the solution you'd like

No response

Describe the alternatives you've considered

No response

Additional context

No response