Archives
If you ever need to change the site name in Syteline, here are steps you should follow, 1) Backup all your database. 2) Log off all users. 3) Run the “Change Site” utility. 4) If Intranet Licensing has been implemented in this site, after running the Change Site Utility, the Intranet License option on the […]
Below is a pretty useful Form Script Function that can be used to send out email. You can trigger this by any event. PublicSub SendEmail() Dim EmailBody AsString Dim toAddress AsNew Net.Mail.MailAddress(ThisForm.PrimaryIDOCollection .GetCurrentObjectProperty("your_email_field")) Dim FromAddress AsNew Net.Mail.MailAddress("me@company.com", "Display Name") EmailBody = "Some text:" & ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty("some_property") & vbNewLine _ & "Some more stuff: " & vbNewLine […]
When a Syteline form open in “filter in place” mode, you may want some of the fields already have frequently use value there. For example, you may want the warehouse field has default filter value of “Main”. To do that, it is pretty simple. In the form you want to set this up, add a […]
How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box. Example: If Fat, Use range from C6:C7 If Skinny, Use range from D6:D7 You can direct put the IF statement in 2nd drop down validation, like =IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)
Excel provides conditional formatting which allows you to change the color and other attributes of a cell based on the content of the cell. There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row. You can, however, achieve the same effect by using a macro […]
Open the component class “UserDefinedType”, go to validator, add one more parameter %2 to the UserDefinedTypeValue validator. Open the validator, make sure %2 is there. Then open the property of the validator. Open the Parameters screen Set %=Description in Set Prop/Var/Comp section. OK all the way back to save the change in Component Class. Now […]
If you have hundreds users, manually rebuilding the User/Module Authorization will be painful. The below query will copy over the User/Module Authorization from source DB to target DB. Just run it against your target DB. insert modulemembers (objecttype, objectname, modulename, originalmodulename, modulememberspec) select objecttype, objectname, modulename, originalmodulename, modulememberspec from [Your_Source_DB_name].[dbo].[modulemembers] where objectname like ‘OS_%’
If you even need to find out all store procedures that contain certain phrase, such as “PurchaseOrders”, the following query will help. select so.name, sc.text from syscomments sc inner join sysobjects so on sc.id = so.id where so.xtype = ‘P’ and sc.text like ‘%PurchaseOrders%’ This can be extended to other object type, for example ‘TR’ […]
If you are a Syteline administrator, you will often need to refresh your Test/Training database with update-to-date Production database. The most common way for copying DBs in SQL server is to use the backup/restore function. 1) Bring down all Infor service. 2) Backup your Syteline production database. In SQL management studio, right click database name, […]
Overview There are four lead time fields in the Syteline item master: fixed, variable, paperwork and dock-to-stock. The fixed, paperwork and dock-to-stock leads are expressed in days and the variable is expressed in hours (run time per piece). For purchased items, they must be manually entered. For manufactured, they can be either manually entered or […]