Receipt From production number - Choose From List

[Former Member]

Hi all,

How to filter the Receipt from production number only comes in choose from list. now i used object is 59. when i choose all value comes that means goods receipt, and receipt from production document numbers comes. I want only list out the Receipt from production Numbers only how to i restrict this.

Thanks & regards

B.Sudhir

[Former Member]

As a workaround you can create a UDF on header level of Receipt, and you can mark there the source: UI or production, After this you can create an CFL over this UDF to filter the Production related records.

J.

[Former Member]

Hello

It is very hard to do the CFL, because the information, that is it a receipt from a production is stored on the line level, not on the head level

you can 2 choices

1. define a query which includes all the DocEntry related to the Receipt documents, and on form constuction you add them into the conditions of the CFL (it takes much time to build up the CFL)

2. Define FMS, and assign to your field. And when the user press the TAB key, you call the FMS.

Regards

János

We always done the 2nd method until the cfl was not implemented.

[former_member204969]

For the received from production transactions the IGN1 connected to the OIGN contains 202 as the BaseType.

[Former Member]

Thanks For your valuable replies

But problem is Header no not having the basetype

<ChooseFromList UniqueID="GoodsRecT" ObjectType="59" MultiSelection="0" IsSystem="0">

<conditions>

<condition bracket_open_num="1" bracket_close_num="1" cond_end_val="" cond_value="202" operation="1" relationship="0" compare_fields="0" alias="BaseType" compared_field_alias=""/>

</conditions>

</ChooseFromList>

Thanks & Regards

B.Sudhir

Edited by: B.sudhir on May 30, 2011 2:52 PM

[former_member204969]

Or you might use the JrnlMemo field, where the text refer to the source of the transaction.