web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writer
Microsoft Dynamics GP (Archived)

Report Writer

(1) ShareShare
ReportReport
Posted on by Community Member

Hi all....

i'm trying to customize RM Reprint Sales Posting Journal to be a copy of 

RM Sales Posting Journal.

the only problem i have is to show the Record Note Master in the RM Reprint Sales Posting Journal


even i export both reports and i tried to copy the package file but its not working too.

any ideas how to do it ?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Any help

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Create a calculated field with passing SOP Note index value to this function "RW_GetNoteText". It will give you the note index text value.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    thanks soma

    i try it but not working can u give me more details or screen shot ??

  • Community Member Profile Picture
    Community Member on at

    unfortunately its not working

    can i have a screen shot or something

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Hi,

    I have checked this "RM Reprint Posting Journal" report, there is no table which is containing the Note Index value for the Sales Document. So, you can not use the default function RW_GetNoteText (because this function required note index).

    Better create a new RW function to get the note index text with using the parameter RM Document Type-All & Document Number from the table RM Document Temporary File (RM_Document_TEMP).

    Hope this helps!!!

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi,

    1.)  Create a table relationship between RM_Document_TEMP and the RM History File, using RM_HISTORY_Key4 (both fields in the key match so you'll end up with a 1:1 relationship).

    2.)  Link the RM History File to the report via the RM Document Temporary File.

    3.)  Link the RM Open File to the report via the RM Document Temporary File.

    4.)  Create a Conditional Expression to retrieve the note index:
          Name:  (C) NoteIndex
          Conditional:      RM_OPEN.Note Index  =  0.00000
          True Case:        RM_HISTORY.Note Index
          False Case:       RM_OPEN.Note Index
          Result Type:      Currency

    5.)  As per Soma's recommendation use the RW_GetNoteText function to retrieve the actual text.  For example, showing just 2 lines of comment:
          Name:  (C) NoteText1
          Calculated:       FUNCTION_SCRIPT( RW_GetNoteText (C) NoteIndex 80 1  )
          Result Type:      String

          Name:  C) NoteText2
          Calculated:       FUNCTION_SCRIPT( RW_GetNoteText (C) NoteIndex 80 2  )
          Result Type:      String

    6.)  Drag the (C) NoteIndex 1 and (C) NoteIndex 2 onto the layout.

    Thanks,
    Justin

  • Community Member Profile Picture
    Community Member on at

    hi justin..

    thanks for your reply...

    i tried to the steps which u mention one by one i did exact what you said but while im still getting error while printing the report 

    Undefined Symbol 'F0011D00056Text Field'

    Calculation.png

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Remove all unused/unwanted calculated fields from your modified report and try again.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    dear soma,

    thanks for your reply but i didn't add any cal fields rather than those which mentioned by justin... plus that i was not getting this error before adding those cal fields it means something goes wrong while i'm creating those fields which added newly

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi,

    In Report Writer, highlight your report, then click the "Validate" button and let me know the results.

    Did you do anything else to the report?  Remove any tables, or remove any fields from the layout, etc...?

    Thanks,

    Justin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans