How to Calculate Payroll Reversals
How to include payroll reversal values in calculation
We have BI publisher report that calculates Payroll distribution for all of our employees. It provides us payroll run details along with Fund, Org, Account costing values. We are using Pay_Costs table to calculate the payroll values but that table does not include reversals. I have also looked into pay_run_result_values table, and it shows reversals in negative value, but if I replace pay_costs table with pay_run_result_values, we are facing issues with getting Costing details, as we cannot join run_result_values table with PAY_COST_ALLOC_KEYFLEX table.