Open Forum

Expand all | Collapse all

PO Comment on Smartlist

  • 1.  PO Comment on Smartlist

    Posted Jul 06, 2020 10:41 AM
    I was wondering if there was a way for the comment from a Purchase Order to show up on a Smartlist. We use the Comment ID's of either service, maintenance or construction then type the call number in the comment. I created a Smartlist for PO's and added a column for Comment ID but can't find a column that would show the Purchasing comment entry. Is this possible? #SmartList
    PO Smartlist
    ​​

    ------------------------------
    Hilary Burchfield
    Office Manager
    Thermodyne
    Jacksonville FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: PO Comment on Smartlist

    TOP CONTRIBUTOR
    Posted Jul 06, 2020 11:12 AM
    Hi @Hilary Burchfield,

    It is possible.  It's all about the tables you link together.

    I would suggest looking at joining the POP10150 (Purchase Order Comment) to one of your existing tables/views.  I did a quick run in my test company using the Purchase Orders SQL view (the basis of the default Purchase Orders SmartList) and joined it to the POP10150 using the PO Number as the join field, and it worked.


    You'll notice there are several comment fields (Comment 1, Comment 2, etc.) - those are populated if you have multiple lines of text.  I believe the "Comment Text" field will concatenate the lines together depending how you want to see them.

    Does that make sense?  If you have questions, please just let me know.

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role