Skip to Content
0
Nov 25 at 02:08 PM

sap B1 FMS error

127 Views Last edit Nov 25 at 09:59 PM 2 rev

Dear Team,

We have Bp code next number series automatically through FMS query.

Its working fine for long time but Suddenly my fms is not working. How to solve this issue.

SELECT CASE $[OCRD.CARDTYPE]
WHEN 'C' THEN 'C'
WHEN 'S' THEN 'S'
WHEN 'L' THEN 'L'
END
+
(SELECT RIGHT('0000000' + LTRIM(RTRIM(CAST((SELECT MAX(Right(CardCode,6)) + 1
FROM [OCRD] WHERE CARDTYPE = $[OCRD.CARDTYPE]) AS CHAR))), 6))

Thanks

Vinoth