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