Archives
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 […]
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.
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”.
Landed costs may be added to purchase order lines in order to receive estimated costs for freight, duty, and brokerage into the inventory value of an item. Each of the separate landed cost components may be paid to the purchase order vendor or to a different vendor. Landed cost capitalization is available for both actual […]
Why MRP Failed with Low Level error? At the end of the MRP Generation, you receive the following error: [WARNING – Low level codes are improperly set. MRP Generation is not complete – re-run Net Change. MRP PROCESSOR] was not successful. If you receive this error at the end of running the MRP Generation, it […]