Skip to Content
0
Jul 31, 2023 at 11:34 AM

Edit Query

40 Views

Hello Everyone,

I have below query in SAP B1. This Query is applicable when OPOR.U_DEPT = 1, Now I want to edit this query and applies it, when OPOR.U_DEPT = 1 or 3 or 5 or 6, then this should run.

Can Anyone please edit it.

IF CAST($[OPOR.DocTotal] AS DECIMAL(38, 4))< CAST('20000' AS DECIMAL(38, 4)) and $[OPOR.U_DEPT]='1'

SELECT 'TRUE'