Archives
When you try restoring a SQL database, you may get an error message saying “Exclusive access can’t obtained, database is in use”. First, of course, stop all Syteline service, like IDO, Taskman. If it still doesn’t work, try the below to set it to single user mode Use Master Alter Database Database_Name SET SINGLE_USER With […]
Tax system 1, set to be area tax Tax code 17% VAT tax for normal product and goods. 3% VAT tax for small enterprise. There may be 5% normal business tax (not VAT, not deductible) Vendor Customer Customer Order Header Purchase Order Header Amount tab, cost amount has excluded tax.
There are just so many cost related fields in item table. I here try to map them out one by one with fields in Item Cost Form Purchased Current Unit Cost: cur_mat_cost cur_duty_cost cur_freight_cost cur_brokerage cur_insurance_cost cur_loc_frt_cost Manufacturing Current Unit Cost: cur_matl_cost cur_lbr_cost cur_fovhd_cost cur_vovhd_cost cur_out_cost Unit Cost matl_cost unit_mat_cost unit_duty_cost unit_freight_cost unit_brokerage_cost lbr_cost fovhd_cost […]
In order for output print out in Chinese correctly, you will need to set up the font in Language ID form for zh-CN
When creating a new Syteline financial Statement, it is much easier to work on a copy of existing statement report, instead of starting from scratchy. You can certainly use the Excel export/import to do the copying, but one part of the financial statement line, the total tab, would not get copied over that way. Syteline […]
This solution contains two options on processing returned items for rework, incorporating the returned item and costs into rework jobs for SL-ERP versions prior to SL8. With the release of SL8 , job orders can be flagged rework josb by checking a Rework flag on the job order. This will allow recursive materials to be […]
SOLUTION #1 – This is to be used if you are UPGRADING from a previous SL7.0x version, and applying a Service Pack. This is NOT to be used if you are ONLY applying a Service Pack to the same SL7 version. Before you begin the upgrade, please review your Client Configuration Names go to Start>Programs>MAPICS>Tools>Client […]
In general, the variables you create will be specific to your application’s forms and fields. However, WinStudio supports one variable that will be of general use to form developers. The variable InitialCommand can be used to determine the initial behavior of a form. The syntax is as follows: InitialCommand(arg), where arg can be one […]
Requirements If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005 Step […]
In Syteline, many key number like Customer#, Invoice# and such, they have prefix and fixed length. When key in the number, system can auto expand or auto fill the number based on its format, such as key in “C1”, it will expand to “C000001”. To get this auto expand function in a component field of […]