Skip to Content
0
Former Member
Nov 12, 2012 at 06:14 PM

RECNROOT is blank in ESTMJ

72 Views

Hi,

A user deleted a material from a Real_Sub and added the same material to another Real_Sub, I'm not sure how or what exactly that was done, but for some reasons, when I check the ESTMJ table for the material, I saw 3 entries:

One has the DELFLG = 'X' with RECNROOT number filled (old Real_sub that the material was removed from).

One has DELFLG = ' ' with RECNROOT number filled (new Real_sub that the material was assigned to)

One has DELFLG = ' ' with RECNROOT = '00000000000000000000' (???)

Has anyone seen this issue before? How can the last entry be removed from ESTMJ?

The user is trying to perform DG Filling, but this is causing error because the system is thinking the material is assigned to multiple Real_Sub.

Thanks,

David