Archives
Below are some sample ways of constructing email body in Syteline event system. BODY( SUBSTITUTE(“We have a new customer. Please see customer number {0} for customer: {1}.”, FP(“custNum”), FP(“custName”) ) ) This uses the common SUBSTITUTE function and use object property as parameter value. BODY( IF( P(“POCost”) > 10000, GC(StdApprovalMessageBody), GC(StdRejectionMessageBody) ) ) Notice the […]
To extract the Event System metadata, please do the following: On the Syteline utility server, go to <install drive>:\program files\Infor\Syteline Double-click on AppMetadataTransport.exe On the first few forms of the wizard, enter the appropriate information (e.g., select to export the metadata to an XML file, pick the appropriate configuration, browse to enter an export file […]
Below are some sample ways of constructing email body in Syteline event system. BODY( SUBSTITUTE(“We have a new customer. Please see customer number {0} for customer: {1}.”, FP(“custNum”), FP(“custName”) ) ) BODY( IF( P(“POCost”) > 10000, GC(StdApprovalMessageBody), GC(StdRejectionMessageBody) ) ) BODY( FILECONTENTS(“X:\SL\Event\Message\Body\myPreparedMessage.txt”) ) BODY( FILECONTENTS(“X:\SL\Event\Message\Body\” + IDO() + EVENTNAME() “.txt”) ) BODY( DBFUNCTION( “MsgBodyFunction”, EVENTNAME(), […]
First, determine the current site, after which you must name a configuration, by convention: DECLARE @Site SiteType SELECT @Site = site FROM parms Then determine the current SessionId: DECLARE @SessionId RowPointerType SET @SessionId = dbo.SessionIdSp() Finally, add the procedure code: BEGIN TRANSACTION UPDATE coitem SET due_date = dbo.CalcDueDate(@Parm1, @Parm2) WHERE coitem.co_num = @CoNum […]
Infor is really terrible sometime when it comes to documentation. For example, for the application event system to work, you have to make your site name exactly match with your configuration name, and this basic and critical information is not listed in installation guide and event system guide. You can only discover this when running […]