Hi Jae,
I must say, you have a good one here. Let us explore a couple of ideas to help you out. And then decide which one to go with. Please look at the following options which consist of questions for you to answer and the reasons I am asking the questions. At the same time I will bounce this off of my GPUG Network and my Dynamics GP Network of people and see if any of them have an ideas that I have missed.
Option 1: Worst Case:
Question:
Do you or her know about what day and time that she accidentally clicked the delete button? In addition, do you and the rest of the users you have in Dynamics GP have a good idea of what they have done in Dynamics GP since the time the delete button was clicked? And I am assuming that you have good valid full and hopefully transaction log backups from before that point in time.
Reason:
As a worst case if you have a full backups and possibility some transaction log backups you could restore to a point in time before she accidentally clicked the delete button. However, this would also mean that everything that has been done in Dynamics GP by anyone since that time would be lost and would need to be redone.
Option 2: Not as Bad but require knowledge of SQL
Question:
Do you or her know about what day and time that she accidentally clicked the delete button? In addition, do you and the rest of the users you have in Dynamics GP have a good idea of what they have done in Dynamics GP since the time the delete button was clicked? And I am assuming that you have good valid full and hopefully transaction log backups from before that point in time. (Notice same question a Option 1)
Reason:
It may be possible to restore the company database to a different SQL Server and then in some manor copy the necessary table(s) and / or records from that copy into the production SQL Server. As I cannot name those tables off the top-of-my-head, hopefully one of my friends or even just someone in the community can list those out for us.
Option 3: Still going to be hard
Question:
Is it possible to completely void the entire Payroll and redo it?
Reason:
Depending on your settings, how the transactions are entered, etc. Voiding the entire payroll and rerunning it may be your best option, unless (hopefully) someone else can come up with something easier.
Another tidbit of Info:
Question:
Have you / her run any payrolls since she clicked the delete button?
Reason:
I have noticed, at least on my test system, that even if all batches have been deleted in the "Generate ACH File" screen if you click on the "Deposit Register" button is gives you a report of the last payroll run, even if no ACH file was ever created. Note, this may be because so some setting that I have turned on or off and thus will not actually work for you but I would suggest that if you have not run any payroll since the problem to at least give it a try and see what you get. I do need to point out that the report is not an ACH File however it may help in that it list the Employee ID, Name, SSN, Gross Pay, Net Pay, and the Direct Deposit number.
Option 4: ??? This is an option, but almost impossible without a great deal of knowledge of the ACH File format structure
No real question for this option but it is theoretically possible to manually create an ACH File using notepad or some other text editor. However, having done it once a long time ago I do not advise it. It is not an easy file to manually produce. The only reason I even mention it is because it is theoretically possible, but notice that I said "once". It is not something I would ever want to do again.
Option 5: Hopefully getting to a better answer.
Question:
Have you contacted you Partner?
Reason:
As most Partners have multiple customers maybe they have already run into this have have a good fix for it.
Option 6: Hopefully also getting to a better answer.
Question:
Have you tried to contacted Microsoft Support about opening a Support case with them.
Reason:
Hey, they are Microsoft, they know the product better than anyone.
Let me bring this to the attention of some others I know and hopefully between them and the community at large we can come up with a plan of action for you.
Till later,
