Using Business Objects to Delete GL Accounts in 9.05.701

Do you have DMT? If so run a query on all the bad accounts and then used dmt to delete.

Greg Payne

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Amy
Sent: Friday, May 10, 2013 5:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Business Objects to Delete GL Accounts in 9.05.701



A user used the generate button by mistake when creating a gl account in Epicor and 3,085,000 were added to the system. As a result, we cannot run Financial statements ...etc. Epicor had a utility to delete for the 9.04 version, but not 9.05. Therefore we are trying to use the business object Epicor.Mfg.BO.GLAccount to delete these excess accounts.

I was adapting one of your programs to run in Visual Studio 2008 to delete some extraneous GL accounts. I am trying to do this in code as there are over 3 million accounts to delete. This is urgent as the extra GL accounts are keeping us from running reports.

I am getting this compile error which has me stumped.

System.TypeLoadException was unhandled
Message="Method 'UpdateExt' in type 'Epicor.Mfg.BO.GLAccount' from assembly 'Epicor.Mfg.BO.GLAccount, Version=9.5.701.0, Culture=neutral, PublicKeyToken=5d3fa3c7105d7992' does not have an implementation."
Source="EpicorGLClear"
TypeName="Epicor.Mfg.BO.GLAccount"
StackTrace:
at EpicorGLClear.Module1.Main()
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:


My problem is I do not call 'UpdateExt' at all. Is this something you can help us with?

Any help with this issue is greatly appreciated.

Thanks,


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
A user used the generate button by mistake when creating a gl account in Epicor and 3,085,000 were added to the system. As a result, we cannot run Financial statements ...etc. Epicor had a utility to delete for the 9.04 version, but not 9.05. Therefore we are trying to use the business object Epicor.Mfg.BO.GLAccount to delete these excess accounts.

I was adapting one of your programs to run in Visual Studio 2008 to delete some extraneous GL accounts. I am trying to do this in code as there are over 3 million accounts to delete. This is urgent as the extra GL accounts are keeping us from running reports.

I am getting this compile error which has me stumped.

System.TypeLoadException was unhandled
Message="Method 'UpdateExt' in type 'Epicor.Mfg.BO.GLAccount' from assembly 'Epicor.Mfg.BO.GLAccount, Version=9.5.701.0, Culture=neutral, PublicKeyToken=5d3fa3c7105d7992' does not have an implementation."
Source="EpicorGLClear"
TypeName="Epicor.Mfg.BO.GLAccount"
StackTrace:
at EpicorGLClear.Module1.Main()
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:


My problem is I do not call 'UpdateExt' at all. Is this something you can help us with?

Any help with this issue is greatly appreciated.

Thanks,