24 August 2009

Weekly Dynamic: Remove Orphaned My Reports Links

The My Reports section of the GP home page does a pretty good job of cleaning up after itself. If you create a report option, add it to the my reports section and then delete the report you should end up with an orphaned link. However, Dynamics GP cleans that up for you the next time you log in. But what if something goes wrong and the link doesn't get cleaned up?

In that case, break out your SQL editor and open up the SY70700 table in the Dynamics database. The My Report links are stored here and can be removed via SQL should the interface not properly clean up after itself.