How to get the Prefixnumber of salesorder to the Prod.order-->Issue&Receipt

This question is answered

Hi Experts,

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..

Regards,

Magesh.

Correct Answer

October 23, 2007 at 09:19 AM

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>

Suda

0 Likes 0 View this answer in context