Archives
If you are using the Syteline job order system for tracking and reporting production and are thinking of changing to use production schedules, here are some things to consider: 1) An item must be standard costed before you can enter it on a production schedule. If you are currently using actual costing, this would be […]
Here is a useful query to check user section that cause blocking / locking. SELECT d1.session_id, d3.[text], d1.login_time, d1.login_name, d2.wait_time, d2.blocking_session_id, d2.cpu_time, d1.memory_usage, d2.total_elapsed_time, d2.reads,d2.writes, d2.logical_reads, d2.sql_handle FROM sys.dm_exec_sessions d1 JOIN sys.dm_exec_requests d2 ON d1.session_id=d2.session_id CROSS APPLY sys.dm_exec_sql_text(d2.sql_handle) d3
Read the cover letter, highlights forms that have been modified, and Sps that have EXTGEN on. For EXTGEN SPs, will need to manually apply the new changes. For modified Forms, make a backup of the Form scripts use FormSync. Apply the patch to unused configuration, such as Demo. Merge the new vendor version of […]
1) The “Job BOM Cost Roll Up” utility and the “Update Planned Cost” button in Job form, Cost Detail tab are pretty much doing the same thing, they will update the material cost in job material. 2) Syteline system didn’t maintain a field for total job planned cost, you […]
1) Setup Tax Parameter, enter your own company’s Tax ID. 2) In your Tax System setup, make sure the Tax ID Prompt Location set to included Vendor (Vendor or Both). 3) In Accounts Payable Parameters, under 1099 tab, enter your company information. These are info will be print on your 1099 form. 4) Now, for […]
In Syteline 9, there is one significant database schema change. All major tables like item are replaced with a view and _mst table. There are some context variables need to be set, before you can run query against to the views. Otherwise query to the view will return no data. And here is the variable […]
Part of the Syteline year end procedure is to run an utility to reset the YTD number in item warehouse form. This needs to be done in timely manner. If you forget to run it during your year-end, there is no rebalance utility to recalculate that these YTD number in Syteline. The below small script […]
This is a great blog post regarding how to setup SQL Mail. Need to keep for reference. SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
They are not stated in Syteline manual, but from my experience, I would suggest the following routine after upgrade a Syteline DB. 1) Regenerate _all table, by using “Update _All Tables” form. 2) Regenerate trigger, by using “Trigger management” form. 3) Regenerate Replication Triggers, if you are using multi-site replication. 4) Drop all the _tt […]