Skip to Content
0
Former Member
Apr 12, 2012 at 09:05 AM

Formatted search - Default WH

109 Views

Hello,

I would like to create a formatted search on A/R invoice. I would like to insert a specific warehouse code into INV1.WhsCode field in document lines, when a specific sales employee is selected on the document window. When any other sales employee is selected, then I would liketo use the default warehouse for the Item in the document line (OITM.DfltWH)

I have started and tried with versions of this query, but didn't succeeded yet:

SELECT CASE WHEN ($[OINV.SlpCode]=1) THEN 'A1' ELSE OITM.DfltWH FROM OITM END

Could you help me please, it must be some basic syntax problem 😊

Thank you,

All the best,

Balazs