Tuesday, June 10, 2014

GP 2013 R2 updates to Report Writer Functions

David Musgrave posted an article about updates and additions he has made to the User-Defined functions he added to Report Writer back in release 7.0. I have added a list and description of those functions to my section about User-Defined Report Writer functions.

There are some incredibly handy functions now available. Check out his post by following this link.
David Musgrave's updates to Report Writer functions
I have copied his entire article below:

"By David Musgrave, View Profile8 Jun 2014 6:00 PM

You might remember the story about how I created a suite of Report Writer functions and got them added to the version 7.0 Dynamics.dic core dictionary. The aim for these functions was to make it easier for partner consultants and customers to modify the reports without needing custom scripting in Visual Basic for Applications (VBA) or Dexterity. They are documented in the Report Writer Functions document in the Software Developers Kit (SDK).

Based on feedback I have received from the community, I have made some changes to a few of the Report writer functions and submitted them to the development team for inclusion in the Microsoft Dynamics GP 2013 R2 (Service Pack 3) code. Below is a summary of the Report Writer (RW) functions changed and what new functionality is available.

RW_CoAddrIDInfo()
  • If an empty string is passed as the Address ID (first) parameter, the address data is pulled from the Company Master (SY_Company_MSTR, SY01500) table instead of Location Master (SY_Location_MSTR, SY00600) table.
RW_PMAddrIDInfo()
  • If an empty string is passed as the Address ID (second) parameter, the address data is pulled from the Vendor Master (PM_Vendor_MSTR, PM00200) table instead of Vendor Address Master (PM_Address_MSTR, PM00300) table.
RW_RMAddrIDInfo()
  • If an empty string is passed as the Address ID (second) parameter, the address data is pulled from the Customer Master (RM_Customer_MSTR, RM00101) table instead of Customer Address Master (RM_Customer_MSTR_ADDR, RM00102) table.
  • For the Field (third) parameter, The values 14 and 15 have been added for the User Defined 1 and User Defined 2 fields respectively.
RW_GetInternetText()
  • Updated Field (sixth) parameter, so that it works without errors. The values of 10 (to), 11(cc) and 12(bcc) return email addresses, any other value returns the internet text field.
RW_ConvertToWordsAndNumbers()
  • Added new mode to support full conversion of dollars and cents to words. The Mode (third) parameter now supports the following three values:
0 = Whole Number in words, Parts in numbers
1 = Whole Number in numbers, Parts in numbers
2 = Whole Number in words, Parts in words *NEW
RW_ConvertToWordsAndNumbersParse()
  • Added new mode to support full conversion of dollars and cents to words. The Mode (third) parameter now supports the following three values:
0 = Whole Number in words, Parts in numbers
1 = Whole Number in numbers, Parts in numbers
2 = Whole Number in words, Parts in words *NEW
Here are some examples of the RW_ConvertToWordsAndNumbers() function in action:
  • RW_ConvertToWordsAndNumbers( 1234.56   ""   0 )
One Thousand Two Hundred Thirty Four Dollars and 56 Cents
  • RW_ConvertToWordsAndNumbers( 1234.56   ""   1 ) returns
** 1,234 Dollars and 56 Cents
  • RW_ConvertToWordsAndNumbers( 1234.56   ""   2 ) returns
One Thousand Two Hundred Thirty Four Dollars and Fifty Six Cents (the above function is incredible; it’s one we’ve wanted for years!) For more information, check out the following blog articles:
Hope you like the improvements.”

Enjoy!

Leslie




















4 comments:

Anonymous said...

Thanks for the helpful information.

Gus said...

Hi Leslie,
Thankas for the information. I seem to be having issues with this function inverting the words, i.e., for an amount of $12.34 this function returns "Twelve Dollars Cents 34 and" Can you help resolve this issue? BTW -- I'm using the Web UI but it has the same issues in all the PC Clients also.

Thanks -- Gus

Gus said...

Hi Again Leslie,
Just after I posted I found a solution to the problem. I posted the resolution for others here:
https://community.dynamics.com/gp/f/32/p/99268/349885.aspx#349885

Thanks for the Help.

Dynamics Confessor said...

Thank you for sharing Gus!