need sale order docnum in query?????

[vinayak_chavan]

SELECT distinct T0.Docentry,t0.docnum,T0.docdate,T1.ItemCode, T1.Dscription, T1.U_jobno, t0.filler,T1.WhsCode, T1.Quantity,T0.Jrnlmemo  FROM OWTR T0  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OWHS T3 ON T0.Filler = T3.WhsCode INNER JOIN OITW T4 ON T2.ItemCode = T4.ItemCode where T1.U_jobno like N'%[%0]%'

[KennedyT21 · Accepted solution]

Vinayak,

SELECT distinct T0.Docentry,t0.docnum,T0.docdate,T1.ItemCode, T1.Dscription,  T1.U_jobno,

t0.filler,T1.WhsCode, T1.Quantity,T0.Jrnlmemo ,Salesorder=t5.docentry FROM OWTR T0

  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry

  INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode

   INNER JOIN OWHS T3 ON T0.Filler = T3.WhsCode

INNER JOIN OITW T4 ON T2.ItemCode = T4.ItemCode

inner join ORDR t5 on t5.CardCode=t0.CardCode

inner join RDR1 t6 on t6.DocEntry=t5.DocEntry and t6.ItemCode=t1.ItemCode

where T1.U_jobno like N'%[%0]%'

Regards

Kennedy

[vinayak_chavan · Accepted solution]

0 records

[KennedyT21 · Accepted solution]

How do you link sales order in transfer?

Regards

Kennedy

[vinayak_chavan · Accepted solution]

ya thats not possible

[KennedyT21 · Accepted solution]

Have you used the U_jobno

if so

try this

SELECT distinct T0.Docentry,t0.docnum,T0.docdate,T1.ItemCode, T1.Dscription,  T1.U_jobno,

t0.filler,T1.WhsCode, T1.Quantity,T0.Jrnlmemo ,Salesorder=t5.docentry FROM OWTR T0

  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry

  INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode

   INNER JOIN OWHS T3 ON T0.Filler = T3.WhsCode

INNER JOIN OITW T4 ON T2.ItemCode = T4.ItemCode

inner join ORDR t5 on T1.U_jobno=t5.DocEntry

--inner join RDR1 t6 on t6.DocEntry=t5.DocEntry and t6.ItemCode=t1.ItemCode

where T1.U_jobno like N'%[%0]%'

Regards

Kennedy

[vinayak_chavan · Accepted solution]

Conversion failed when converting the nvarchar value 'SO/2104-1' to data type int.

[Johan_H · Accepted solution]

What is the data type of the field U_jobno ?

[KennedyT21 · Accepted solution]

You required to provide a link else it is not possible , it is possible using the customer code.

Regards

Kennedy

[vinayak_chavan · Accepted solution]

how???

[KennedyT21 · Accepted solution]

What is the use of the U_Jobno

Have you used the same u_jobno in the sales order

In clear transfer u_jobno is equal to sales order u_jobno?

Regards

Kennedy

[former_member209066]

Hi,

Is not Posible.

need then Create the Udf in inventery transfer and Enter the Sales order Number

Thanks,

Nithi

[Former Member]

Hi,

Could you post your original query result?

Thanks,

Gordon