Formatted search on payment form

[Former Member]

Hi Experts!

I would like to make a formatted search on payment forms-both outgoing and incoming- which copies the partnername or the accountname according to the doctype into the journal remarks field.

I've created a query but it doesnt work. It runs error.

SELECT case when $[ORCT.doctype]='A' then $[RCT4.Descrip] else

$[ORCT.Cardname] end

Please, can you help whats wrong with this?

Thank you in advance!

[former_member583013 · Accepted solution]

Try this

SELECT CASE WHEN $[ORCT.DocType] = 'C' THEN $[$32.1]

WHEN $[ORCT.DocType] = 'S' THEN $[$32.1]

ELSE $[$71.2] END

Good luck