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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    Jen Capco Profile Picture
    55 on at

    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 )

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    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
    55 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans