Skip to main content

Notifications

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) / How to add Item Note i...
Microsoft Dynamics GP (Archived)

How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

(0) ShareShare
ReportReport
Posted on by Somesh Sahu 65

Hi,

I  need to display the value of ‘Item Note’ field with each record in the OrderLine section on the 'POP Purchase Order Blank form'. For this, I added a new relationship between Item Master’s NoteIndex to SY03900 NoteIndex and then put the TXTFIELD in the report in the Orderline section but report does NOT display its value at runtime.

I have made the change using 'Modify' button available on the toolbar on the Report. I do not have prior experience of modifying existing GP report.

Below is my analysis ---- OrderLine fields (like Item Number, Description etc) are from table ‘popPOLineRollupTemp’ (Purchase Order Line Rollup Temp) which is a TEMPORARY table. I think that a field must be present in this table if it is to be printed. To verify this, I added column ‘PO Line Status’ from table ‘popPOLineRollupTemp’ and ‘PO Type’ from table POP_POLine_Temp (Purchase Order Line Temp) in the OrderLine section. On running the modified report, PO Line Status appeared as ‘Released’ whereas PO Type did not appear. So, I think we need to add ‘TXTFIELD’ column of SY03900 table in the Temp table ‘popPOLineRollupTemp’ but I could not find the way to do it from GP help or any internet forum on GP.

I am using Version 10.0 of Dynamics.

Please let me know if my understanding is correct and the resolution or workaround for this problem.

Awaiting your reply,

Thanks in Advance,

Somesh

*This post is locked for comments

  • Somesh Sahu Profile Picture
    Somesh Sahu 65 on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    Hi Sagi,

    At last I am succeeded in displaying the Item Note with each OrderLine record in the report.

    I added 'Item Note'  using the relationship ‘Purchase Order Line Rollup Temp (‘popPOLineRollupTemp’) > Item Master > Records Note Master’. I was earlier making mistake by using table POP_POLine_Temp (Purchase Order Line Temp) in creating relationship so the value was not displaying.

    I am putting my steps for reference if some one else needs -

    1. Open the report in modify mode

    2. Go to Tables > Tables

    3. Select popPOLineRollupTemp. click Open button.

    4. Create Relationship with Item Master on ItemNumber.

    5. Similarly created relationship between IV_Item_MSTR and Records Notes MAster on NoteIndex.

    6. Add table ItemMaster in the related tables linked to popPOLineRollupTemp. Also add Records Notes MAster in the related tables.

    7. From the toolbox, Drag and Drop the TextField in the OrderLine section.

    I will also do it following your suggestion and will let you.

    Thanks a lot for your suggestions and time,

    Somesh

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    Hi Somesh.

    The field should be placed in the H3 section of the report. Once there ddouble click the field and make sure it is set to data.

    Also, try placing the NOTEINDX field on the report and validate that the field value is not zero. If it is it may be that the link between the Purchase ORder Line Temp and the Item Master is not correct.

    Using Tools - Customize - Customization Status you can export the report into a ppackage.  Feel free to email me this file and I can better see what the problem.

    I will send you a sample of mine that displays the note

  • Somesh Sahu Profile Picture
    Somesh Sahu 65 on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    Hi Sagi,

    Thanks once again for the reply.

    I did the same as per your above suggestion and added a calculated field for 'Item Note' using same function RW_GetNoteText'( 'IV_Item_MSTR'.'Note Index'30 1  ). But still its value is not displaying. I tried by putting the new field in the different sections like H3- ItemHeader1, H4 -Comment3 Header, Item Tax, Body. I also tried by adding a new section based on Report table 'POP_POLine_Temp (Purchase Order Line Temp) '.

    Can you please let me know in which section I need to put this field or on which table new section needs to be created.

    Sorry, I am asking you simple questions as I am novice to GP report writer.

    Please reply at your earliest convenience as I have to deliver the solution to client urgently.

    Thanks a lot once again for your time and effort.

    Somesh

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    You may want to try the RW_GetNote Text function that GP supplies.

    You will find this in the user-defined functions under system when creating a calcualted field.

    To use select the function and the select the note index field from the item master followed by a number for haow many caharacters and then a line number usually 1.

    It should look like this:

    CalculatedField "Item Note"

    'RW_GetNoteText'( 'IV_Item_MSTR'.'Note Index'30 1  )  

    ResultType "String"

  • Somesh Sahu Profile Picture
    Somesh Sahu 65 on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    Hi Sagi,

    Thanks for the reply.

    I verified that radio button beside the modified version is selected in Purchase section.

    I am running the modified report as I can see other changes in the report. But, Item Note is NOT displaying the value.

    Have you ever made such change in the Purchase Order or Sales Order Blank Form report?

    If Yes, then please let me know the solution.

    Thanks,

    Somesh

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to add Item Note in the OrderLine section of the POP Purchase Order Blank Form

    Hi Somesh.

    Verify that you have access to the modified version of the report.

    In the Administration Pane, under System you will see alternate windows and modified reports.

    Choose the profile and the reports.

    In the Purchases section you should see your report.

    Make sure the radio button beside the modified version is selected.

    Hope this helps

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans