Archives
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 […]
For Businesses operating in Canada: The Syteline system presumes that the main tax system (GST) will be setup as Tax System 1 with a Tax Mode of either Item or Area depending on the requirement of the province. The Syteline system also presumes that PST and HST will be setup as Tax System 2 with […]
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
When you try restoring a SQL database, you may get an error message saying “Exclusive access can’t obtained, database is in use”. First, of course, stop all Syteline service, like IDO, Taskman. If it still doesn’t work, try the below to set it to single user mode Use Master Alter Database Database_Name SET SINGLE_USER With […]