sap B1 FMS error

[former_member229757]

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

[hdolenec]

Is this for determinating BP code when entering new BP master data? Why not just use standard numbering series to get code +1?

[LoHa]

Hi Vinoth,

the question is ... what happens is there a value in field?

Have you perhaps reached a number > 999999 (length in your query is 6)

regards Lothar

[former_member229757]

Hi

my bp code length is 6 fields till yesterday working fine. Today its not working. Its showing old Bp not moving to next bp code

Thanks

Vinoth