Microsoft Dynamics GP 2013 Service Pack 1 updates ABN Lookup Feature

David Meego - Click for blog homepageBack in June 2011, we reported that an Australian Business Register update breaks ABN Lookup Feature. Within a couple of weeks, the Australian Business Register (ABR) team did add a URL direction which allowed the ABN (Australian Business Number) Lookup via a web browser to continue working.

What this highlighted was that the method of using a web browser URL to access the ABN Lookup was no longer supported and could be altered at any time in the future.

Below is an example using the ABN Lookup Website:


http://abr.business.gov.au/SearchByAbn.aspx?SearchText=29002589460

The officially supported method to access the ABN Lookup was by using Web Service calls. We tried to get the changes to use the Web Services in place for the release of Microsoft Dynamics GP 2013, but sadly did not get the code finished and tested in time.

So with the release of Microsoft Dynamics GP 2013 Service Pack 1, sites with Australian companies (installed using country of Australia) will now have the updated Business Activity Statement Reporting add-on (BAS_RPRT.DIC) including the new ABN Lookup window which calls the ABR Web Services and displays the returned data.

So when you click on the globe icon next to a ABN field on the Company, Debtor/Customer, Creditor/Vendor windows, the window below will open:

 
New ABN Lookup window

You can use the tabs in the bottom half of the window to review additional data about the ABN.

 

While this change is a great improvement in functionality, it does rely on being able to access the Web Services. So if you are using a proxy server or some sort of URL blocking, please make sure the Web Service End Points below are added to the “Allowed” list. 

Web Service End Points:

Attached to the bottom of this post is the documentation about the Web Services.

  

Thanks to the developers who worked on this cool new feature. 

David

Originally posted here:
Microsoft Dynamics GP 2013 Service Pack 1 updates ABN Lookup Feature

July 15, 2013 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,481

Update Rollup 14 for Microsoft Dynamics CRM 2011 is available!

Update Rollup 14 for Microsoft Dynamics CRM 2011 is available. This article describes the hotfixes and updates that are included in this update rollup

Read More:
Update Rollup 14 for Microsoft Dynamics CRM 2011 is available!

July 12, 2013 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 283

You Cannot Print An Unauthorized Purchase Order

As the title says, “you cannot print an unauthorized purchase order”. This is an error message which I encountered the other day on my demo system when I was trying to print a PO. Now, I’m largely not surprised to … Continue reading

See the original article here:
You Cannot Print An Unauthorized Purchase Order

July 12, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 780

Worldwide Partner Conference nearly complete!

So five fantastic, action-packed days in Houston are now coming to an end, as the Microsoft Worldwide Partner Conference 2013 winds down and packs up for another year, and the many thousands of attendees and participants head back to their homes and their daily business rhythms.

If we have done our job well, then returning to your business will not just mean returning to business as usual. Fully informed on future business and product strategy, and inspired by the opportunities that lie ahead, we hope that you are heading home to educate and optimize your businesses to seize the opportunities that beckon.

Hopefully you had time to go deep on some of the ways that you can serve your customers better, more efficiently, and more consistently. And how you can extend your ERP practice and your footprint by offering a complete business solution from Microsoft.

The Houston sun may be setting over the Worldwide Partner Conference, but that does not mean we will be leaving you in the dark when you get back home.

Once you are back in the office, look on PartnerSource for more information on key areas of opportunity.

And whether you were in Houston for the conference or not, you can look for the availability of video recordings of all the Dynamics sessions over the next few weeks. Then be sure to plan your attendance at the Microsoft Dynamics GP Technical Airlift 2013 in September to help you take the next step toward building your own Dynamic Business.

So goodbye from Houston, thank you for your part in making this an incredible conference, and have a great trip home. 

Jay Manley 

Read the original:
Worldwide Partner Conference nearly complete!

July 11, 2013 · Jay Manley MSFT · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 272

Area Page Error – Value Cannot be Null

A client who upgraded to Microsoft Dynamics GP 2013 a few weeks ago began encountering a problem when switching between modules. In particular when they loaded the Purchasing area page they received the following message; Value cannot be null. Parameter … Continue reading

See more here:
Area Page Error – Value Cannot be Null

July 11, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 477

Five Years later: Welcome to the Developing for Dynamics GP blog

David Meego - Click for blog homepageFive years ago today, I decided that I could help the community better by writing about my experiences as a developer, consultant, administrator and support engineer with Microsoft Dynamics GP in a single location.

Previously, I would respond to questions in a number of Microsoft forums and independent forums. By using the blog, I could create a library of information, that would be available to all and easily searchable.

We have come a long way from that original post: Welcome to the Developing for Dynamics GP blog.

Thank you to all my readers, your support has been inspirational to me.

A special thank you must go to a few people who have had a big influence on the blog:

  • Leslie Vail – Who was there are the beginning, twisting my arm to start blogging.
     
  • Mariano Gomez – Who has become a great friend and collaborator after we started working on our blogs together.
     
  • Robert Cavill – Who has known me for my entire Great Plains related career and is one of the best bug testers/finders and proof readers out there.

David

PS: While we are reminiscing, I just updated one of the most viewed blog articles: GP Logos through the years.

Read More:
Five Years later: Welcome to the Developing for Dynamics GP blog

July 11, 2013 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 322

Tech Tuesday: Using Multiple Companies in SmartConnect

As we are getting very close to releasing new SmartConnect Excel Templates for Dynamics GP I am reminded of some really great features we have inside of SmartConnect. Today I want to give you a little insight into using multiple companies from your Dynamics GP implementation.

The new templates will allow you to pick which Dynamics GP company and send transactions into that company without reconfiguring the SmartConnect map each time. How did we do this? The answer is simple, inside of the Map in the Companies button for the destination. Normally in this window you would choose a specific company and check the box to have transactions created in that company. You do have the ability to create records in multiple companies by selecting each desired company. Why would you do this? Great question, and I think there are a variety of answers but here are a couple to think about.
1)      You have a master database of Accounts, Customers, Vendors, Employees and you want to synchronize those records.
2)      You want to use real-time Dynamics GP triggers to automatically create these records in other databases.
Another option is to not have any companies selected at all! How would that work? Well, we have a way to use data from your source to select which company the record should be using for integration. Let me explain a bit more, if you have a field of data that has your company id (database name) you can simply pass that in by using the define button on the companies button and returning that fields value. A simple example script is below:
                Return _GPCompanyID
You can also get a lot more sophisticated if you don’t have a specific field that spells out your company id by using a case statement like below:
                Select Case _mySource
                                Case “Far”
                                                Return = “FAR”
                                Case “Gra”
                                                Return = “GFL”
                                Case “Chi”
                                                Return = “CHI”
                                Case Else
                                ‘If no match is found, return an empty string
Return String.Empty
                End Select
Now you can do things like bring in Journal Entries into multiple Dynamics GP companies with one pass instead of running multiple maps.
I hope today you may have been inspired to try new options in how you setup maps.
Thanks,
Chris Dew
Director of Product Management

Read more here:
Tech Tuesday: Using Multiple Companies in SmartConnect

July 9, 2013 · Abbey · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 439