Archives
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, […]
Here is the way to check a form’s mode in script. If Instr(1, ucase(ThisForm.Caption), “(FILTER IN PLACE)”) > 0 Then ReturnValue = “-1” Exit Sub End If
This is about Progress version of Syteline, on how multi-currency works in Financial Statements. FINANCIAL STATEMENTS The exchange rate table (could be local or global) normally used by the database from which the Financial Statement is being printed will be used for the translations. Therefore, unless Current Rate translation is to be used on all […]
I have been trapped on this more than one time. In order for a method call validator to work, the return value has to be bigger than 5. This is clearly state in the WinStudio document: “If the method returns a value less than 5, WinStudio passes the validation. Otherwise, WinStudio fails the validation. The […]
From out of box Syteline, the pull down list of customer# field is sorted by customer#. The same thing happens to the vendor# field. Many Syteline users would prefer that the pull down list is sorted by customer name / vendor name in alphanumeric order, especially when you have hundreds customers/vendors. Syteline Application Case Change […]
The out of box Syteline missed some of the detail carelessly. For example, the Grid view for RMA is sorted by RMA date ascending. So it shows the oldest RMA up front and you are seeing those years old closed RMAs. Syteline Application Case Change the sorting of Grid view in RMA form, to show […]
In Syteline, there are many ways to default field value. The most simple way is to use the default value property of the field component. But if you need to set the default value based on some other field value, that simple property value would not cut it. Syteline Application Case We want to default […]
We will use a sample to run through the process of adding a CLM into IDO. Part of making the Customer Document Profile function available to RMA verification report, we need to create a new CLM to IDO SLRmas. The CLM is based on SP navProfileRMAVerificationSp. create PROCEDURE [dbo].[navProfileRMAVerificationSp] ( @RMAStatusOpen ListYesNoType = NULL, […]