Following on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake.
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.
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.
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.
And I meant alien in the best possible way. ;)
You may very well be an alien (and I suspect you are), but you're OUR alien and we will always be at your side!
Looking forward to seeing you in Fargo!
When you refer to Both fixes should be removed once the original code is fixed. do you mean when the next service pack is released to fix this then we should remove the code?
The fix for GP 2013 will be the next hotfix release, due in November.
It will also be fixed in GP 2015.
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.