Open Forum

Expand all | Collapse all

Item Master Description on PO Blank Form

  • 1.  Item Master Description on PO Blank Form

    TOP CONTRIBUTOR
    Posted 13 days ago
    ​​I'm trying to get the item description from the item master to print on the PO Blank Form when the line item is an inventory item. If it's not, I want the description entered on the PO.

    I'm using a calculated field based on the value of Non IV field. Unfortunately, that field is returning nothing so the calculated field is returning nothing.

    If anybody has an idea, I'd be obliged.

    Thank you

    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Item Master Description on PO Blank Form

    GPUG ALL STAR
    Posted 10 days ago
    Hi @Charles Allen

    You should be able to get this to work with a relationship to the Item Master table.

    However, if you still have trouble, a quick customer user defined RW function created with GP Power Tools can provide this for you very easily. I would be happy to write the code and provide you with the configuration setup file.

    Regards

    David​

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Item Master Description on PO Blank Form

    TOP CONTRIBUTOR
    Posted 10 days ago
    ​Thank you, David. The problem I'm having is getting the value of Noninven to show and then use as part of an expression. I've added the field to the report but get nothing to print. So, if that field won't print a value then the calculated field won't work, either.

    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Item Master Description on PO Blank Form

    GPUG ALL STAR
    Posted 10 days ago
    Hi @Charles Allen

    My plan was to pass the transaction line key fields to a Custom GP Power Tools RW function which would look at the Tables and return the description from the item or from transaction line as per your requirements.

    I would either be able to check the NonIV flag or look up the item in the Item Master table.

    So I am very sure this method will work fine.

    Let me know if you want more information.

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: Item Master Description on PO Blank Form

    GPUG ALL STAR
    Posted 10 days ago
    @Charles Allen and @David Musgrave,

    Kinda sounds like a table relationship thing.​​ I've opened the report definition for the POP Purchase Order Blank Form (that's the one I assume you're using) and this is what I see in the Report Table Relationships:


    Are you trying to hang the Item Master off of the Purchase Order Line Rollup Temp? This is the list of current Relationships for that table:


    Is this where you've created a relationship to the Item Master?

    Then where do you want to place the calculated field? In one of the zillion headers? It would be instructive if you could give details of what you're trying to do... with pictures!

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------

    GPUG Summit - Post


  • 6.  RE: Item Master Description on PO Blank Form

    TOP CONTRIBUTOR
    Posted 9 days ago
    Thank you for your feedback.

    In my vanilla environment, I've got everything working well. In it, I joined Purchase Order Line TEMP to Purchase Order Line Rollup Temp. Then I joined Item Master to Purchase Order Line TEMP. A calculated field based on the Noninven field is working well.

    Unfortunately, the client is using MEM and the PO is coming from that dictionary. That one doesn't seem to be working the same way.

    Charles



    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------

    GPUG Summit - Post


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