Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP Report Writer Calcu...
Finance | Project Operations, Human Resources, ...
Answered

GP Report Writer Calculated fields appearing on standard but not blanket PO

(0) ShareShare
ReportReport
Posted on by Jen Capco 55

We need to have up to 12 comment lines show on line items on our purchase orders. I followed this GP Report Writer tutorial here: https://community.dynamics.com/gp/b/gpmarianogomez/posts/adding-more-comment-lines-to-pop-purchase-orders EXCEPT I could not figure out the suppress line comments: sSuppressComment1 = F6_LAST (C) Line 1 Comments = "" AND  F6_LAST (C) Line 2 Comments  = "".

I can find a field for "F6_LAST Line 1 Comments" but not "F6_LAST (C) Line 1 Comments" and modifying that throws an error.

Even without suppressing the comments, the new calculated fields appear on Standard POs, but no comments appear on Blanket POs. Blank lines do appear on the Blanket POs.

I would like to find out more about the fields that go into the expression (Line 1 Comments = FUNCTION_SCRIPT( RW_POPLINECommentText POP_PO.PO Type POP_PO.PO Number popPOLineRollupTemp.Ord 80 1 ), especially the "POP_PO.Po Type" field. I'm wondering if this could be my culprit. Is there a resource that goes through the Purchase Order Work Fields?

Thanks in advance for any advice.

Categories:
Microsoft Dynamics GP
  • Verified answer
    Jen Capco Profile Picture
    Jen Capco 55 on at
    RE: GP Report Writer Calculated fields appearing on standard but not blanket PO

    Beat Bucher,

    Oh Jeez! that is the post I followed to set it up, and yet somehow I missed the function definition. That was exactly what I needed.  Thanks.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: GP Report Writer Calculated fields appearing on standard but not blanket PO

    Hi Jen,

    Glad you figured it out. Maybe you already looked at this, but just in case:

    dynamicsgpblogster.blogspot.com/.../adding-more-comment-lines-to-pop.html

    winthropdc.wordpress.com/.../

  • Verified answer
    Jen Capco Profile Picture
    Jen Capco 55 on at
    RE: GP Report Writer Calculated fields appearing on standard but not blanket PO

    I found the answer. The variable POP_PO.Po Type is an integer indicating the PO type: PO Type: 1 – Standard 2 – Drop Ship 3 – Blanket 4 – Blanket Drop Ship

    By replacing it with a hardcoded 1, the function now works on both Standard and Blanket POs. Using GP Dynamics 16. This could break on upgrades.

    FUNCTION_SCRIPT( RW_POPLINECommentText 1 POP_PO.PO Number popPOLineRollupTemp.Ord 80 1 )

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans