Downloads for Menus for Visual Studio Tools

David Meego - Click for blog homepageAs previously mentioned on this blog, Winthrop Development Consultants has an agreement with Microsoft to continue the development and support of the Menus for Visual Studio Tools.

It will be re-released once it has been rebranded.

I have updated the Winthrop Development Consultant’s web site Product page to provide access to the downloads for the previous versions.

The new Winthrop branded product will be available for the last three versions of Microsoft Dynamics GP; GP 2010, GP 2013 (including GP 2013 R2) and for GP 2015.

Get the previous versions from http://winthropdc.com/MVST.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, Menus for Visual Studio Tools, Microsoft, News, Products Tagged: Menus for Visual Studio Tools, MVST, News

See original article:
Downloads for Menus for Visual Studio Tools

March 27, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 271

Downloads for the Support Debugging Tool

David Meego - Click for blog homepageAs you should have heard by now, Winthrop Development Consultants has an agreement with Microsoft to continue the development and support of the Support Debugging Tool.

It will be re-released once it has been rebranded, renamed and updated.

However, Microsoft has removed the downloads for the Support Debugging Tool from PartnerSource and so even previous releases cannot be downloaded.

I have updated the Winthrop Development Consultant’s web site Product page to provide access to the downloads for the previous versions.

Please note that the new Winthrop branded product will be available for the last three versions of Microsoft Dynamics GP; GP 2010, GP 2013 (including GP 2013 R2) and for GP 2015. It will have improvements and new features and will definitely be worth updating to once released.

Get the previous versions from http://winthropdc.com/SDT.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, Microsoft, News, Products, Support Debugging Tool Tagged: News, SDT, Support Debugging Tool

More:
Downloads for the Support Debugging Tool

March 26, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 303

How to enable the Projection button in the Depreciation Projection window for Fixed Assets

Hi Guys..
Found a very important KB article on enabling Fixed Asset projections button in the Depreciation Projection window..
Check it out..

To make the Projection button available in the Depreciation Projection window for Fixed Assets, follow these step.

Note  The following steps require you to run delete scripts by using the Microsoft SQL Query Analyzer tool. We recommend that you create a backup of your data before you follow these steps.

  1. Make sure that all users exit Microsoft Dynamics GP.
  2. Use one of the following methods to start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio depending on the program that you use:
    • Method 1: SQL Server Desktop Engine (MSDE2000)

      Click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    • Method 2: SQL Server 2000

      Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    • Method 3: SQL Server 2005

      Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

    • Method 4: SQL Server 2008Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    • Method 5: SQL Server 2008 R2
      Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
    • Method 6: SQL Server 2012
      Click Start, point to All Programs, point to Microsoft SQL Server 2012, and then click SQL Server Management Studio.
  3. Run the following commands against the Company database:

    DELETE FA40203
    DELETE FA41900

    Notes

    • FA40203 is the Fixed Assets Depreciation Book Setup table (used for tracking projections and depreciation).
    • FA41900 is the Projection Report Master table.
  4. Start Microsoft Dynamics GP.
  5. Verify that the Projection button is available. To do this, follow one of these steps, depending on the program that you are running:
    • For Microsoft Dynamics GP 10.0 and later versions:

      On the Microsoft Dynamics GP menu, point to Tools, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.

    • For Microsoft Dynamics GP 9.0 and Microsoft Business Solutions – Great Plains 8.0:

      On the Tools menu, point to Routines, point to Fixed Assets, click Projection, and then verify that the Projection button is available.



Applies to
  • Microsoft Dynamics GP 2015
  • Microsoft Dynamics GP 2013
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0, when used with:
    • Fixed Asset Management

Follow this link:
How to enable the Projection button in the Depreciation Projection window for Fixed Assets

March 23, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 358

Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

 

I am sure if were in the non-English countries, you might need to use code pages other than CP1252 to support your characters, and 1256 would your right choice for example if you been in Arab speaking countries, but this makes a problem when it comes to Analysis Cubes installation.

Once you install the Analysis Cubes and finish all wizard issues you feel like things are becoming easy and will proceed to start your job getting your cubes inititalized and then you will be start getting below errors:

Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “INTERID” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC02020F4    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “CMPNYNAM” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x800470C8    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The external columns for component “OLE DB Destination” (22) are out of synchronization with the data source columns. The external column “CompanyID” needs to be updated.  The external column “CompanyName” needs to be updated. 
End Warning 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004706B    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: “component “OLE DB Destination” (22)” failed validation and returned validation status “VS_ISBROKEN”. 
End Error 

