F4211 Deleted????

[SMMM]

Hi,

The Sales Order Detail table (F4211) got deleted accidentally while generating tables.

Now we are planning to clean up the tables which are linked to F4211. I would like to know which is the best way to proceed. I am sure that some of you would have faced the similar situation in the past. Any suggestions regarding this are welcomed.

Thanks,

 

[got_to_love_jde]

Surendra,
Why wouldn't you restore F4211 from back up ? Are you live on JDE ?
Dave

 

[SMMM]

Dave,

We are going live some time in March. I think We did not have any kind of back up mechanism in place. If I know the list of tables which are created/updated when a SO detail line is created, I can use SQL delete to clean up these tables. I am not sure if this have any other implications.

Thanks,

 

[alexander_chev]

Hello, Surendra,
If you want to know which tables are involved, I would recommend the
following:
1. Set debug mode on your client (JDE.INI)
2. Login and add a new SO
3. Check the debug.log for SQL updates

Regards, Alex.

 

[Ellen_Deak]

There's probably more involved than just the files that are populated when
you enter a new order. For example, if you are using Warehousing you may
need to clean up those files as well (F4600, F46200, F4611...). The
Warehouse files don't get populated immediately.

You may want to look at writing an update program to delete all
Transactional tables. Back when we were doing our implementation someone had
done that here. Unfortunately, I don't have that list any more.

Ellen Deak
Senior Programmer/Analyst
Elkhart Products Corporation
B7333 SP 18.1 Rev 0
AS/400 V4R5M0

 

[vbojan]

Re: RE: F4211 Deleted????

Surendra,

You can extract records from F42199 with MAX(UPMJ+TDAY) and insert into F4211.

Hope this helps,

Bojan.

 

[SMMM]

Re: RE: F4211 Deleted????

We have restored the records from Back up. Thanks for all your suggestions.