HCM Payroll Extract to sum hours and amount based on Job, Cost Center and Secondary Classification
Summary:
We have requirement where we need to extract quarterly payroll data and have to provide file with Job, Company, Dept, Sec Classificaiton (need to exclude some elements). I am using standard approach where filtering data based on requirements. Instead of individual line items in extract, I am thinking to group and sum data based on Job, Cost Center and Secondary Classification in extract itself.
I would like to know if this is possible or not. I tried different way but I am not able to achieve it. Any help would be appreciated.
I am looking for output like below as XML