Progress: 2015-03-23 10:18:58.26    
Source: Copy Data from Results to CompanyMaster Task     
Validating: 50% complete 
End Progress 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004700C    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: One or more component failed validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC0024107    
Source: Copy Data from Results to CompanyMaster Task     
Description: There were errors during task validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC00220E4    
Source: Run Company     
Description: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run.  . 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x80019002    
Source: DynamicsGP_TWO_to_DynamicsGPWarehouse_Package_Master     
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. 
The Execution method succeeded, but the number of errors raised (6) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.  End Warning  DTExec: The package execution returned DTSER_FAILURE (1). 
Started:  10:18:57 AM 
Finished: 10:18:58 AM 
Elapsed:  0.842 seconds. 
The package execution failed. 
The step failed.

Obviously it is all about the first error, different code pages are exist and therefore your data cannot be copied from the production database to the data warehouse, going further with investigations I been able to get around this error by unifying the code page in my packages, and this is by simply allowing a flag in cubes SSIS packages to use the default code page “AlwaysUseDefaultCodePage” to be “True” and your issues will no longer be shown:

image

Now the challenge here you need to extract the packages from the MSDB store, to your Visual Studio and perform this change, save your package and re-import this back to your MSDB, this will need to be done to the following packages:

DynamicsGP_DynamicsGPWarehouse_FiscalPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_GLBudgets.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDAGroups.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDATransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_GLTransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemCurrentQuantity.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemMaster.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingPurchaseOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingSalesOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PurchaseOrderDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesPerson.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesTerritory.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalExpense.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalRevenue.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingDetails.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriodAmounts.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_CheckbookRegister.dtsx
DynamicsGP_DynamicsGPWarehouse_CompanyMaster.dtsx

Luckily, I found a script that makes this easier, it allows you to extract all your SSIS packages from MSDB to file system instead of pulling these one by one, it will save the packages to a folder on your “C:” drive, and all what you need to do then is copying these to your visual studio and start changing the flag, below the script:

