Dear Friends,
I am experiencing some strange behavior with approval system in SAP B1, my scenario as like below
(1) I have been set up approval template by linking a query into it
SELECT DISTINCT 'TRUE' FROM OPCH T0 WHERE $[OPCH."Series"]='157' AND $[OPCH."DocType"]='S' AND $[OPCH."DocTotal"] < '25000'
(2) I raised a new A/P invoice within the limit of 25,000 and when hit Add button approval has triggered. I cancelled trigger and change the line amount to different than what initially has entered and again tried to send it for approval but the document immediately got posted without approval trigger
After this approval won't be triggering in the system. However when I removed later part in the query, $[OPCH."DocTotal"] < '25000', the approval trigger is working as normal despite how many times I have changed the line level amount.
Dose anyone experience the same? Apricate anyone advise or help to sort this out.
Cheers,
Chumley