I try to implement alerts in compiere3 but i got an issue.
My goal is to have the next date of the accounting process.
I copy settings from v261 where it works fine.
Sql SELECT : name as "Client :", TO_CHAR(datenextrun,'DD/MM/YYYY HH24:MI:SS') as "Next Run :"
Table : C_AcctProcessor
Sql FROM : c_acctprocessor
In v3, it gave me this error message :
Select=(SELECT name as "Client :", TO_CHAR(datenextrun,'DD/MM/YYYY HH24:MI:SS') as "Next Run :" FROM c_acctprocessor WHERE .AD_Client_ID IN(1000001,0) AND .AD_Org_ID IN(1000001,0))
ORA-00936: missing expression
The problem is that Compiere add a "." in front fo AD_Client_ID and AD_Org_ID
Have you got an idea from where it could come ?
Select the table in the drop down or indicate that it is not a compiere table. fixed in current version
I have selected the table in the drop down list but i got the same error.
I try to copy an existing alert (Open Items over 100 days) and still have the "." in front of AD_Client_ID and AD_Org_ID.
What do you mean by "current version" ? 3.1 ?
I carry on his thread to ask if anybody know how to use "Action SQL Set Processing" and "Action SQL Row Processing" fields ?
What is their purpose ?