bhurlbert
Member
Need to clear all Transaction and Balance Tables
We are on E1 9.1
We have an very unusual situation, we are a fairly large multi-billion dollar business that is in bankruptcy
Another company bought 75% of the assets of our company, call it NewCo. They will continue to utilize JDE in the same manner as we have.
They want to keep the same structure: Company / Business Unit / GL Accounts / etc... (at least in the short term)
So, we are going to give them our current Prod box & PD to use as their system
(We'll copy off our Legacy PD structure to our Dev box where we will wind down the existing Legacy company
I'm also in the process of cloning the other companies that other buyers purchased, OtherCo, onto the same PD environment on the Dev box.)
However, we need to clear out all of the Transaction and Balance tables to give them a fresh start on the Prod box
Does anyone have a list of tables that would need to be cleared? I know some of the obvious ones like
- AP F0411, F0413, F0414
- GL F0902, F0911,
- FA F1201, F1202, F1204
- They will keep most of the Master Data since they will have the same Customers, Vendors, Employees, etc...
- At some point, we will need to purge any Master data that does not belong to the 75% they acquired
Does anyone have a list of which tables to clear?
I guess this would be similar to clearing out CRP and Test data from a Production instance when you are ready to go live?
Any suggestions would be much appreciated
Thanks
Bill
We are on E1 9.1
We have an very unusual situation, we are a fairly large multi-billion dollar business that is in bankruptcy
Another company bought 75% of the assets of our company, call it NewCo. They will continue to utilize JDE in the same manner as we have.
They want to keep the same structure: Company / Business Unit / GL Accounts / etc... (at least in the short term)
So, we are going to give them our current Prod box & PD to use as their system
(We'll copy off our Legacy PD structure to our Dev box where we will wind down the existing Legacy company
I'm also in the process of cloning the other companies that other buyers purchased, OtherCo, onto the same PD environment on the Dev box.)
However, we need to clear out all of the Transaction and Balance tables to give them a fresh start on the Prod box
Does anyone have a list of tables that would need to be cleared? I know some of the obvious ones like
- AP F0411, F0413, F0414
- GL F0902, F0911,
- FA F1201, F1202, F1204
- They will keep most of the Master Data since they will have the same Customers, Vendors, Employees, etc...
- At some point, we will need to purge any Master data that does not belong to the 75% they acquired
Does anyone have a list of which tables to clear?
I guess this would be similar to clearing out CRP and Test data from a Production instance when you are ready to go live?
Any suggestions would be much appreciated
Thanks
Bill