Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

David Meego - Click for blog homepageFollowing on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake.

The Problem

The update to the RW_CoAddrIDInfo() report writer function has broken the code. It works when no Address ID is supplied to return the information from the default Address information stored on the Company Master table, but fails to return any results from the Location Master table when an Address ID is provided.

I looked at the code and identified the issue and have logged the proposed fix with the development team as TFS Bug 79342. Hopefully, we can get the fix into the next GP 2013 R2 release soon.

In the meantime, I have created a couple of workaround fixes which can be used until the code is fixed by development. They are attached to bottom of this article.

 

The Fixes 

Using Support Debugging Tool

The first fix uses the Support Debugging Tool (http://aka.ms/SDT) to create a custom Report Writer function which can be called using the following syntax:

FUNCTION_SCRIPT( rw_TableHeaderString  5261  “RW_COADDRIDINFO”  “Address ID”  0  X )

where the Address ID can be specified as a string constant or from a variable and X is the data you want returned.

The Runtime Execute script and an example custom report are in the archive for you to use.

If you already have the SDT installed in the Recommended Configuration (with a shared setup file), you can deploy the fix by importing the configuration settings xml file once on any workstation and updating your reports to use the function call above.

 

Using Dexterity

The second fix is a small Dexterity chunk file which triggers a corrected version of the RW_CoAddrIDInfo() function after the original and so provides the correct results. It can be used without making changes to existing reports, however, the chunk will need to be deployed on all workstations that need the fix. The chunk file and its source code are provided in the archive for you to use.

 

Both fixes should be removed once the original code is fixed.

See I am human, and not the Alien that Mark Polino thinks I am. 

David

Original post:
Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

August 22, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 314

Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

Lucas Miller - Click for blog homepageHello!

I just want to first take a second to introduce myself since this is my first post on the Developing for Dynamics GP blog.  My name is Lucas Miller and I’ve been supporting Microsoft Dynamics GP since 2005.  Like much of the team I’m based out of Fargo, ND, USA.  I’ve been married for almost 2 years and my wife and I are expecting our first in just under 3 weeks as of this writing.  My main focus has been on the system side, but the last couple years I’ve been focusing on import tools (e.g. Integration Manager and eConnect) and I was deeply involved in the Dynamics GP 2013 Web Client development and readiness efforts.

We’ve recently seen a couple questions on both the community forums and in support cases regarding the ability to add resources that are contained in the new Action Pane that was introduced in GP 2013 R2, to VBA. 

When you go to Microsoft Dynamics GP > Tools > Customize > Add Fields to Visual Basic… you will see that your mouse cursor changes to symbolize you are now adding fields to VBA rather than simply selecting them.  The problem arises when you hover over a button on the Action Pane, for example the Save button.  You’ll notice that the cursor changes back to an arrow.  You’re not allowed to add the field to Visual Basic, which can certainly hinder customizations that many of our customers and partners want to create.

The solution that we’ve found for this issue is to go to the Microsoft Dynamics GP > User Preferences window and change the Window Command Display option to Menu Bar. 

You then need to log out and back into Dynamics GP to finalize this change.  You are then able to add your buttons to VBA just like you could in previous versions.  Just to refresh your memory, here’s what the Action Pane looks like:

And here’s the Menu Bar:

This change should only be required to get the fields into VBA initially.  After the development task has been completed the customizations should work the same for users who are using Menu Bar, Action Pane Strip or Action Pane.

Hope this helps for those of you who are looking into Visual Basic to meet your customization needs in Dynamics GP 2013 R2!

Enjoy!

Lucas

Originally posted here:
Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

August 18, 2014 · Lucas Miller · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 463

Windows Phone 8.1 Update 1, Cortana and Car Bluetooth continued

David Meego - Click for blog homepageLast week, I posted an article about a really cool new feature in Windows Phone 8.1 Update 1 (currently available on Developer Preview).

See the blog Windows Phone 8.1 Update 1, Cortana and Car Bluetooth for details how to add Cortana as a contact to your car’s Bluetooth system to allow you to use Cortana on a car system that does not normally support using the phone’s voice dialling capabilities.

Over the weekend, I discovered something else that makes this new feature even more amazing.

Normally, to get Cortana working the following exchange has to happen:

  • Me: Press Phone Button
  • Me: “Dial Name”
  • Car: “Please say the name”
  • Me: “Cortana”
  • Car: “Would you like to dial Cortana”
  • Me: “Yes”
  • Car: “Dialling Number”
  • Cortana: “Beep”

This process takes some 15 to 20 seconds before I can talk to Cortana.

What I discovered, was that if the last number dialled was Cortana (which it will be if I use Cortana for everything), then pressing the hangup/redial button would call Cortana.

So the process is now:

  • Me: Press Redial Button
  • Cortana: “Beep”

Perfect.

 

While talking Cortana, check out these latest videos:

Get Started with Cortana (direct link)

(Please visit the site to view this video) 

 

Siri vs. Cortana – Happy Anniversary (direct link)

(Please visit the site to view this video)

  

Enjoy

David

Original post:
Windows Phone 8.1 Update 1, Cortana and Car Bluetooth continued

August 13, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 356

Reporting on quantity values from Microsoft … – MSDN Blogs

Management Reporter can be used to create some great operational reports. Linking a report to Excel is one great way to get at additional data, but actual quantity or budget quantity values can be used for statistical data as …

Original post:
Reporting on quantity values from Microsoft … – MSDN Blogs

August 8, 2014 · Ryan Sandness · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 278

Windows XP Artık Resmi Emekli | Guney59 Paylaşım

Başlık linkini kısa tutmak zorunda olduğum bugünki konumuz, Dynamic Blogger‘un kendi eklentisi olan FeedBurner Abone Ol Rss eklentisinin farklı bir anlatımını kapsıyor. Dinamik blogger’un şu anda … kodları metin gadget’ine yapıştırın. Windows XP Artık Resmi Emekli | Guney59 Paylaşım

August 6, 2014 · Adnan Guney · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 147

Deploying Business Analyzer Companion App Services on Windows Azure Service Bus

Business Analyzer App for Windows 8.1

If you are not using Business Analyzer today, shame on you. Last year sometimes I wrote a small article on how to deploy the Business Analyzer Windows 8 application on a personal laptop, which is typically how most of us road warriors need it to be for demo purposes. However, here at Intelligent Partnerships, we’ve changed our approach a bit: all our infrastructure and demo environments now reside on Windows Azure, which gives all of our people the flexibility of having a single environment and consistent across the board, while allowing our accounting staff to do work from anywhere in the world.


Today, I want to talk about another one of those cool features in Windows Azure: The Azure Service Bus and how you can leverage it to run the Business Analyzer app for Windows 8.1.

I really don’t like to oversimplify anything, but think of Azure Service Bus as cloud based message queuing system, akin to MSMQ, but running on a much more robust platform. The advantage is that applications are no longer bound by myriads of layers (like firewalls, complex authentication, etc.) to communicate with each other and can reside anywhere and on any device that can communicate to the Internet.

So let’s get started…

1. To setup a Service Bus you sign into Azure’s management portal, then click on the Service Bus option on the left navigation bar.

Service Bus service

2. Click the Create button to add a namespace for your service bus. The namespace identifies the service in Windows Azure and is assigned an address. You can then choose the region where your service will be hosted.

Service bus namespace

By clicking the Ok button, Windows Azure proceeds to activate that namespace if it’s available. If it’s not available, you will be prompted to enter a new namespace, before you can continue.

3. You can then proceed to install Business Analyzer Companion App Services on one of your virtual machines (preferably not your SQL Server). The installation is straight forward and all you need to do prior to running the setup executable program (setup.exe) is to install the reporting services configuration reports for Business Analyzer. Those are provided in the Companion App services SSRS zip file (MDGP2013_CompanionAppServices_SSRS.zip).

4. Once the Companion App Services application is installed, you can proceed to launch the configuration app, which can typically be found in the C:Program FilesMicrosoft DynamicsGP Companion App Services folder.

Welcome screen

The Welcome screen displays the Companion App Service current connection information, which should later on be replaced by the settings you establish for this instance.

5. After the Welcome screen, you are presented with the Windows Azure configuration screen.

Windows Azure Service Bus Configuration window

In this window you will enter information about the Service Bus you previously configured using the Azure management portal. For the most part you specify the namespace, issuer, and issuer key which can be found



Service Bus connection information

Note the default issuer and default key must match the issuer name and issuer key, respectively, in the Azure configuration window. Click Next to continue – you will experience a short delay while the wizard validates the Azure service bus information you provided.

6. On the Host Configuration screen you can enter the host name and port of the machine that’s going to be running the service – typically, just accept the default port. The beauty here is, since we already configured access via the Azure service bus, it’s not necessary to expose the public name (server.cloudapp.net) of the host and create an end-point for the port, thus exposing our servers to the world – this is why we created the service bus to begin with!



7. Next on is to select the Companion Apps that will be used with the service. You will want to mark both of them here.

Select Applications

8. You will then want to choose the Data Connections to use with Companion App Services. In this case you have a choice of either Excel Reports or SQL Server Reporting Services reports.

Data Connections

9. Next you must identify where to find the Excel reports using UNC path to specify the folder. My reports happen to be at servernamegpfilesexcel reportsreports.

Shared Excel Reports folder

10. You are now asked to enter the address to Report Server and specify a folder where the reports can be found, if you happen to have multiple instances of GP deployed.

If you have deployed SharePoint Integrated mode, then click the checkmark and specify the library address for the reports.

11. Once the report server information is validated, you will receive a confirmation page with the address to be used when configuring the Business Analyzer application.

Configuration Complete window

The address we are particularly interested in is the Service Bus address, which in this case is simply ip-contoso. (with the period at the end).

12. Open the Business Analyzer application, the go to the Configuration window from the Charms on the right. You can then enter the ip.contoso. address in the service configuration.

Business Analyzer Configuration

Sweet! Now, we have configured BA without really exposing the public address of our Azure VM, which should make system administrators very happy.

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.IntelligentPartnerships.com

See more here:
Deploying Business Analyzer Companion App Services on Windows Azure Service Bus

August 6, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 426

Windows Phone 8.1 Update 1, Cortana and Car Bluetooth

David Meego - Click for blog homepageMy son sent me a YouTube video today that got me really excited, so I had to share his discovery.

My car is a lovely white 2009 BMW 125i coupe. It is my “Mid Life Crisis” car after I had my previous car for 14 years.

 

While I really like the car, there has always been one thing that really frustrated me…. The built in Bluetooth system would only dial pre-recorded voice tags. I could also twiddle with knobs to select numbers, but that is not hands free. I could not call numbers by voice and even though I could respond to a text message, I could not initiate a new one.

I just want a way to use the phone’s voice dialling system, or more recently a way to activate Cortana.

Well, the latest Windows Phone 8.1 Update 1 recently released to people on the Developer Preview has solved this problem. I have set it up and it works and it is brilliant.

Basically, you can add a voice tag to your car’s Bluetooth for Cortana and dial her number 555-555-9876 and she will take over.

Check out the video from Windows Phone Central below:

How to use Cortana in your car with Bluetooth (direct link)

(Please visit the site to view this video)

 

Enjoy

David

PS: Can you work out what the custom number plate means? (hint: the plates were from my previous car which was a green fastback hatch). Post your answers in the comments.

Visit link:
Windows Phone 8.1 Update 1, Cortana and Car Bluetooth

August 6, 2014 · David Musgrave · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 443