;
WITH FOLDERS AS
(
    — Capture root node
    SELECT
        cast(PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
    WHERE
        PF.parentfolderid IS NULL

    — build recursive hierarchy
    UNION ALL
    SELECT
        cast(F.FolderPath + ” + PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
        INNER JOIN
            FOLDERS F
            ON F.folderid = PF.parentfolderid
)
,   PACKAGES AS
(
    — pull information about stored SSIS packages
    SELECT
        P.name AS PackageName
    ,   P.id AS PackageId
    ,   P.description as PackageDescription
    ,   P.folderid
    ,   P.packageFormat
    ,   P.packageType
    ,   P.vermajor
    ,   P.verminor
    ,   P.verbuild
    ,   suser_sname(P.ownersid) AS ownername
    FROM
        msdb.dbo.sysssispackages P
)
SELECT
    — assumes default instance and localhost
    — use serverproperty(‘servername’) and serverproperty(‘instancename’)
    — if you need to really make this generic
    ‘dtutil /sourceserver localhost /SQL “‘+ F.FolderPath + ” + P.PackageName + ‘” /copy file;”C:Packages’ + P.PackageName +’.dtsx”‘ AS cmd
FROM
    FOLDERS F
    INNER JOIN
        PACKAGES P
        ON P.folderid = F.folderid
— uncomment this if you want to filter out the
— native Data Collector packages
— WHERE
—     F.FolderPath <> ‘Data Collector’

Once you run this on your SQL Server the result will be set of commands like the below, run these commands using CMD and go to find these in your C:Packages folder:

dtutil /sourceserver SERVERNAME /SQL “DynamicsGPWarehousePackage” /copy file;”C:PackagesPackage.dtsx”

Execute these over CMD and find your files on C: drive, select all and paste the files inside your Visual Studio and start your modifications, once done import back updated packages to SQL Integration Services one by one and rerun your job.

Hope that this helps.


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Visit link:
Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

March 23, 2015 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 379

Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

We wanted to make everyone aware of an issue that we have come across in recent weeks.

There is an issue in the January Hotfix for Microsoft Dynamics GP that is causing SmartList Builder issues when used in the Web Client. Because of the issues in the hotfix, the Table Finder feature in SmartList Builder cannot load and it causes GP in general to fail loading. If you remove SmartList Builder

View article:
Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

March 17, 2015 · Nicole Albertson · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 234

#CONV15 – Convergence 2015 Atlanta – Getting There

David Meego - Click for blog homepageConvergence2015

Hello from Atlanta, Georgia, USA.

My journey to get to Convergence 2015 was relatively uneventful (which is good), but long (which is expected).

I booked my flight with Delta as their base hub is Atlanta. My itinerary showed that I would be able to complete the journey to Atlanta with two flights: Perth to Sydney and Sydney to Atlanta. This sounded great as I normally have to take three or four flights to get to my destinations in the USA.

I left home at 9:00pm on Thursday 12th March after a long day out. My wife and I had met a couple while on a cruise holiday back in June 2014. They mentioned that they would be boarding another cruise holiday from Perth in March 2015, so we offered to show them around Perth for a day before they boarded the ship. I had packed my bags on Wednesday night and spent the day visiting Sculptures by the Sea at Cottesloe Beach, a few wineries in the Swan Valley area (I was driving as I don’t drink) and the Botanic Gardens at Kings Park. We got home at 8:00pm, just enough time to eat and get changed.

Below are a couple of my favourites from Sculptures by the Sea (love the Roo getting revenge):

Sculpture1

Sculpture2

Anyhow, after arriving at Perth airport at about 9:30pm, I was able to get checked in and drop off the baggage fairly quickly and so had time to relax before the flights started. While waiting at the gate, I met Michael Marosa who used to work as partner in the Dynamics GP world for many years. He now works more with Dynamics AX and Dynamics NAV, but we will forgive him.

My first flight was a “Midnight Horror” (aka “Red Eye Special”) leaving Perth at 11:30pm and flying through the night arriving at Sydney at 7:00pm after 4.5 hours flying.

This left me with 5 hours to kill in Sydney before boarding the Delta flight to Atlanta. I found a place where there was seating and a power point and charged up my Lumia phone, Zune (yes, I like my 64GB Zune HD. Listening to music on a separate device is better than arriving at your destination with a phone that has no charge) and my noise cancelling headphones.

Plane

Then it was 12:15pm, time to board my direct flight to Atlanta…. Only to have my boarding pass replaced at the gate with a flight to Los Angeles and then a flight from Los Angeles to Atlanta (with the same flight number). While it was a single flight it was not non-stop as I had believed. Oh well, two flights was too good to be true.

The international flight arrived a little late into Los Angeles at about 8:00am and had a very tight connection to the ongoing domestic flight to Atlanta. The next flight was already starting to board as I was going through passport control and customs. I managed to get to the flight in record time, it was one of the quickest transitions from international to domestic that I have ever done in the USA. I have missed flights before because it usually takes a couple of hours.

The final leg left Los Angeles at 9:00am and arrived at Atlanta at 5:00pm local time. As I walked to baggage claim (I know there is a train, but it was full and I needed a walk), I came across a display of sculptures from Zimbabwe.

Sculptures

After collecting my baggage, Mariano arrived to pick me up and take me to his place. He has kindly offered for me to stay with him while in Atlanta. In fact I would be in trouble if I didn’t stay with him.

 Atlanta

So the journey finished at about 6:00pm Atlanta time when we got home. Atlanta is currently exactly 12 hours reversed from Perth. My trip door to door started at 9:00pm Thursday night (Perth Time) and arrived at 6:00am Saturday (Perth Time), this gives a total travel time of 33 hours.

Looking forward to seeing everyone.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

More here:
#CONV15 – Convergence 2015 Atlanta – Getting There

March 14, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 313

Workflow Engine in GP 2013 R2 and GP 2015

I’ve seen a lot of activity recently on the Dynamics GP Forum, indicating confusion over what version of SharePoint works with the new GP Workflow 1.0 and 2.0.  Quick answer – none of them.  GP 2013 R2 and GP 2015 both have a native workflow engine built in, eliminating the need for SharePoint altogether.

 
Additionally, Reviewers and Approvers need not be GP users to Review and Approve workflow steps if Email Actions  is enabled.  Approval can be initiated from within email notifications generated by the workflow.

Read More:
Workflow Engine in GP 2013 R2 and GP 2015

March 11, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 231