Formatted Search
Hi Experts,
I want to import a Person name field in the ProductionOrder to the Receipt Form of production , the PersonName(is a userdefined field) in the Productionorder window &Receipt form,if a production order is raised and it is released,and when a receipt is given the Person name value should automatically be transferred from ProductionOrder to the receipt window.what property should be set in the 'formatted search' (AltShiftF2)to import this Person name??
Regards
Magesh.
Former Member replied
Magesh,
Create a formatted search with the following SQL. Change the <i><b>U_UserField</b></i> with the User field name from your Production Order table.
SELECT <i><b>T0.U_UserField</b></i> FROM [DBO].[OWOR] T0 WHERE T0.DOCNUM = $[IGN1.BaseEntry]
Link this formatted search to the User field in your receipt from production screen.
Auto refresh does not seem to work because no Form field changes after you select the Production Order. Probably you have to manually hit SHIFT+F2 for now.
If I find something I will come back.
Suda