Any way to delete Part Transactions? NEED HELP


(system) #1

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]
>

 


(system) #2
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

(system) #3
Take a Backup first :)


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Fri, Jan 4, 2013 at 11:30 AM, greg_bakker <greg.bakker@...> wrote:

> **
>
>
> 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
>
>
>


[Non-text portions of this message have been removed]

(system) #4
Greg,

Unless you are an expert with the schema, deleting the PartTran record would be highly unadvisable. I don�t know what the transaction was posted to, but for example, if it was posted as a material to a job then the costs would also roll up the job materials and job head table. Similar roll ups would occur if it was an inventory transaction. If any of these types of related transactions have occurred, in addition to the GL, deleting the PartTran record would damage the relational integrity of the DB and create a GAAP violation because you could not trace the rolled up values back to the transactions.


Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.

On Jan 4, 2013, at 8:30 AM, greg_bakker <greg.bakker@...> wrote:

> 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
>
>



[Non-text portions of this message have been removed]

(system) #5
I would agree on the severity of deleting the transactions.
It looks like it was just a cost adjustment but I would capture and post
this transaction and then journal entry it off the books, if needed.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Barry
Sent: Friday, January 04, 2013 1:25 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Any way to delete Part Transactions?

Greg,

Unless you are an expert with the schema, deleting the PartTran record
would be highly unadvisable. I don't know what the transaction was
posted to, but for example, if it was posted as a material to a job then
the costs would also roll up the job materials and job head table.
Similar roll ups would occur if it was an inventory transaction. If any
of these types of related transactions have occurred, in addition to the
GL, deleting the PartTran record would damage the relational integrity
of the DB and create a GAAP violation because you could not trace the
rolled up values back to the transactions.


Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited. If you have received this email in error, please
immediately notify me by telephone and permanently delete the original
and any copy of any email and any printout thereof.

On Jan 4, 2013, at 8:30 AM, greg_bakker <greg.bakker@...> wrote:

> 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
>
>



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

(system) #6
The PartTran table has indexes to many tables and now with Epicor 9 - the
intermediate table between the PartTran and TranGLC tables.



If it that important maybe Epicor could supply a script to remove these
records.



I would not try it on my own.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Friday, January 04, 2013 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Any way to delete Part Transactions?





I would agree on the severity of deleting the transactions.
It looks like it was just a cost adjustment but I would capture and post
this transaction and then journal entry it off the books, if needed.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Michael Barry
Sent: Friday, January 04, 2013 1:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Any way to delete Part Transactions?

Greg,

Unless you are an expert with the schema, deleting the PartTran record
would be highly unadvisable. I don't know what the transaction was
posted to, but for example, if it was posted as a material to a job then
the costs would also roll up the job materials and job head table.
Similar roll ups would occur if it was an inventory transaction. If any
of these types of related transactions have occurred, in addition to the
GL, deleting the PartTran record would damage the relational integrity
of the DB and create a GAAP violation because you could not trace the
rolled up values back to the transactions.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited. If you have received this email in error, please
immediately notify me by telephone and permanently delete the original
and any copy of any email and any printout thereof.

On Jan 4, 2013, at 8:30 AM, greg_bakker greg.bakker@...
<mailto:greg.bakker%40kooima.com> > wrote:

> 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
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]

(system) #7
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]

(system) #8
If the part has just ADJ-CST transactions and PartTran.ExtCost is zero, then you can think of deleting the PartTran as GL transactions (tables like TranGlc and GLJrnDtl) are not created for zero cost transactions during Capture COS/WIP run. This must be a last option as you need to weigh the option of going with the new part or using the existing part by deleting the PartTran. If you wish to go with deleting PartTran, make sure that cost of the part is zero in this case as PartCost table will have non-zero value without releated PartTran. Before deleting any record it's advisble to write the data into a file so that it can be loaded back if it's required. But if the part has any other transaction type then don't even think of deleting PartTran. Try this in the test system and if you are happy with the result, then do it in live. Â
Â
Regards,
Arul
________________________________
From: Cathy <cathy@...>
To: vantage@yahoogroups.com
Sent: Saturday, 5 January 2013 5:58 AM
Subject: RE: [Vantage] Any way to delete Part Transactions?


Â

The PartTran table has indexes to many tables and now with Epicor 9 - the
intermediate table between the PartTran and TranGLC tables.

If it that important maybe Epicor could supply a script to remove these
records.

I would not try it on my own.

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Friday, January 04, 2013 11:32 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Any way to delete Part Transactions?

I would agree on the severity of deleting the transactions.
It looks like it was just a cost adjustment but I would capture and post
this transaction and then journal entry it off the books, if needed.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
mailto:jrojas%40matsinc.com | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

