Archives
In Syteline form grid, if you have line# and you want it to be auto populated, you may use the AUTONUMBER function, just set the component default value property to AUTONUMBER. Syntax AUTONUMBER( [ STEP( ) ] [ FILTER( ) ] ) Remarks During processing of the New standard operation, AUTONUMBER sets the value of […]
Sometime, in an In Collection Validator, you would get a “Cache Property not in Cache” error. Make sure to check the “No List Cache” check box. This will force to refresh IDO collection in Cache.
In Syteline, many key number like Customer#, Invoice# and such, they have prefix and fixed length. When key in the number, system can auto expand or auto fill the number based on its format, such as key in “C1”, it will expand to “C000001”. To get this auto expand function in a component field of […]
The Exchange server is primarily responsible for the broadcast of e-mails generated within SyteLine . An Exchange server is a Microsoft messaging system including mail server, email client and groupware applications. If e-mails are not being generated from SyteLine, for example when a purchase order is printed, then there are certain procedures to follow to […]
I found this article is pretty useful on understanding various Syteline service too. There are two types of logins used for Syteline 8.00, 8.01 and 8.02. This article discussed the areas that use Windows Accounts and SQL ‘sa’ accounts would need to be updated. Windows Login – This Login should be part of the Windows […]
There is no simple way for reports to be cancelled from the client in Syteline 7 and 8. The Cancel button for Print Previews only kills the client part of a Preview. The background task continues to run on the TaskMan machine (The TaskMan machine is typically the Utility Server where the TaskMan process is […]
The purpose of the Lead Time Processor (LTP) utility is to calculate an item’s fixed and variable lead times using the operations that make up its current routing. The fixed lead time is expressed in days. The variable in hours and is the run time for 1 piece. Basic Algorithm If you answer "No" to […]
For Report Previews to work, the SL 8 Click Once Client needs to authenticate to the Utility Server Syteline directory where the reports are actually generated. Click Once Client users only require internet access to the Website to download the Click Once Client. They do not need network permissions to access the directory on the […]
Changing the Report Logo for Syteline is fairly easy. Just place a new SLHeaderLogo.bmp (your company logo) in the C:\Program Files\Infor\SyteLine\Report\Reports folder in the utility server. If you have multiple Syteline configurations for differ branch companies, and want to use differ logos, you can create folder under the above Reports directory. Make the folder name […]
Use the following script to shrink/truncate SQL database log file USE [Database_Name] GO ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(DB_Log_File_Logical_Name, 1) ALTER DATABASE [Database_Name] SET RECOVERY FULL WITH NO_WAIT GO Use the following script to check the file size. USE [Database_Name] GO select name, size from sys.database_files