Dynamics GP 2015 Upgrade System Requirements
If you are upgrading to Dynamics GP 2015 make sure that you are at least on SQL Server 2008 R2 and running Windows Server 2012.Vince Stefanetti
If you are upgrading to Dynamics GP 2015 make sure that you are at least on SQL Server 2008 R2 and running Windows Server 2012.Vince Stefanetti
Always use caution when editing live tables in MAX. On occasion a hard closure of MAX or a dropped connection can cause MAX to retain the user in the ERMUD table which is in the EXACTMAX master database. You can query the ERMUD table and review the details to see which users are stuck….
If you need to use a Google Account for setting up email notifications on SQLServer make sure you use the 2 step security method. Login to the Google Account Go to Account Settings for the Account – Upper Right when you log in. Select Sign-in and Security 4. Then – 2 step 5….
This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by SQL Server. Selecting the collation sequence on setup provide the Instance Collation however the collation…
When a double period is used, as in: ExactMAXSampleDB..Part_Master This means the schema is inferred to be the default schema of the current login. In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for…
Many companies are still running older versions of MAX even DOS MAX. We can convert and bring you up to the current level. Contact me and I can assist you. Vince Stefanetti Senior Consultant
Below is a recursive CTE that does a multi-level explosion for the current effective date. ;with mlBOM as ( select PARPRT_02, COMPRT_02 , QTYPER_02, EFFDTE_02 from Product_Structure WHERE PARPRT_02 = ‘ENTER PARENT PART’ union all — CTE recursion select n.PARPRT_02, n.COMPRT_02 , n.QTYPER_02, N.EFFDTE_02 from Product_Structure n inner join mlBOM c on c.COMPRT_02…
Web: http://www.max.exactamerica.com Training: https://training.exactamerica.com/ Portal: https://customers.exact.com
Then get: Msg 5834, Level 16, State 1, Line 1The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration. Use this to fix it: sp_configure ‘Allow Updates’, 0RECONFIGURE WITH OVERRIDE