Simplifying the query: Can we display the Note Text for any record (for instance, Customer Note, Vendor Note, Item Note, etc…) on a standard GP report? If so how?
I first suggested to write a RW (Report Writer) function, to pass Note Index as the parameter and return the Note Text from the function. The user replied back, saying that he does not deal with 3rd Party Chunks and he customized the report using Report Modifier. Moreover, he does not have VBA.
Challenge: We are left with only Report Modifier. No new table relationship can be defined. No VBA. No user-defined RW Functions.
Then came David’s reply to the same post. He sent us a link from his blog, which explains Built-In RW Functions which can be used for many default requirements. Getting Note Text is one of them. That’s my starting point to explore this.
Solution: Below is the step by step instruction on how we can achieve this, with limited customization tool options, but with abundant Built-In RW Functions. I have modified the Detailed Item List (Run from Item Maintenance Print Button) for the sample. This sample works with Dynamics GP 10.0.
1. Open the report from Report Modifier (or click on Modify from the Report Window).
Add this Calculated Field anywhere on your report, of course on a more relevant place.
To see the sample that I have developed, please visit this link and download the package file: Using Built-In RW Function to Display Note Text on a Report.
Inspired by David’s Article: Using the Built-In Report Writer Functions.
Thanks for this post… It was very helpful!
Vaidy,Do we have step by step same guide for RM Blank deocuments. I want to attach the similar notes into rm blank reports.Any suggestions would be appreicated.Regards,Charles
Pingback: Working with Text fields in Report Writer - Developing for Dynamics GP - Site Home - MSDN Blogs
Vaidy, this is a helpful post, but does it work for Project Accounting? I’m trying to pull notes from the Billing Master Notes Index to a Project Accounting billing format, but the notes are blank. Any ideas?
Hi Gina, I am not quite sure, but if the notes are stored in SY03900 table, it must work. I think, it must be storing the notes on its own PA table. Standard RW_GetNoteText() function is written to bring note text only from SY03900 table. I have to investigate this further. Vaidy
What if I’m using another sap like crystal reports. how do I get the note index to print my notes. Stuck.
You will need to link the table SY03900 (Notes Master) with whatever table that you have as main table on your crystal report.
For instance, if your report is from SOP10100 (SOP Transaction Work Header), then you can link the field NOTEINDX in SOP10100 with NOTEINDX in table SY3900.
The field TXTFIELD in SY03900 will have the note text that you are looking for.
Hope this helps.
Thank you so much for responding. I will try as soon as I get back to the office. This will work because it just makes so much sense.
This does work for Project Accounting as well! I tested with a project note and added it to various PA reports. Linked this RW_GetNote Text function to the PA Project Master table > Project Note Index field and followed the remaining instructions above. Thanks so much, just used this today.
Pingback: Working with Text fields in Report Writer | David Musgrave's Winthrop Development Consultants Blog