Archives
Below are some of points that are worth taking, while implementing APS in Syteline. 1. Implementing APS is an all or nothing process. Partial effort will result in failure. 2. APS requires you to rethink your business process related to promising to customers; ordering materials and releasing work into production. Sometimes it is difficult to […]
Table trigger is important part of Syteline data integrity. There are many validation logics safe guarded by trigger program. But in some circumstances, you may want to turn the trigger program off, in order load certain data. This is specially true during data conversion of your Syteline implementation, you may need to use program to […]
There is simple three steps process for adding/changing replication rules in Syteline. 1) Add/Edit rules in Replication Rules form Notes: you setup all rules for source site in source site DB. 2) Regen trigger Open “Replication Management” form, Regen the replication trigger. This will make the trigger program in place to replicate transactions from now […]
About Shared Tables and Master Sites In a multi-site environment where there are many sites, large amounts of data, and many users, you may want to set up one site as the master site for an intranet. In that case, certain _all tables and user tables can reside only on the master site database and […]
Starting from Syteline 8.03, the Pick, Pack, Ship function utilize BarTender for bar code label printing. Create label templates in Bartender. The label template in Bartender need to use text file as database source. Create a sample text file with data like following, TC280847|123456789012345|DGM17ALS|03/03/2014 When we done, we should have data source like this, […]
If the actual work on an operation is performed at a location other than your shop floor, you must perform special steps to capture the status of the operation for accurate planning, scheduling, and costing. If you do not represent and manage an outside operation properly, the effects can ripple down through subsequent processes, resulting […]
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(), […]
Project Resource Transaction Two ways to post: 1) Project Resource Transaction Form; 2) Xref to PO and during PO receiving transactions Debit Credit Note Material or Other Material Inventory or Expense Defined by material prod code or On transaction screen Project Material Account Defined by Project Product Code Project OH Project Applied OH […]
The Select … for XML can be useful. Let say that you want to list out Job Order information, one job per line, and one of the field will be WC, and you want to show all WCs for the job, in the format like WC1, WC2, WC3, … Here is the select statement will […]