SytelineMaster

  Google Insights for Search – Web Search Interest: syteline – Worldwide, 2004 – present Looks like Syteline is fading slowly in the past 5 years.  The pick up in early this year may be related to the ad campaign Infor recently run.  Hope they really do something, no just sit there simply claim themselves […]

This is considered by some people as Holy Grail of Syteline Form Personalization. Here is what we want to do.  In “Time Phased Inventory” form, we want to change the color to yellow for those rows that is PO. First, we need to create a new form script method, called SetPOColor() Sub SetPOColor() Dim i […]

Use CDate to convert a string to a date/time. Dim d1 As Date Dim d2 As Date Dim d3 As Date d1 = CDate(“August 12, 2004”) d2 = CDate(“2:07:30 PM”) d3 = CDate(“August 12, 2004 2:07:30 PM”) Print d1 ‘ prints 8/12/2004 Print d2 ‘ prints 2:07:30 PM Print d3 ‘ prints 8/12/2004 2:07:30 PM

It is very often that you need to get current date/time in your development. T-SQL To get today date without time as string variable use following script: Select CONVERT( CHAR(8), GetDate(), 112) To get datetime variable of today date without time use following script: Select CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME) VB System.DateTime.Now.ToString(“yyyyMMddhhmmss”) Now() […]

Problem:

Many business would not allow product shipped to a “PO Box” address. So would like to block any “PO Box” address being entered into any ship to address.

Solution:

1) Enter design mode of “Customer Ship Tos” Form.

2) We are going to first create a script. Go to “Menu -> Edit -> Script”, a Script window should open. Click “New”, enter Script Name called “NoPOBox”, then click OK.

Syteline system cut over will be the biggest milestone of your implementation project.  Careful planning would be essential to your project success. Section A – Initial Setup Step Form Purpose Owner(s) Due Date Scope (Task Size – Small (<1Day) Medium (<1wk) Large >1wk) A1 Groups Specify groups who are allowed access to the SyteLine ERP […]

The “Query” function in Syteline allows you to use multiple selection criteria to query transaction.  The example below show you how to query manual transactions for inventory account in a given date range. Open the “GL posted transaction query” form. Click “Additional Criteria” tab. In the first pull down list, select “Account”.  In second pull […]

The Definition of Procedures Procedures represent the documentation of business process.  Their purpose is to document all business processes, strategies, and principles and their related information.  In terms of ISO 9000, procedures represent the Level B/Tier 2 of the Quality System.  Procedures should be written in a detailed manner.  They should cover the ‘5 – […]

CRP – INVENTORY CONTROL Set up parameter files Determine item structure for Item Master.  Determine what will be inventory items and non-inventory items. Determine structure for Product Codes/Distribution Accounts. Set up master files Item Master Purchasing information Manufacturing information Costing information Engineering information Sales information Product Codes/Distribution Accounts Warehouse Master Stock Locations Nettable/non-nettable Temporary/permanent Reason […]