Archives
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 […]
Payroll Generation: pr/pr-trxg.p, main logic in pr/pr-trxg1.p Payroll record prlog can be generated from 4 differ sources: Manufacturing transaction jobtran. The Generate Payroll From field on the Employee Master must also be set to M. The summarized transactions include: WC Labor, WC Machine Time and Job Labor. prlog.posted-from = “M”. Manufacturing Project transaction projtran. The […]
The table contains MPS is rcpts with the ref-type = “M”. rcpts also contain other records that generated by MRP. To remove any MPS demand, remove rcpts records with ref-type = “M”.