Incorrect syntax near oinv.docentry

[former_member645084]

Hi

On below query i am getting above error

SELECT Top 1 T0.LocCode FROM INV1 T0 WHERE T0.DocEntry = $[OINV.DocEntry]

Thanks

[ens_]

jsshivalik,

What is your setup? Where are you running this FS and whats the scenario? The syntax is correct. The problem lies elsewhere.

Sincerely,

Varnavas Eleftheriou

[msundararaja_perumal]

Hello,

Of course, if you run the query as its in the query manager, it will throw terror.

This query syntax is intended for only Formatted Search, please assign this query to the field, then the formatted search, it should work fine.

Please do some reading on the formatting search.

Thanks.

[Abdul]

Dear

you cannot get docentry at run time because docentry generates after posting the document instead of docentry use doc number or any other field which has value on run time.