Wednesday, April 3, 2019

Cleaning up cross-reference DB in Dynamics 365 for finance and operation ON DEV VM


// For unwanted cross reference data clean Up on DB (DYNAMICSXREFDB)

DELETE [REFERENCES] FROM [REFERENCES]
    JOIN Names 
ON (Names.Id = [REFERENCES].SourceId 
OR Names.Id = [REFERENCES].TargetId)
    JOIN Modules 
ON Names.ModuleId = Modules.Id


By at
Labels: , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Copy Markup charges while posting purchase invoice using X++

 Copy Markup charges while posting purchase invoice using X++ Class: Important: Code logic is just for Reference.  New class => Duplicate...