How to modify Purchase Order Release Search

[ypan]

Hi All,

Is it possible to modify what is shown in Purchase Order Release search? This search is showed up in Receipt Entry - New Receipt Line - Click “Line/Rel…” button. We want to add part description in the searched result.

I tried “Quick search entry” by linking to a BAQ; however two things happen:

1. When I clicked “Line/Rel…” button, the quick search entry I just created did not show up. I had to right click the line filed (i.e. the first entry box next to “Line/Rel…” ) and selected the quick search entry that I just created;
2. After I right clicked the line field and selected the quick search entry that I just created, all PO records showed up. In other words, the shown records did not just limit to the PO that was selected in the PO field. In the attached example, PO #500725.

I have spent the whole day to figure this out and would really appreciate any help you can provide.

Thanks.

[ckrusen (Calvin Krusen)]

Its not very straightforward as most searches are designed to return a single value (OrderNum, PartNum, etc…) and that particular search needs to return 2 values, one for the line and the other for the release.

I think this has been addressed on this site. Keep searching. If i come across it, I’ll post it.

[ckrusen (Calvin Krusen)]

Here’s a post about a BAQ search whe two values are required

Quick Search for PO Line to include Comments

There are two issues you need to overcome - You need to have the Quick Search Available in your Search Context. To do that, you need to make sure that the BAQ has a BAQ Search Like Column that matches the Context Key on the Quick Search definition form - in your case RcvDtl.POLine. In the BAQ definition form, have a look at the On-Line Help and the “BAQ Search” Sheet. When a standard Search returns multiple columns, you can usually use a Return Column in the Quick Search of SysRowID for th…

[ypan]

Thank you so much, Calvin! I will take a look at this post!

[Nancy_Hoyt]

Hi ypan,

Did you ever figure out a solution to this PO line/receipt search customization in Receipt entry? I am having the same problems as many here, needing to show another column of data in the search, and am having a heck of a time figuring out how best to do it. Whatever I make doesn’t show just the current PO lines/rels, it shows all of them. That’s not foo useful…

thanks,
Nancy

[RajababuSingh (Rajababu Kumar Singh)]

Hello Ypan,

Your problems solved or not ?

[patel_saif]

Hello ypan,

Did you ever figure out the solution to this ?I am having a similar situation to add a column to search grid of PoLine.

The Quick search showed up when used it from Release but not sure how to return two values in Kinetic.

Thanks