Finance | Project Operations, Human Resources, ...

HCMWorker and relation with Benefir Accrual view

Like (0) Share

Report

Posted on 27 Dec 2022 15:48:16 by vicky1234

Hi,

I have a requirement to show the values of the view "PayrollAccrualTransactionsInquiry" on another form which is having HCMWorker and HCMPosition.

However I do not find any direct relation on the related View and am not sure what logic should be kept on the display method to pass the worker id and get the values of the view.

Can someone please share what relation needs to be specified to get values from the view "PayrollAccrualTransactionsInquiry" in case we have values from tables. HCMWorker and HCMPosition..

The view is used in this form. Payroll > Inquiries and reports > Benefit accrual transactions

Thanks,

All responses (3)

Answers (0)

GirishS 27,823 Moderator on 27 Dec 2022 at 17:14:11

Like (0)

Report

RE: HCMWorker and relation with Benefir Accrual view

As you can see in the form you will be having transaction date.

So I think whenever an pay statement is created for employee benefit accrual will be calculated and accrual amount will be shown in the inquiry form you said.

Benefit accrual id will be mapped against the worker.

You can get the total accrual amount for the worker by adding aggregate function like sum.

Thanks,

Girish S.
vicky1234 64 on 27 Dec 2022 at 16:58:28

Like (0)

Report

RE: HCMWorker and relation with Benefir Accrual view

hi Girish,

Thanks for the quick reply.

The problem is that it shows multiple records for the same worker ID and i think it's because there are multiple Accruals shown against a worker.

Is the benefit accrual plan setup somewhere to get the values from or it is setup which can be changed anytime.
Suggested answer

GirishS 27,823 Moderator on 27 Dec 2022 at 15:58:10

Like (1)

Report

RE: HCMWorker and relation with Benefir Accrual view

Hi vicky1234,

"PayrollAccrualTransactionsView" has a field named Worker - You can relate HcmWorker.RecId == PayrollAccrualTransactionsView.Worker.

This will return accural trasaction against the worker given.

Thanks,

Girish S.