Good Afternoon Jeff,
I am sorry to hear that you have experienced an interruption during your payroll posting process.
As it has already been mentioned, when an interruption happens during a payroll posting process, you need to verify where the interruption had occurred. Here are some areas you can look to verify what had been updated correctly:
You can run the following select SQL Statements:
select * from UPR30100 where AUCTRLCD='XX' --| Payroll Check History
select * from UPR30200 where AUCTRLCD='XX' --| Payroll Tax Liability
select * from UPR30300 where AUCTRLCD='XX' --| Payroll Transaction History
select * from UPR30400 where AUCTRLCD='XX' --| Payroll Distribution History Header
select * from UPR30401 where AUCTRLCD='XX' --| Payroll Distribution History Detail
select * from CM20200 where AUDITTRAIL='XX' --| Bank Rec - CM Transaction
select * from GL20000 where ORGNTSRC ='XX' --| General Ledger - Year-to-Date Transaction Open
Please Note: Replace the XX with the audit trail code associated to the payroll run
Once you have determined the extent of the interruption, you do have a couple of option to recover from an interrupted pay run:
Option 1: Restore from a SQL backup your company and dynamics data base. As Richard has stated, if you restore your company database, it is recommended that you restore your Dynamics database as well. The Dynamics Database does get updated by specific modules.
Option 2: If restoring from a backup is not an option, there is a way you can remove the entire pay run in question from the tables based off the audit trail code. Correct the employee’s summary information and associated payroll reports (ex. period end reports), along with correcting any sub-module that was affected by the pay run.
We recommend opening a support case to have a support engineer assist you with determining the extent of the interruption and help you decide what the best plan of action to resolve your issue.
Thank you for your time Jeff and have a wonderful day.
Best regards,
Jonathan Herman
Partner Online Technical Community
-----------------------------------------------------------------------------------------
We hope you get value from our new forums platform! Tell us what you think:
http://social.microsoft.com/Forums/en-US/partnerfdbk/threads
------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
