Skip to Content
0
Apr 10, 2023 at 06:57 PM

Approval template not working properly

78 Views

Hi Experts,

We are experiencing some strange behavior in our SAP B1 for HANA (10.0), HANA (10.00.141) FP2011 64bit, we set up approval template for the A/P Invoices below 25,000 $, between 25,000 and 250,000 $ and above 250,000 $.

We noticed that below 25,000 $ template A/P Invoice document total is between 0-3,000 $ and 10,000-25,000 $ template is triggering properly but values between 3,000-10,000 $ the same approval template not triggering. Our linked query as follows,

SELECT DISTINCT "TRUE" FROM OPCH WHERE $[OPCH."DocTotal"]<'25000' and $[OPCH."Series"]='193'

Any suggestion for the matter to be resolved?

Cheers,

Chumley