Archives
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 […]
Infor is really terrible sometime when it comes to documentation. For example, for the application event system to work, you have to make your site name exactly match with your configuration name, and this basic and critical information is not listed in installation guide and event system guide. You can only discover this when running […]
I have found the Syteline Financial Excel Addon a handy tool for building financial statement, much better than the financial statement writer inside Syteline. Many long time Syteline user still have hard time understand the old financial statement writer, ever after using it for years. But the Excel add on is really straight forward, especially […]
PO Receive (INV PRCV) Item ABC current on-hand qty = 100, cost = $1.4 PO purchase price $1.17, with 17% VAT tax, material cost = $1. Receive qty = 100 After received, qty = 200, average cost = $1.2 Debit Credit Comment Inventory 120 100 pcs on after received unit cost of […]
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())
Today, many, if not most, US manufacturers have operation in China. They either build out manufacturing facilities to take advantage of global supply chain, or setup sales/marketing operation to catch China market potential, and may be both. With US headquarter and operation running in Syteline, it is nature to put Syteline into China branch as […]
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 […]