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