I would use a UDxx update method and then remove any header without any detail records.
you could also do a SQL delete with a join on the 1st detail record and remove any that were null.
From: firstname.lastname@example.org [mailto:email@example.com]
Sent: Monday, August 31, 2015 2:08 PM
Subject: [Vantage] E10: Delete Customer Shipments with no lines
We found a bug in 10.0.700.4 where if you view shipments in Customer Tracker and some of those shipments have no lines, it will generate an error about not being able to cast DBNull to String.
Epicor acknowledged it and it will be fixed in 10.1 (surprised?).
I figured I would just delete all these pack IDs because they are just mistakes that happened during shipping but, to my dismay, this is not something that DMT can do. Unfortunately, there are over 3,000 of them.
Any idea on how to get rid of these without doing one at a time?
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png]<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png] <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png] <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png] <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png] <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png] <http://matsinc.com/blog>
[Non-text portions of this message have been removed]
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."