How to Identify Whether the Transfer to Cash Management Process Has Completed

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');