How to access data from other companies from Dexterity

Have you ever had to develop Dexterity code that needs to read data from a company other than the current Microsoft Dynamics GP company? Well, with my latest updates to the Support Debugging Tool , I came across this requirement. While developing the support for the Extender security objects, I realised that the Extender objects are stored on a per company basis and to obtain the descriptions for the various objects I would need to read the tables in companies other than the one currently logged into. I knew the method and so was able to implement this functionality, but I thought that it would make a good blog post incase others need to achieve a similar goal. Below is the concept followed by some example code: First check the SY_User_Company_Access_REL table to see if the user has access to the company. Lookup the location for the table from the SY_Pathnames table, using the Dictionary ID, Company ID and Series

Read the original here:
How to access data from other companies from Dexterity