-----Original Message-----

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf
Of Michael Barry
Sent: Friday, January 04, 2013 1:25 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Any way to delete Part Transactions?

Greg,

Unless you are an expert with the schema, deleting the PartTran record
would be highly unadvisable. I don't know what the transaction was
posted to, but for example, if it was posted as a material to a job then
the costs would also roll up the job materials and job head table.
Similar roll ups would occur if it was an inventory transaction. If any
of these types of related transactions have occurred, in addition to the
GL, deleting the PartTran record would damage the relational integrity
of the DB and create a GAAP violation because you could not trace the
rolled up values back to the transactions.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited. If you have received this email in error, please
immediately notify me by telephone and permanently delete the original
and any copy of any email and any printout thereof.

On Jan 4, 2013, at 8:30 AM, greg_bakker mailto:greg.bakker%40kooima.com
> wrote:

> 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
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

(system) #9
I had heard that Epicor had created a means of changing the UOM Class and Inventory UOM.
If you could get this patch (fix) from Epicor it would work better for you I would think.

Has anyone been able to get this fix?

Bruce

--- In vantage@yahoogroups.com, Arul Shankar wrote:
>
> If the part has just ADJ-CST transactions and PartTran.ExtCost is zero, then you can think of deleting the PartTran as GL transactions (tables like TranGlc and GLJrnDtl) are not created for zero cost transactions during Capture COS/WIP run. This must be a last option as you need to weigh the option of going with the new part or using the existing part by deleting the PartTran. If you wish to go with deleting PartTran, make sure that cost of the part is zero in this case as PartCost table will have non-zero value without releated PartTran. Before deleting any record it's advisble to write the data into a file so that it can be loaded back if it's required. But if the part has any other transaction type then don't even think of deleting PartTran. Try this in the test system and if you are happy with the result, then do it in live. ÂÂ
> ÂÂ
> Regards,
> Arul
> ________________________________
> From: Cathy
> To: vantage@yahoogroups.com
> Sent: Saturday, 5 January 2013 5:58 AM
> Subject: RE: [Vantage] Any way to delete Part Transactions?
>
>
> ÂÂ
>
> The PartTran table has indexes to many tables and now with Epicor 9 - the
> intermediate table between the PartTran and TranGLC tables.
>
> If it that important maybe Epicor could supply a script to remove these
> records.
>
> I would not try it on my own.
>
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of
> Joe Rojas
> Sent: Friday, January 04, 2013 11:32 AM
> To: mailto:vantage%40yahoogroups.com
> Subject: RE: [Vantage] Any way to delete Part Transactions?
>
> I would agree on the severity of deleting the transactions.
> It looks like it was just a cost adjustment but I would capture and post
> this transaction and then journal entry it off the books, if needed.
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> mailto:jrojas%40matsinc.com | www.matsinc.com Ask us
> about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> -----Original Message-----
>
> From: mailto:vantage%40yahoogroups.com
> [mailto:mailto:vantage%40yahoogroups.com ] On
> Behalf
> Of Michael Barry
> Sent: Friday, January 04, 2013 1:25 PM
> To: mailto:vantage%40yahoogroups.com
> Subject: Re: [Vantage] Any way to delete Part Transactions?
>
> Greg,
>
> Unless you are an expert with the schema, deleting the PartTran record
> would be highly unadvisable. I don't know what the transaction was
> posted to, but for example, if it was posted as a material to a job then
> the costs would also roll up the job materials and job head table.
> Similar roll ups would occur if it was an inventory transaction. If any
> of these types of related transactions have occurred, in addition to the
> GL, deleting the PartTran record would damage the relational integrity
> of the DB and create a GAAP violation because you could not trace the
> rolled up values back to the transactions.
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> This email, and any attachments thereto, is intended only for use by the
> addressee(s) named herein and may contain legally privileged and/or
> confidential information. If you are not the intended recipient of this
> email, you are hereby notified that any dissemination, distribution or
> copying of this email, and any attachments thereto, is strictly
> prohibited. If you have received this email in error, please
> immediately notify me by telephone and permanently delete the original
> and any copy of any email and any printout thereof.
>
> On Jan 4, 2013, at 8:30 AM, greg_bakker mailto:greg.bakker%40kooima.com
> > wrote:
>
> > 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
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/
> http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>

(system) #10
If you don't have any of the part in inventory, orders, incoming POs etc,
you can change it in the DB pretty safely. Not exactly the recommended
method, but it can be done.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Mon, Jan 7, 2013 at 7:26 PM, Bruce <blarson@...> wrote:

