Skip to Content
0
May 24 at 02:05 PM

Automatic Document Series - Purchase Order

53 Views Last edit May 24 at 02:15 PM 2 rev

Hi All

I've another inquiries. I attempt to create FMS Query so it select Document Series on Purchase Order.seriesdocument.jpg

So whenever I select 1a Vendor field and the CardCode belongs to certain group, it will automatically change the series on 3a

I come to a deadlock where I'm not able to run my query. Can you help me telling me what is wrong with my Query? Here are the query I wrote

SELECT (CASE T1.GroupCode WHEN 101 THEN T0.Series = 577 WHEN T1.GroupCode = 143 THEN T0.Series = 576 END)

FROM OPOR T0

INNER JOIN OCRD T1 ON T1.CardCode = T0.CardCode

WHERE T0.CardCode = $[OPOR.CardCode]

Thanks in Advance

Attachments

seriesdocument.jpg (24.5 kB)