nav-left cat-right
cat-right

Dynamics GP now supports Microsoft SQL Server 2014...

Recently released Dynamics GP 2013 R2 also supports Microsoft SQL Server 2014 Standard or Express Editions. Refer to system requirements for further details: https://mbs.microsoft.com/customersource/northamerica/gp/learning/mdgp2013_system_requirements You can download Dynamics GP 2013 R2...

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...