> **
>
>
> I had heard that Epicor had created a means of changing the UOM Class and
> Inventory UOM.
> If you could get this patch (fix) from Epicor it would work better for you
> I would think.
>
> Has anyone been able to get this fix?
>
> Bruce
>
> --- In vantage@yahoogroups.com, Arul Shankar wrote:
> >
> > If the part has� just ADJ-CST transactions and PartTran.ExtCost is zero,
> then� you can think of deleting the PartTran� as GL transactions (tables
> like TranGlc and GLJrnDtl) are not created for zero cost transactions
> during Capture COS/WIP run.� This must be a last option as you need to
> weigh the option of going with the new part or using the existing part by
> deleting the PartTran.� If you wish to go with deleting PartTran, make sure
> that cost of the part is zero in this case as PartCost table� will� have
> non-zero value without� releated PartTran.� Before deleting any record it's
> advisble to write the data into a file so that it can be loaded back if
> it's required. But if the part has any other transaction type then don't
> even think� of deleting PartTran. Try this in the test system and if you
> are happy with the result, then do it in live.� �
>
> > �
> > Regards,
> > Arul
> > ________________________________
> > From: Cathy
> > To: vantage@yahoogroups.com
> > Sent: Saturday, 5 January 2013 5:58 AM
> > Subject: RE: [Vantage] Any way to delete Part Transactions?
> >
> >
> > �
> >
> > The PartTran table has indexes to many tables and now with Epicor 9 - the
> > intermediate table between the PartTran and TranGLC tables.
> >
> > If it that important maybe Epicor could supply a script to remove these
> > records.
> >
> > I would not try it on my own.
> >
> > From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%
> 40yahoogroups.com] On Behalf Of
> > Joe Rojas
> > Sent: Friday, January 04, 2013 11:32 AM
> > To: mailto:vantage%40yahoogroups.com
> > Subject: RE: [Vantage] Any way to delete Part Transactions?
> >
> > I would agree on the severity of deleting the transactions.
> > It looks like it was just a cost adjustment but I would capture and post
> > this transaction and then journal entry it off the books, if needed.
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > mailto:jrojas%40matsinc.com | www.matsinc.com Ask us
> > about our clean, green and beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
> the
> > named addressee you should not disseminate, distribute or copy this
> e-mail.
> > Please notify the sender immediately by e-mail if you have received this
> > e-mail by mistake. Please note that any views or opinions presented in
> this
> > email are solely those of the author and do not necessarily represent
> those
> > of the company.
> >
> > -----Original Message-----
> >
> > From: mailto:vantage%40yahoogroups.com
> > [mailto:mailto:vantage%40yahoogroups.com ] On
> > Behalf
> > Of Michael Barry
> > Sent: Friday, January 04, 2013 1:25 PM
> > To: mailto:vantage%40yahoogroups.com
> > Subject: Re: [Vantage] Any way to delete Part Transactions?
> >
> > Greg,
> >
> > Unless you are an expert with the schema, deleting the PartTran record
> > would be highly unadvisable. I don't know what the transaction was
> > posted to, but for example, if it was posted as a material to a job then
> > the costs would also roll up the job materials and job head table.
> > Similar roll ups would occur if it was an inventory transaction. If any
> > of these types of related transactions have occurred, in addition to the
> > GL, deleting the PartTran record would damage the relational integrity
> > of the DB and create a GAAP violation because you could not trace the
> > rolled up values back to the transactions.
> >
> > Michael
> >
> > Michael Barry
> > Aspacia Systems Inc
> > 866.566.9600
> > 312.803.0730 fax
> > http://www.aspacia.com/
> >
> > This email, and any attachments thereto, is intended only for use by the
> > addressee(s) named herein and may contain legally privileged and/or
> > confidential information. If you are not the intended recipient of this
> > email, you are hereby notified that any dissemination, distribution or
> > copying of this email, and any attachments thereto, is strictly
> > prohibited. If you have received this email in error, please
> > immediately notify me by telephone and permanently delete the original
> > and any copy of any email and any printout thereof.
> >
> > On Jan 4, 2013, at 8:30 AM, greg_bakker mailto:greg.bakker%40kooima.com
> > > wrote:
> >
> > > 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
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/
> > http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]

(system) #11
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]
>

(system) #12

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]
>

(system) #13
Just do a QA, you should NEVER delete transactions from the PartTran table.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Mon, Oct 21, 2013 at 5:38 PM, <ralmon@...> wrote:

Â
<div>
  
  
  <p></p><p>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. </p>


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]

>


</div>
 


<div style="color:#fff;min-height:0;"></div>