Finance | Project Operations, Human Resources, ...

HCMWorker and relation with Benefir Accrual view

(0) Share

Report

Posted on 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,

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No