Archives
Every combobox in Syteline form has a pull-down list. For example the item pull-down list may show item# and description. You may want to add more fields to this pull-down list to show more information for your user. Business Case: The current Syteline customer ship-to pull-down list only show the ship-to seq and the customer […]
In Syteline form, quite often, you would need to assign some field value, base on another field value entered. Business case: Let say in Customer Order, for certain payment terms, you would not allow partial shipment. So in the CO header form, when user select certain payment term, you want the system automatically uncheck the […]
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 […]
When deploying an UET customization in Syteline 7 & 8, there is SP can be used to script out the UET. Just do exec ExportUETClassSP ‘classname’ Some server don’t this SP installed. I just keep a copy here for in case set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[ExportUETClassSP] ( @PClassName Infobar ) […]
For Syteline programmer, when doing the form personalization, it is important to understand the various event sequence for Syteline Forms, so you can know where to put your customized logic in. The following list outlines the sequences of events during form execution for non-query forms. 1. Form initialization StdFormPredisplay is always the first event to […]
When doing the VBScript programming, it often need to have a VBScript constant containing a line-break character. Of course this is right out: CONST blah = "hello there" …It’s just bad syntax. The closing string quote has to be on the same line as the opening one. The normally you would try this: CONST blah […]
Each component in Syteline form can have its own right click menu, and this right click menu is customizable. See the sample, the “Ship To” field has a standard right click menu, with “Add”, “Detail”, “Find” and “Help” menu items. If you look into the component property of “Ship To” field, you can see the […]
One of the trickier aspects of application development is dealing with null or nonexistent data. It gets complicated when the application expects a data value and gets nothing or unexpected values; that’s when you must perform coding that properly handles these situations to avoid application failure. This requires a close examination of the data wherever […]
Syteline Delivery Orders are always handled by Consolidate Invoice. 1) Shipment can be tied to a DO during the shipping process. 2) Shipment can also be put into a DO after the shipping process. Just open that DO and add the shipment record to that DO. 3) DO invoicing will be always under the consolidate […]
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