Payroll Cannot Transferred To Cash Management
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1-Calculate Payroll
2-Calculate Prepayments
3-Archive Periodic Payroll Results
4-Make EFT Payments
5-Generate Payslips
6-Calculate Costing of Payments -1
7-Transfer Payments Information to Cash Management
8-Transfer to Subledger Accounting
9-Calculate Costing of Payments -2
10-Create Accounting (draft)
Below query to identify unprocessed payroll action id
For the last Transfer to Cash Management executed, this will show number of employees successfully processed.
select count(*)
from pay_payroll_rel_actions ra
where ra.source_action_id is null
and ra.action_status <> 'U'
and ra.payroll_action_id in
(select max(pa.payroll_action_id)
from pay_payroll_actions pa
where pa.action_type = 'TC');
The following will show number awaiting processing:
select count(*)
from pay_payroll_rel_actions ra
where ra.source_action_id is null
and ra.action_status = 'U'
and ra.payroll_action_id in
(select max(pa.payroll_action_id)
from pay_payroll_actions pa
where pa.action_type = 'TC');
