cancel
Showing results for 
Search instead for 
Did you mean: 

How to add a new column as "Warehouse name" in Goods Receipt PO screen?

Former Member
0 Kudos

Hi, Experts

I hope to add a new column or just "display" warehouse name besides Whse column in Goods Receipt PO. How can I do?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You need a UDF and an FMS to get the Warehouse name.

Thanks,

Gordon

Former Member
0 Kudos

But how to? Sorry, I am not familiar with UDF. Could you give me more details?

Thanks

Former Member
0 Kudos

I cannot find Good Receipts PO in User-Defined fields Management. So where can i add it?

Former Member
0 Kudos

UDF - User Defined Field. You can add it under Marketing Document Lines. Be careful when you add. Only one user supposed to be in the system.

Former Member
0 Kudos

Can you advise how to write the query as above requirement in topic? I want to learn. Thanks.

Former Member
0 Kudos

I wrote a draft. I just wonder how to get value from B1 screen. Please advise. Thanks a lot.

SELECT t0.WhsName from OWHS t0

where t0.WhsCode = $[$38.11.0]

And try to use it in UDF in Goods Receipt PO rows. When whse code updates, it display accordingly. But it seems not work.

How to do it?

Thanks

Edited by: Christina Du on Sep 14, 2010 3:03 AM

Former Member
0 Kudos

Try:

SELECT t0.WhsName from OWHS t0

where t0.WhsCode = $[$38.24.0\]

Former Member
0 Kudos

still not work.

Maybe I did something wrong in UDF definition. Please help to check. Thanks

I named UDF as WhseName, and set it as Alphanumeric and lengh is 20, structure is Regular. And all below check-boxes are not ticked.

And in Goods Receipt PO screen, I marked the UDF as Visible and Active.

Then I ALTSHIFF2 in the UDF fields, and FMS screen displayed.

Then I chose the 3rd one: Search in Existing User-defined value According to Saved Query

T05

Auto Refresh when field changes is not ticked.

Former Member
0 Kudos

It works. I know what's wrong now..

Thanks Gordon. You help me a lot.

Answers (0)