GRPO Error Could not commit transaction: Error -1 detected during transaction

[vijaychavda9]

Dear Experts,

We are using below said FMS Query in Total LC Field, when we purchase Item in KG it will multiply with Weight * Unit Price and when purchase in No. multiply Qty.*Unitprice in SAP 9.2 Version.

But now we updated to 9.3 PL08 Hotfix and while going to complete GRPO Entry for Qty*Unitprice items, ADD Buttion being disable.

Kindly give your input in below said FMS query which we are using.

select case when $[POR1.U_PriceTerms] = 'W' THEN CONVERT(FLOAT, REPLACE(SUBSTRING($[$38.14.81],5,LEN($[$38.14.81])),',', ''))* CONVERT(FLOAT, REPLACE(SUBSTRING($[$38.58.55],1,LEN($[$38.58.55])-2),',', '')) when $[POR1.U_PriceTerms] = 'Q' THEN CONVERT(FLOAT, REPLACE(SUBSTRING($[$38.14.81],5,LEN($[$38.14.81])),',', ''))* CONVERT(FLOAT,($[$38.11.11])) END

Thanks in advance for your generous support.

Regards,

Vijay N. Chavda

[vijaychavda9 · Accepted solution]

Ok thanks for your response.

[Abdul]

Instead of Case try if and then statement