SAP B1 Query

[former_member366557]

Dear Sir/Mam

Please help me to fix this query, what is wrong with this,  i am so sory iam new with regards to queries...

SELECT (T1.OcrCode )

set T0.U_FeederVessel = T1.[OcrCode]

FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.DocNum = $[$8.0.0]

Group by T1.OcrCode

All i want for e.g. i have a value from INV1.OcrCode  for example "AAA" then i want it to set this value into UDF "FeederVessel"

thank you

regards

Silent

[SujG]

Hi Silent,

Are you trying to add a formatted search to invoice document line ?

In your query second line has syntax issue, set is not a valid command in select

If you are trying to add a formatted search on the field press ctrl+alt+tab and link your saved query.

Thanks,

Sujit