Warning “Sales Order Processing and Invoicin...

Error Message: “Sales Order Processing and Invoicing modules are both installed. They do not share information. Transactions should be entered in one module only.” Below I discuss how you can turn off this message using Dynamics Utilities and SQL. Reason: This message is displayed to prevent users from accidentally entering transactions in both the Sales Order Processing and Invoicing modules in Microsoft...

SQL query to get companies accessible to a SQL/GP ...

You can easily check list of companies accessible to a GP user using Company Access Window. Or you can use a small query on table sy60100 Something like SELECT * FROM sy01500 WHERE cmpanyid IN (SELECT cmpanyid FROM sy60100 WHERE userid = ‘LESSONUSER1′) However, recently I needed a list of companies a SQL user (not user in GP) had access to. For this I needed list of databases the user had access to and company...