How to get the Prefixnumber of salesorder to the Prod.order-->Issue&Receipt
I have created a Prefix no(AH-SO) in the salesorder document the document number range starts from 10001 to 2000
First iam doing a sales order for the parent item without NULL stock
and raising a production order and giving the issue & Receipt for the item.
The value of the Prefix and the saleorder number should get displayed in a UDF field both in the Receipt and Issue from Production.
I have tried out with this query but it is working within the salesorder document window
( select T0.Seriesname + $[$8.0.0] from NNM1 T0 where T0.series = $[$88.0.0])
any other possiblilities of getting these values through Formatted search?
Waiting for your replies..
Suda Sampath replied
You want to put the FMS on the Issue and Receipt from Prod transaction? Correct?
In the Production Order UDF please create a FMS with this query
<b>SELECT T0.BeginStr + '-' + CAST(T1.DocNum AS VARCHAR)
FROM [dbo].[NNM1] T0 INNER JOIN [dbo].[ORDR] T1 ON T0.Series = T1.Series
WHERE T0.ObjectCode = '17' AND T1.DocNum = $[OWOR.OriginNum]</b>