If the receipt is in error, just delete the packing slip and it will reverse the transaction.
Looks like that was already done, since every transaction by part nets 0.
What do they need to be deleted?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, October 21, 2013 4:45 PM
To: Vantage
Subject: Re: [Vantage] RE: Any way to delete Part Transactions? NEED HELP
Just do a QA, you should NEVER delete transactions from the PartTran table.
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Mon, Oct 21, 2013 at 5:38 PM, <ralmon@...> wrote:
Need a way to clean these transactions out of the database ASAP!!! Anyone know a way to do this? The original transaction occurred in April and May and then one today from me deleting the assocaited transactions.
Sys Date | Sys Time | Tran | Part | Warehouse | Bin | Type | Type | Invty | Tran Date | Quantity | UOM | Mtl Unit Cost | Lbr Unit Cost | Bur Unit Cost | Sub Unit Cost | Mtl Bur Unit Cost | Amount | Costing Method |
4/22/2013 | 35816 | 2 | 018F6813 | SHOP | RECEIVING1 | R | PUR-STK | TRUE | 4/22/2013 | 2 | EA | 1000 | 0 | 0 | 0 | 0 | 2000 | A |
4/23/2013 | 35140 | 3 | 018F6813 | SHOP | RECEIVING1 | R | PUR-STK | TRUE | 4/22/2013 | -2 | EA | 1000 | 0 | 0 | 0 | 0 | -2000 | A |
5/15/2013 | 26344 | 4 | 018F6813 | SHOP | RECEIVING1 | R | PUR-UKN | FALSE | 5/15/2013 | 10 | EA | 2 | 0 | 0 | 0 | 0 | 20 | A |
5/15/2013 | 26345 | 5 | 020-202022 | SHOP | RECEIVING1 | R | PUR-UKN | FALSE | 5/15/2013 | 10 | EA | 12 | 0 | 0 | 0 | 0 | 120 | A |
10/21/2013 | 59876 | 6 | 018F6813 | SHOP | RECEIVING1 | R | PUR-UKN | TRUE | 5/15/2013 | -10 | EA | 2 | 0 | 0 | 0 | 0 | -20 | A |
10/21/2013 | 59876 | 7 | 020-202022 | SHOP | RECEIVING1 | R | PUR-UKN | TRUE | 5/15/2013 | -10 | EA | 12 | 0 | 0 | 0 | 0 | -120 | A |
---In vantage@yahoogroups.com, <greg.bakker@...> wrote:
Greg,
I got the "rogue" UOM Class deleted by basically following what you suggested. I left the PartTrans alone. I edited the Part table through SQL and changed the UOMClassID to a different UOM Class. I was then able to delete the "rogue" UOM Class. I did some testing and everything seems to be working OK. If this was a production database I would be more hesitant to do this, but since it is a Pilot with almost no transactions I feel pretty safe.
Thanks for everyone's suggestions (and warnings). I appreciate it. I hope I can "pay it forward" some day!
Thanks,
Greg Bakker
Kooima Company
--- In vantage@yahoogroups.com, Greg Payne wrote:
>
> Greg:
>
> You can change the part uomclassid thru a sql query. That will enable you to delete the UOM Class. I would not delete the part trans, but change the partnum to another part and then you can delete the part. The cost adjustments will done on that part, but will be overridden when you add your current costs and quantities.
>
> all of this is predicated on no quantity transactions ever happening on the part.
>
> as Jose suggests backup before and test after you do this.
>
> Greg Payne
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of greg_bakker
> Sent: Friday, January 04, 2013 11:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Any way to delete Part Transactions?
>
>
>
> We are about 75% through our initial implementation of Epicor 9.05.701. We are working on setting up our Pilot (pristine) environment. There somehow got a Part in there with a couple of transactions against it (ADJ-CST). I would like to delete this Part because it is using a UOM Class that I would like to delete. But it will not let me delete either the UOM Class or the Part because of the transactions against that Part. Epicor Support basically told be that there is no way to delete these transactions so I need to mark the Part and UOM Class as Inactive.
>
> So, I guess before I resort to that, I thought I would ask if any of you know if there is a way I can safely delete these transactions/Part/UOM Class? It looks like these transactions happened about 5 months ago, so I can't restore a db backup, too much has changed since then.
>
> What is the worst thing that would happen if I just deleted those two transaction records out of the PartTran table through SQL? We don't have any history in this Pilot database yet that could get messed up. I don't think many of the GL Control Codes were even set up when the transactions took place. FYI: In these PartTran records GLTrans=1 and PostedToGL=0. Any words of wisdom?
>
> Thanks,
> Greg Bakker
> Kooima Company
>
>
> ________________________________
> 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]
>
