Can Formatted search be used in this situation?

[Former Member]

Dear Experts,

I have defined a row level UDF called DIA. I input dia values in goods issue. Hence it is stored in ige1 table. When I receive those items in Goods Receipt, the Dia Column found blank. I need to have the dia value entered in IGE1 in Goods Receipt form.

Its some what like this.

Itemcode Qty DIA

a001 10 12

b001 20 20

c001 10 22

When I receive these items after the specified process, I make entry in Goods Receipt based on PO No,. That time, the form

shows blank value in DIA field. I need the DIA values entered for the Items to appear automatically from IGE1. Can I do this using formatted search. Please advise.

Thanks in adv.

Anand

[former_member204969 · Accepted solution]

As I understand, you want to make a goods issue transaction entering these values into the document rows and in an independent transaction (I could not catch it is a goods receipt or a goods receipt PO) to get these values.

First you should make a reference in the second transaction to the original one. The best is to define a header level UDF where you can write the DocNum of the original goods issue transaction (assuming you are using unique document numbers). We can call it e.g. U_SourceDocNum.)

Then you make an FMS like this:

Select  R.U_DIA from IGE1 R inner join OIGE I on R.DocEntry=I.DocEntry
 Where I.DocNum=$[OIGN. U_SourceDocNum] and R.ItemCode=$[IGN1.ItemCode]

And set it autorefresh when SourceDocNum is changes.

(The user should fill the SourceDocNum after filling the document lines!)

In the code I used OIGN and IGN1. If you use goods receipt PO in the second steg, you should replace them with OPDN and PDN1.