Due to an error with our implementation of eConnect, we have a bit over 500 duplicate deposits in one of our checkbooks. Does anyone know of a SQL script or a method to bulk delete or void deposits? The deposit numbers are in a continuous range. Could this be done by executing a SQL delete statement against one or more tables or is the only solution to manually void the deposits?
*This post is locked for comments
As suggested by the others on the forum, it is better than deleting from SQL - it forces the system to follow the rules and takes care to make sure all the related data is removed and accounted for correctly.
Good luck.
Thank you for your input. I looks like the system generated a JE for each of the 500 deposits. I will pursue creating a macro to void the entries. My C.P.A. who is our tech support for DynamicsGP also recommends creating a macro.
Mahmoud, the reason I was looking for more details on the data was to ensure that they client looks at all possible data locations and not just the Deposit Work tables.
If a macro can be created and run easily that is the direction I would also take. I want to explore other details.
I would not recommend the SQL method to get them removed from your Dynamics GP. Additionally, you should look for other factors which could have possible went wrong.
The macro is the safest, yest easiest way to get this done.
Never hesitate to share any further inquiries,
Jeff when the deposits were recorded by eConnect did they update other places in Finance such as the GL - did they create the JE for each of the deposits or were you just forcing the detail to the bank reconciliation and not to the rest of the GL?
Hi Jeff,
My suggestion would be to record a macro to delete the deposits. Please try to this a test system before implementing on live.
Start by recording a macro of you voiding 2 deposits. Then open this file in notepad. You should be able to see the appropriate syntax of the macro and from this...add the remaining 498 deposits.
Then replay the macro.
Thanks,
Justin
Share
Report
All responses (
Answers (
12
