Microsoft SQL

/Microsoft SQL

Management Reporter 2012 CU12 Released

Microsoft released Management Reporter 2012 CU12 in April 2015.  As you all know, we wait a month or so to announce new releases in order to check bugs and test functionality.  Good news - CU12 is passing with flying colors! Fixes included in Management Reporter CU12: Indication of currently active reporting tree node Ability to [...]

Management Reporter 2012 CU12 Released2017-12-13T11:35:59-05:00

Unable to Apply Sales Transaction

Issue: Error when trying to apply sales transaction in the Apply Sales Documents. Unable to choose the document because it is part of a recovered batch or is still in the process of posting Scenario 1: After running the SQL script [select * from SY00500 where BACHNUMB - {'XXX'}], BCHSTTUS and MKDTOPST do not equal [...]

Unable to Apply Sales Transaction2017-08-02T13:58:00-04:00

Dynamics GP – SmartList Error

Dynamics GP - SmartList Error:  Unhandled script exception: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated. Original solution: https://community.dynamics.com/gp/f/32/t/128874.aspx Find your Company ID USE Dynamics SELECT CMPNYNAM as Company_Name,CMPANYID Company_ID FROM SY01500 Run the following script replacing -1 with your Company ID from the results of the table above INSERT [...]

Dynamics GP – SmartList Error2017-08-02T13:58:00-04:00

Install Professional Service Tools Library

Microsoft made all of the tools in Professional Service Tools Library free, but you do need to install an updated file in order to access them. Please contact your Microsoft Dynamics GP partner to download the current version of Professional Service Tools Library to receive access to all of the free tools and then follow [...]

Install Professional Service Tools Library2017-08-02T13:58:00-04:00

When Does My SQL Support End?

  Microsoft has announced the end of mainstream support for SQL 2008 – and it’s right around the corner.  Please look below to see when your mainstream and extended support end for your SQL version.   SQL Server Version Release Date End of Mainstream Support End of Extended Support SQL 7 Mar 01 1999 Dec [...]

When Does My SQL Support End?2017-08-02T13:58:00-04:00