Archives
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 […]
In Syteline, when you pay for a purchase from a vendor with a credit card, you want to be able to show the purchase under the Purchase Vendor, but the payment will need to be remitted to the Credit Card Vendor. How to handle this in Syteline? A possible solution is to create a Bank […]
This is about Progress version of Syteline, on how multi-currency works in Financial Statements. FINANCIAL STATEMENTS The exchange rate table (could be local or global) normally used by the database from which the Financial Statement is being printed will be used for the translations. Therefore, unless Current Rate translation is to be used on all […]
I have been trapped on this more than one time. In order for a method call validator to work, the return value has to be bigger than 5. This is clearly state in the WinStudio document: “If the method returns a value less than 5, WinStudio passes the validation. Otherwise, WinStudio fails the validation. The […]
I think this is one of the FAQ question for T-SQL programmer, and here is some quick sample Last Day of Previous Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) Last Day of Current Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) Last Day of Next Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0)) Show name of the month: select datename (mm, date_field) Or if you want […]
From out of box Syteline, the pull down list of customer# field is sorted by customer#. The same thing happens to the vendor# field. Many Syteline users would prefer that the pull down list is sorted by customer name / vendor name in alphanumeric order, especially when you have hundreds customers/vendors. Syteline Application Case Change […]