Archives
Open the component class “UserDefinedType”, go to validator, add one more parameter %2 to the UserDefinedTypeValue validator. Open the validator, make sure %2 is there. Then open the property of the validator. Open the Parameters screen Set %=Description in Set Prop/Var/Comp section. OK all the way back to save the change in Component Class. Now […]
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, […]
Overview There are four lead time fields in the Syteline item master: fixed, variable, paperwork and dock-to-stock. The fixed, paperwork and dock-to-stock leads are expressed in days and the variable is expressed in hours (run time per piece). For purchased items, they must be manually entered. For manufactured, they can be either manually entered or […]
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
General Concept: Customer amounts will be stored in the customer’s currency. This effects CO, Estimating, and AR. Vendor amounts will be stored in the vendor’s currency. This effects PO and AP. Cash accounts in Bank Reconciliation may be stated in non-domestic currencies. When receiving customer payments or making vendor payments we may specify the payment […]
Basically, this is handled through a 3-Step Process. Cut the check to the vendor, designating it as an Open payment. Receive and voucher the purchase order. Reapply the open payment against the voucher generated. Below are the steps for handling this process. The process for handling Deposits or Pre-Payments to Vendors is as follows: 1. […]
A refund check has been received from a vendor and you need to enter it into SyteLine, the following are the steps that you should take to complete this process: 1) Go to Customer Maintenance and add a new customer record with the Vendor’s information. 2) In AP, you currently have a voucher and a […]
Recurring Vouchers are designed to handle repetitive vouchers each month, where basically, only the Invoice Date, Distribution Date and Due Date change each month. The steps to set up a Recurring Voucher are as follows: Open Recurring Vouchers form (in SL4, SL5 and SL6 go to Vendor – Recurring Vouchers) New (or add) Enter the […]