Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Can Buyer Description be on PO form using Report Writer?

(0) ShareShare
ReportReport
Posted on by 80

I have been trying to get the Buyer description data on PO form but I could not find it in the report writer.

I can get the Buyer ID but not Buyer Description.

Is anyway I can get this data and print out on the PO form?

Thanks for your help.

Toshi 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can Buyer Description be on PO form using Report Writer?

    Hi Toshi,

    We can achieve the above process either by VBA , table relation & custum RW funtion.

    Best way is creating custom RW function

    1)  Create a calculated String field

    2) create a custom RW function as follows.

    function returns string BuyerDesc;

    in 'Buyer ID' BuyerID;

    release table POP_Buyer;
    range clear table POP_Buyer;
    clear table POP_Buyer;

    range table POP_Buyer where physicalname('Buyer ID' of table POP_Buyer) + " = '" + BuyerID + "'";

    get first table POP_Buyer ;
    if err(table POP_Buyer) = OKAY then
    BuyerDesc = Description of table POP_Buyer;
    end if;

    3) Open the calculated field, choose our custom function under function tab

    4) once the function is added assign the Buyer ID from the Purchase Order Work (header)

    5) Drag the field to the report.

    Note: Custom RW function is preferred more to avoid Table Hierarchy error(Setting Custom Relation ship) 

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,144 on at
    RE: Can Buyer Description be on PO form using Report Writer?

    Even though this is an old post, for the benefit of those like me that may search this, you don't need to use vba.

    You can create a new table relationship between the POP Header Work and the Buyer Table.

    The tables concerned:

    POP10100 | POP_PO | Purchase Order Work

    POP00101 | POP_Buyer | Buyer Master

    Link on Buyer ID

    This post has a great step by step from Leslie Vail on linking tables together (obviously, replace table names with details above):  community.dynamics.com/.../123509.aspx

    The description field can then be pulled onto the Purchase order.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can Buyer Description be on PO form using Report Writer?

    Yes, it is possible BUT with a bit of VBA code on it.

    The approach is like; you have to add a calculated field and then add this report to VBA, add the calculated field and then the Buyer ID to VBA. Then retrieve the Buyer Description from Buyers Table by passing the Buyer ID thru' either ADO SQL execution OR Continuum & Dex Table Buffer method.

    Straightforward method other than the above; I seriously doubt.

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