Archives
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 […]
This is coming out of PCWorld. Looks pretty positive to our Syteline fellow. Infor Prepares to Roll out ‘Mongoose’ Development Platform
When specifying unit codes in the Excel formulas, to use both a cell reference in addition to hard-coded values, you need to append the two with ‘&’. For example, if unit code 1 value is in cell $A$1, and you don’t want to include * for each of the three remaining unit codes, the Unit […]
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) There is also a few useful UDF(User Defined Function) in Syteline ConvDate (@pInputDate DateType, @pFormat NVARCHAR(10)) Sample SELECT ConvDate(GetDate(), ‘MM/DD/YYYY’) Another useful one, DayEndOf ALTER FUNCTION [dbo].[DayEndOf] ( @Date DATETIME ) RETURNS DATETIME AS BEGIN – This function takes the input date and extends the time portion […]
First, determine the current site, after which you must name a configuration, by convention: DECLARE @Site SiteType SELECT @Site = site FROM parms Then determine the current SessionId: DECLARE @SessionId RowPointerType SET @SessionId = dbo.SessionIdSp() Finally, add the procedure code: BEGIN TRANSACTION UPDATE coitem SET due_date = dbo.CalcDueDate(@Parm1, @Parm2) WHERE coitem.co_num = @CoNum […]
Something to remember, in programming in multiple site environment, if you have site that has differ time zone than the server time zone, remember to use GetSiteDate function, instead of directly GETDATE(). Below is code sample. SET @PrintDate = dbo.GetSiteDate(GETDATE())
1) Update Statistics You should always run the below command nightly Exec sp_updatestats 2) Rebuild Index for key tables It is worth to rebuild index for key tables regularly, like once a week. DBCC DBREINDEX (ledger) GO DBCC DBREINDEX (item) GO DBCC DBREINDEX (customer) GO DBCC DBREINDEX (matltran) GO DBCC DBREINDEX (journal) GO DBCC […]
During Syteline installation, you provided a domain account (normally it would call something like SLService, and belongs to domain admin group), to install all the Syteline service. If later on, you somehow change the password for this account, you would have problem access to Syteline. Error message likes below would popup. It may also […]
In syteline 7 it was SessionManager.BaseUserName. In Syteline 8 Create form component ‘UserEdit’ and bind it to variable ‘User’ with initial value ‘USERNAME()’ Get the value on form script by ‘ThisForm.Variables(“User”).Value’ This will return the UserID who login to Syteline. Use System.Environment.UserName to get the UserID login to Windows. Here is a sample screen shot
Let say you want to show item material status in Item Availability Form, you may just create a new edit field in form, then bind the form component to COLLECTION(SL.SLItems(PROPERTY(Stat) FILTER(Item = FP(Item)))) . Please note that if you want to do this in grid column, since the value is not in collection, so the […]