Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Microsoft Dynamics GP 2013 Service Pack 1 updates ABN Lookup Feature

Microsoft Dynamics GP 2013 Service Pack 1 updates ABN Lookup Feature

Rate This
  • Comments 5

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:

[Edit] Please ensure that these addresses are enabled for the entire system without needing any form of authentication. As no authentication is passed with the web services requests, you must add the addresses to the "Non-Authenticated" list of your proxy or firewall server.

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

 

[Edit] We have discovered that this new window only works for the 'sa' user at this time. We are working on a hotfix, it should be available shortly AFTER GP 2013 SP2 (approx. September/October). If you have a customer with this issue please log a support case referencing Problem Report 69973. The case will be non-chargeable.

Please contact Microsoft to obtain the Business Activity Statement Hotfix 1 (build 12.00.1468) or later which can be applied to GP 2013 SP2. It will also be included in SP3. You can also add BAS_ABRDisableWebService=TRUE into the Dex.ini to restore the old behaviour. Currently there is a Hotfix 2 build which fixes another minor issue as well as the issue mentioned here.

 

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

David

30-Jul-2013: Added note about known issue.

26-Sep-2013: Added hotfix information.

14-Feb-2014: Added more hotfix information.

06-Aug-2014: Added note about proxy or firewall settings.

Attachment: UsingABNLookupWebServices.pdf
  • Hi David,

    Fantastic stuff!!!

    Seems like this works for sa but does not work for any other user even POWERUSER on same machine with same windows credentials. I have reproduced this behaviour on my machine in Fabrikam. Is there any other setting I need to check?

    Thanks,

    Rubal

  • We have the same issues where we can only access this as 'sa'. All other users, even  when assigned the POWERUSER role, can not access this window.

  • Hi Rubal, James and Susan

    We are looking into this issue with the new window only working for 'sa'. Both development and I have been able to replicate the problem.

    We are working on getting a fix. Please log a case for any customers having this issue and mention Problem Report 69973. The case will be non-chargeable.

    You can add BAS_ABRDisableWebService=TRUE into the Dex.ini to restore the old behaviour.

    David

  • Hi David,  I've checked the fix list for GP2013 SP2 and there doesn't appear to be a fix for the ABN issue listed there (ABN Lookup only available for "sa").  Did this fix get added in or did it miss out?

  • Hi Irene

    No, the fix did not make it into Service Pack 2. That is why a BAS hotfix was released after Service Pack 2.

    You need this hotfix or later to resolve the issue.

    Thanks

    David

Page 1 of 1 (5 items)
Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post