Buyer Description on Purchase Order

(0) Share

Report

Posted on by Community Member

We would like to have the Buyer's name display on the purchase order instead of the Buyer ID. I have tried to establish a relationship with the Buyer Master table and the Temp Work table used in the PO. When I try to link the tables, there are no fields available to link to on the Work table. I'm sure this has been done before. Does anyone know of a tutorial on this I can use to figure out what I'm doing wrong? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Take a look at this related post form Dave Musgrave:

blogs.msdn.com/.../using-the-built-in-report-writer-functions.aspx

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

Try adding relationship from "Purchase Order Work" (POP_PO) to "Buyer Master" (POP_Buyer) table using "Buyer ID" field. It works when I tried on mine.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Someone has been here before asking about the same issue

Can Buyer Description be on PO form using Report Writer?

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Since its straight, you can use table relation ship to retrieve Buyer name.

You can also use Custom RW function, or through VBA code to retrieve the same. you can find more details mentioned by Mohamad Al Saadi

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is what I was trying to do, but got stuck when the BuyerID field would not display to select from the POP_Buyer table. I tried again this afternoon and was able to successfully complete the relationship. I added the Description field to my PO and set the BuyerID field to not visible, rather than delete it. Unfortunately, the PO is still displaying the BuyerID and not the Description. I have the modified form selected in the security settings, so that is not the issue. I guess this is my next issue to solve.

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report

Since the introduction of GP 2013 I've seen a number of issues with the difference between a report header and page header when modifying various documents. If you modified the page header instead of the report header, you will not see the changes displayed on the first page of the report. You need to modify the Report Header.

This can be a little tricky, so make sure you've backed up your reports.dic or made a report package of the report you're going to be modifying prior to making edits.

Was this reply helpful? Yes No