Skip to Content
0
Former Member
Sep 18, 2007 at 02:57 PM

Formatted search on payment form

15 Views

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!