https://support.cyriouswiki.com/ 2026-08-10T06:00:07+00:00 https://support.cyriouswiki.com/ https://support.cyriouswiki.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2019-01-27T11:28:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/5.1_manual_installation?rev=1548606493&do=diff Explanation The following is the preferred method of installing version 5.1 manually. Before you begin, make sure of 3 things: * ONLY perform a manual installation if an update or installation via an installer package will not work. * DO NOT install CHAPI at all until you know what modules the customer should have. Check their security dongle or keyfile, and check the authorizations tab of their company record in Cyrious Internal. If the information does not match, check their order record… text/html 2019-01-27T11:28:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/5.1_troubleshooting?rev=1548606494&do=diff Explanation These are notes on all issues we've run into so far that are not bug-related in the 5.1 testing. For the most part, these are configuration and education issues. All techs should add to this page as new issues arise. CHAPI SECTION Restarting the SSLIP with CHAPI text/html 2019-01-27T11:28:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/5.1_upgrade?rev=1548606495&do=diff Explanation This article covers the steps a Cyrious Tech would take to upgrade to Control 5.1 or 5.5 from 4.6. * - Download 5.1 updater from cyrioussoftware.com (Save the file. Don't run it.) * - Determine what version to download (SQL ver, 32bit, 64bit, etc.) text/html 2019-01-27T11:28:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/405_method_not_supported?rev=1548606493&do=diff Error Message Error 405, method not supported Explanation of Error IIS cannot execute certain methods that Production Terminal uses. Severity Normal. User is not down. Possible Root Cause(s) Asp.Net 4 is not installed on the machine hosting Production Terminal. text/html 2019-01-27T11:28:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/access_denied_when_attempting_to_log_into_sql_management_studio?rev=1548606495&do=diff Issue You are attempting to log into SQL Management Studio however you can't log in with SQL authentication or Windows authentication. Cause This generally occurs when SQL was installed by another person in the past and that user account was associated as an administrator for SQL however the current user account that you are connected on is not authorized for SQL. If you know the user/pass for a SQL user account such as the sa user then you can use that information, however by default mixed-m… text/html 2019-01-27T11:28:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/access_violation_in_module_crxf_pdf.dll_when_exporting_to_pdf?rev=1548606495&do=diff Error Message Access Violation .... in module crxf_pdf.dll Explanation of Error The error occurs when attempting to save or export to PDF either directly to the drive or create the PDF during the process of emailing. Severity Normal Possible Root Cause(s) text/html 2019-01-27T11:28:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/access_violation_when_printing_._._._usp10.dll?rev=1548606496&do=diff Error Message “Access Violation in . . . “USP10.dll” Whenever printing directly from Control. Explanation of Error This is due to an incompatible version of usp10.dll being loaded by Crystal Reports when attempting to print. Often this is a result of an older version being put on the system by Office 2010 and/or related components. text/html 2019-01-27T11:28:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/access_violations_when_saving_orders-estimates?rev=1548606496&do=diff Explanation * Customer creates order/estimate. * Enters pricing information with no issues. * Uses the explorer to pull in a company name. * Hits save and receives an access violation. Possible Cause This can occur when a customer list is imported into Control where required data fields are missing. For example, Default Tax Class, Contact Last Name, Primary Phone Number, and Payment Terms are all required fields when creating a new company. The system will not permit you to sa… text/html 2019-01-27T11:28:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/accounting_import_formats?rev=1548606496&do=diff Confirmed file formats for creating import files for various accounting packages. Confirmed: Quickbooks = Quicksave as .iif formatted document. Simply Accounting/Sage 50 = Quicksave as PLAIN TEXT document. Peachtree = Quicksave as .CSV (Confirmed by PDG on 6.6.2016) text/html 2019-01-27T11:28:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/activity_groupids_with_multiple_orders?rev=1548606497&do=diff Issue Viewing an activity on the Actvities Tab of an order shows GL entries that should not be associated with the order. There are multiple activities / GL entries with the same GroupID but different orders. Explanation of Issue When using Production Terminal, the GroupID field in the Ledger Table and the StartGLGroupID and EndGLGroupID fields in the Journal table are duplicated between the activities Control creates and the activities Production Terminal creates. text/html 2019-01-27T11:28:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/allowing_ping_through_firewall_in_windows_7?rev=1548606497&do=diff Explanation Windows 7 firewall will by default block a ping request Resolution * Go to Control Panel * Select Windows Firewall * Click the Advance settings * Select Inbound Rules * Select New Rule * Choose Custom Rule * In Protocol and Ports, choose Protocol: ICMPv4 text/html 2019-01-27T11:28:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/an_error_5006_0x80070002_has_occurred_while_running_the_setup?rev=1548606497&do=diff Explanation This error occurs after you start a Cyrious installation. The progress bar will appear followed by this error message: Error Code:-5006 : 0x80070002 Error Information: >SetupDLL\SetupDLL.cpp (1281) PAPP:Cyrious SMS PVENDOR:Cyrious Software (www.cyrioussoftware.com) PGUID:1C51B778-AB70-4C9E-A705-B1E0C2382E78 $7.1.100.1248PAK @Windows (9200) E 11.0.10240.16412 text/html 2019-01-27T11:28:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/an_error_has_occurred_while_executing_queries._timeout_expired?rev=1548606497&do=diff Error Message Explanation of Error This error can occur at almost any time, but occurs most commonly when attempting to create/edit/delete orders, estimates, or customers, or other times of heavy datase activity. The general cause of any text/html 2019-01-27T11:28:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/application-specific_password_required?rev=1548606498&do=diff Explanation Gmail has the ability to implement a two-step verification to increase security. Control is not currently compatible with this extra security feature at this time. However, Gmail has Application Specific passwords that can be set up in the Gmail Settings. text/html 2019-01-27T11:28:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/ar_aging_report_not_showing_contact_or_company_names?rev=1548606498&do=diff Explanation This is caused by Corruption in the DB. Always do Resolution 1 and test before trying Resolution 2 Resolution 1 * Run the dbrebuild Resolution 2 * Navigate to Mgmt>Set-Up>Reporting Set-Up * Navigate to the offending report and click the edit button text/html 2019-01-27T11:28:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backing_up_sms_v8.6_data?rev=1548606499&do=diff Explanation This is the best way to ensure you safely backup the Cyrious SMS V8.6 Data, if you have set-up Cyrious to do the backup. If not, see sms_backup_database_set-up_v8.6_and_higher Steps * Click on Reports * Click on Closeouts * Click on Backup Database text/html 2019-01-27T11:28:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backing_up_sms_v8_data?rev=1548606499&do=diff Explanation This is the best way to ensure you safely backup the Cyrious SMS V8 Data. Steps * Right click on the Cyrious icon on the main Cyrious computer. * Left Click on Properties. * Left Click on Find Target. * Right Click on the Data folder in the newly opened folder. text/html 2019-01-27T11:28:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backing_up_sms_v2000_data?rev=1548606498&do=diff Explanation This is the best way to ensure you safely backup the Cyrious SMS V2000 Data. Steps * Left Click on the Cyrious icon. * Right Click on Properties. * Right Click on Find Target. * Left Click on the Data3 folder. * Right Click on Copy. text/html 2019-01-27T11:28:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backing_up_sms_v2000_data3?rev=1548606499&do=diff Explanation This is the best way to ensure you safely backup the Cyrious SMS V2000 Data3. Steps * Right click on the Cyrious icon on the main Cyrious computer. * Left Click on Properties. * Left Click on Find Target. * Right Click on the Data3 folder in the newly opened folder. text/html 2019-01-27T11:28:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backup_database?rev=1548606499&do=diff [[backup_cyrious_sms_database|Backup Cyrious SMS Database]] * setting_up_cyrious_to_do_the_backups * backing_up_sms_v8.6_data * backing_up_sms_v8_data * backing_up_sms_v2000_data3 text/html 2019-01-27T11:28:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/backup_database_set-up?rev=1548606500&do=diff [[backup_cyrious_sms_database|Backup Cyrious SMS Database]] * sms_backup_database_set-up_v8.6_and_higher * steps_to_setup_cyrious_for_automated_backups_-_sms_v8.6_and_higher * backing_up_sms_v8.6_data * backing_up_sms_v8_data * backing_up_sms_v2000_data3 text/html 2019-01-27T11:28:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/basic_tips_for_troubleshooting_control_server_and_associated_services?rev=1548606500&do=diff First Steps to take: * Log out of Control and back in. * Restart Computer. * Restart the SSLIP and Chapi. * Restart your Server then the SSLIP and Chapi. Depending on how your network was set up, you may need to log into your server after a Windows Update. text/html 2019-07-03T12:19:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/bde_error_table_is_full?rev=1562170769&do=diff Error Message “Table is Full” ... Explanation of Error The BDE limits the size of the data transferred onto the HD in the BDEAdmin. As databases grows and as HD size have exceeded 4 GB, there is an increase need for larger block size transfers text/html 2019-07-15T15:09:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/bde_settings?rev=1563217753&do=diff BDE Settings Explanation The Borland Database Engine (BDE) settings are automatically configured during the installation and/or update of Cyrious SMS. At times though, other programs or staff may have modified the settings to address a specific problem. As a reference, below are the settings that provide the most stable BDE environment. text/html 2019-01-27T11:28:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/benchmark?rev=1548606501&do=diff Cyrious Tip - Setting up benchmark utility and running on client machines Step 1 Creating mapped drive to test network speeds with benchmark tool located in Cyrious installation directory. * On client machine, right-click on SMS/Control shortcut and click text/html 2019-01-27T11:28:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/black_screen_when_opening_production_terminal?rev=1548606501&do=diff Description You see nothing but a black screen when attempting to open Production Terminal from your computer. Possible Causes: * Windows 7 Pro visual effects may be preventing the browser from displaying properly. * Unhandled Error in Silverlight Application ( text/html 2019-01-27T11:28:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/bms_support?rev=1548606501&do=diff BMS Support By Subject * BMS Installation * BMS Database Error * BMS Order Entry * BMS Estimate Entry * BMS Company Entry * BMS AR Payment Entry|A.cyriouswiki.com/r_payment_entry * BMS AP Check Printing|A.cyriouswiki.com/p_check_printing * BMS Voucher Entry By Type of Error * BMS Unable to Open * BMS Unable to Login * BMS Unable to Print * BMS Reports Dont Match text/html 2019-01-27T11:28:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/borland_registry_installation?rev=1548606502&do=diff Concept SMS uses the Borland Database Engine (BDE) to power the lookups, reads, and writes from the database. The location of the BDE files is found by looking the path up in the registry (Window's internal database). If this information is not found, SMS will not be able to load the BDE and the user will get the following error message: text/html 2019-01-27T11:28:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/c3s?rev=1548606502&do=diff How-To's * Control - How-To xxx How Do I's * Control - How Do I ... xxx Questions * question_-_what_is_c3s text/html 2019-01-27T11:28:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/c3s_errors_for_sms?rev=1548606502&do=diff Explanation This is a Borland Database related error due to the limitations of HDs at the time Borland was created. Error Messages in Logs In the SSLIP Error log, you will possibly see “Error looking up CRIX information: || Unknown database.” text/html 2019-07-02T12:04:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/can_i_use_a_vm_virtual_machine_to_host_sql_server?rev=1562083461&do=diff Can I use a VM (Virtual Machine) to host SQL Server? Answer NOTE: See additional information for VMWare at the end of this article. Cyrious' answer is that you can, but you should not. Unless you have a very high-end (expensive) version of SQL Server, your text/html 2019-01-27T11:28:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/can_not_install_crystal_reports_-_error_1327_invalid_drive?rev=1548606503&do=diff Explanation This error occurs on Windows Vista/7 systems that have the user's documents folder mapped to a network drive. To get around this, you will need to change the mapping back to the UNC path. Example: In Regedit, go to: Hkey_Current_user\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folder\Personal text/html 2019-01-27T11:28:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/can_the_sslip_be_run_as_a_service?rev=1548606503&do=diff ? Question How do I configure the SSLIP to run as a service? Answer The SSLIP can not be configured to run as a service. The SSLIP is a windows application that can only be run as an application. The SSLIP was not designed to run as a service on Windows. In order for users to successfully access Cyrious the SSLIP must be running at all times. text/html 2019-01-27T11:28:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cannot_create_file_-_file_name._right-click_the_folder_you_want_to_create_the_file_in_and_click_properties_on_the_shortcut_menu_to_check_your_permissions_for_the_folder?rev=1548606504&do=diff Explanation This error appears when there is a problem with Outlook. Found the following link to MS that helped resolved the issue. Be sure to confirm the version of Outlook before following its steps. Resolution * Confirm version of Outlook * text/html 2019-01-27T11:28:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cannot_open_without_a_valid_database?rev=1548606505&do=diff Unable to Open without a valid database Explanation Resolution * Log into SSLIP. * Go to Database Administration * Click on SMS group * Click Test Connection * Make sure connection is successfull. * If not, check physical file location and if Database is missing or in another directory, correct either the location of the Database or the SSLIP Data path. text/html 2019-01-27T11:28:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cant_get_a_fresh_bde_to_install?rev=1548606503&do=diff Explanation For security, Vista forbids programs from writing to a variety of “sensitive” areas, among them the Windows folder and the Program Files folder. That includes all subfolders of Program Files, so this ban would be a hardship on older programs that store INI files or data files along with the program itself. To avoid disabling these programs, Windows Vista lies to them. When they try to write to a banned location, it says text/html 2019-01-27T11:28:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cant_print_sales_report_sales_tax_report_or_export_accounting_data?rev=1548606504&do=diff Explanation This is because someone changed the Report Export path and Cyrious did not accept the change. Resolution * Click on Mgmt * Drill down to Set-Up * Drill down to Machine Set-Up * Note the Report Export file name - end of path * text/html 2019-01-27T11:28:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cant_send_email._locks_up_cyrious?rev=1548606504&do=diff Explanation of Issue Unable to send email using Cyrious but does not get an error message. It appears as though the program becomes unresponsive at the point of sending the email. The only way to resume activity in Cyrious is to end the SMS.exe or Control.exe process and reopen Cyrious. text/html 2019-01-27T11:28:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/change_order_status?rev=1548606505&do=diff Order Status Summary Steps to change the status of an order * Open the order. * Click the arrow next to Status on the Right Toolbar to quickly change Order Status. * Click the Status button itself to open a Payment Entry window. * From here you can adjust the Status as well as the text/html 2019-01-27T11:28:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/class_not_register?rev=1548606505&do=diff Explanation Resolution * Explain to customer that they need to get the MS Office disk out and run the Repair utility text/html 2019-01-27T11:28:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/class_not_registered?rev=1548606505&do=diff Description Class Not Registered error message when opening a word document from SMS marketing or Control reporting. Explanation When opening a Word report, SMS and Control have to lookup the version of Word to open. This is done inside the registry. It works something like this: text/html 2019-01-27T11:28:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/client_randomly_loses_connection_to_server?rev=1548606506&do=diff Explanation This happens in a mixed OS environment in which Windows 7 is the Server OS. This is a result of security measures Windows 7 takes when it runs an program. To fix this, terminate the client instance that is running on the server, and launch it on another machine text/html 2019-01-27T11:28:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/closed_out_and_the_daily_totals_on_daily_activity_report_is_zero?rev=1548606506&do=diff Explanation Resolution * Check to see if Daily Close action was performed before Quick Reports were run. * To check, open DBBrowser. * Go to Closeout Database. * Scroll to the bottom of the table records to view the most recent Closeouts. text/html 2019-06-13T18:25:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/contol_reports?rev=1560464750&do=diff How-To's How Do I's Information * Control Question - What Version of Crystal Reports do I Need * Crystal Reports Keeping SQL Connections text/html 2019-01-27T11:29:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_client_install?rev=1548606555&do=diff Explanation There are three methods of installing Control on a client PC. In order of easiest to most difficult: 1. Use the Cyrious Launcher * Log into cyrioussoftware.com on the client PC * Go to Tech Support > Downloads * Download the Cyrious Launcher and run it text/html 2019-01-27T11:29:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_installing_crystal_reports_xi?rev=1548606555&do=diff Explanation Control requires Crystal Reports drivers to generate any printed documents, since all reports in Control (even invoices and estimates) are made using Crystal Reports. These drivers must be installed on each machine that uses Control. It is a good practice to install the Crystal Reports drivers each time you install Control on a new client. text/html 2019-06-10T11:58:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_new_control_5.1_server_install?rev=1560182309&do=diff Explanation This article details installing Control 6.1 using the installer. For Control 5.5 manual installation instructions, click here. Download the installer * Go to www.cyrioussoftware.com and log in * At the top of the page, click Tech Support * In the gray bar below, click Downloads text/html 2025-01-15T11:39:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_new_control_5.5_server_install?rev=1736959146&do=diff Cyrious Customer Site (www.cyrious.com/customer) Explanation This article details installing Control 5.5 using the installer. For manual installation instructions, click here. Download the installer * Go to Cyrious Customer Site (www.cyrious.com/customer) and log in * At the top of the page, click Support * From the drop down, click Downloads text/html 2019-01-27T11:29:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_performing_a_server_swap?rev=1548606556&do=diff Explanation This article describes how to move Control to a new server. This only applies to a standard Control configuration: 1 database, 1 SSLIP. Prepare for the swap * What version of Control is installed on the existing server? * In Control, go to the Help menu at the top of the screen and click About Control to find the version. Alternatively, you can right-click on the Control.exe file and choose Properties, then look at the Details tab to get the version. text/html 2019-01-27T11:29:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_upgrade_5.5_to_latest_release?rev=1548606556&do=diff Explanation If the version of Control running is 5.x, use these instructions to upgrade to the latest build. If your version is 4.5 or later consult with Tier 2,3 Tech before moving forward. Download the updater * Go to www.cyrious.com/customer and log in. * At the top of the page, hover over text/html 2019-01-27T11:29:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control1_-_upgrade_version_4.6_to_5.5?rev=1548606556&do=diff Explanation This will get the Cyrious server upgraded from Control 4.6 to Control 5.5. All users must log out of Control prior to upgrading. Important: If Merchant Warehouse (now known as Cayan) is used for credit card processing, do not perform this update text/html 2019-01-27T11:28:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_automating_backups_in_sql_express?rev=1548606507&do=diff Automating Backups in SQL Server 2005 Express Edition NOTE: This original documentation of this utility is no longer online. You will need to utilize other resources online, try google.com for assistance with this utility. Overview Microsoft SQL Server Express Edition does not include a built-in backup utility like the full versions of SQL Server offer within maintenance plans. However, this does not mean that you can not automate the backup process with a few small steps. This tutorial assum… text/html 2019-01-27T11:28:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_backing_up_the_database_in_sql?rev=1548606507&do=diff Backing Up a Database in SQL Steps To back up a database - When you connect to the correct instance of the Microsoft SQL Server Database Engine, look in Object Explorer, and click the server name to expand the server tree. - Expand Databases, System Databases and select StoreData or whatever the system database is called for Control. - Right-click the database, point to Tasks, and then click Back Up. The Back Up Database will appear. - In the Database list box, verify the database name. - Yo… text/html 2019-01-27T11:28:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how-to_retain_prior_tax_rates?rev=1548606508&do=diff Currently, whenever you change your tax amounts and go to edit an existing order or invoice, Control will automatically update the taxes for you. But what if you don't want it to update the taxes for you? Instead you would prefer to keep the original tax rate on the order. text/html 2019-01-27T11:28:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how-to_unvoid_an_order?rev=1548606508&do=diff Question How do I un-void an order that was aaccidentally voided? Answer Unfortunately, Cyrious does not allow you to directly “unvoid” an order. This is an administrative control point and there is no work-around to “recapture” the invoice number. The only alternative is to create a new order with the same items. text/html 2019-01-27T11:28:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how-to_write_off_an_order?rev=1548606509&do=diff When an balance due on an order is determined to be “uncollectable”, Control provides a mechanism to write-off the balance. Like a payment, write-off reduces the balance due on the order and corresponding accounts receivable. Unlike a payment, however, the amount of the reduction is an expense (or contra-income). text/html 2019-01-27T11:28:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how_do_i_..._post_a_payment?rev=1548606507&do=diff Question How do I post a payment in Control? Answer There are several different ways of opening a payment entry window within Control. I will outline each way below, ultimately the end result is the same however the way you choose is completely based on your preference and what you find most efficient. Additionally, there are two different types of payment entry windows available for use. text/html 2019-01-27T11:28:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how_do_i_..._void_a_payment?rev=1548606507&do=diff Question How do I void a payment in Control? Answer To void a payment on an order: * Open Order that the payment was applied to. * Click on the Activities Tab. * Right-click on the Payment activity. A menu will appear. * Choose Void from the menu. text/html 2019-03-12T16:48:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_how_to_determine_the_size_of_each_sql_database_table?rev=1552423689&do=diff Explanation of SQL This set of SQL queries will create a stored procedure that will generate a list of tables with their relevant sizes. An excel spreadsheet has been provided for additional formatting of the data. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:28:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_new_control_5.6_server_install?rev=1548606509&do=diff Explanation This article details installing Control 5.6 using the installer. For manual installation instructions, click here. Download the installer * Go to www.cyrioussoftware.com and log in * At the top of the page, click Tech Support * In the gray bar below, click Downloads text/html 2019-01-27T11:28:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_order_tax_settings_lookup?rev=1548606509&do=diff The purpose of this article is to layout the rules Control uses to lookup which Tax Class and Tax Exempt status to apply to line items and shipment items. When shipments are involved, the shipment calculates taxes for the portion that is shipped. The line item calculates the amount that is not part of a shipment. So, if you have a line item with a quantity of 5 and a subtotal of $100, and you ship 3 items, the shipment will calculate the tax of $60 and the line item will calculate the tax of … text/html 2019-01-27T11:28:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_sql_server_maintenance_procedures?rev=1548606509&do=diff SQL Server Maintenance Procedures This topic describes how to shrink a database by using Object Explorer in SQL Server Management Studio. The database cannot be made smaller than the minimum size of the database. The minimum size is the size specified when the database was originally created, or the last explicit size set by using a file-size-changing operation, such as DBCC SHRINKFILE. For example, if a database was originally created with a size of 10 text/html 2019-01-27T11:28:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_-_updating_the_system_while_control_is_running?rev=1548606510&do=diff Often it is not feasible to shut down all the users in the middle of the day to apply an update. However, it may be desireable to have all the updated files in place so that the system is down for a minimum amount of time and the upgrade can be applied easily at a later time. text/html 2019-01-27T11:28:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_5.1_manual_installation?rev=1548606510&do=diff Explanation The following is the preferred method of performing a clean install of version 5.x manually. Before you begin, make sure of 2 things: * ONLY perform a manual installation if the automatic installer package will not work. * Verify that the server device meets or exceeds all hardware requirements text/html 2019-01-27T11:28:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_5.1_server_swap?rev=1548606510&do=diff Explanation The following is the preferred method of installing version 5.1 manually. Before you begin, make sure of 4 things: * ONLY perform a manual installation if an update or installation via an installer package will not work. * DO NOT install CHAPI at all until you know what modules the customer should have. Check their security dongle or keyfile, and check the authorizations tab of their company record in Cyrious Internal. If the information does not match, check their order record… text/html 2019-01-27T11:28:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_access_violation?rev=1548606511&do=diff Control Access Violation Errors An Access Violation occurs when the software attempts to access a piece of memory that is presently inaccessible. This is commonly caused by Faulty RAM or a hardware driver, and is usually remedied by restarting Control or the host's computer. Some example error codes found in Access Violations are as follows: text/html 2019-05-24T16:30:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_activity_manager?rev=1558729803&do=diff Marketing and Activity Manager Marketing and Activity Manager Marketing and Activity Manager Setup Screen Where is Activity Manger Options located? Setup > System Setup > Marketing and Activity Manager These options control the following behavior in Control: text/html 2019-01-27T11:28:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_ar_payment_entry?rev=1548606511&do=diff Common Control A/R Errors * control_error_-_invalid_account text/html 2019-01-27T11:28:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_crashes?rev=1548606511&do=diff no_response_from_sslip_when_checking_record_lock text/html 2019-01-27T11:28:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_database_error?rev=1548606511&do=diff Control utilizes a Microsoft SQL Server database for all customer information, though read-only system configuration information is stored in two Microsoft Access Databases *(referred to collectively as SystemData). SQL Server is a true server database, meaning all requests for information are forwarded to the server for processing and the results are then sent back to the client. Server databases are inherently much more stable (and faster) than non-server databases (like Access and Paradox). text/html 2019-01-27T11:28:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_email_errors?rev=1548606512&do=diff Specific Email Errors * control_error_-_email_authentication_failed * control_error_-_invalid_class_type_string Test Email Account This information is provided to assist with the determination in regards to the problem a Cyrious user is having difficulties emailing from the Cyrious program. This test account is only available to Cyrious technicians while troubleshooting the ability to email directly from Cyrious. text/html 2019-01-27T11:28:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_access_violation_-_general_remedies?rev=1548606512&do=diff Control Error - Access Violation Error Message “Access Violation in xxxxx” Explanation of Error This is a general memory access violation error. See control_access_violation for a broader explanation. Severity Depends on Situation. Usually closing and restarting will clear the problem. Often just closing the screen will. text/html 2019-01-27T11:28:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_blank_second_page?rev=1548606512&do=diff Invoice/Estimate Printing Blank Second Page Explanation If when previewing or printing an invoice or estimate a blank second page is always printed, the likely cause is a product layout exending past the right margin of the page. Reducing the width of the product layout and resaving the order will usually correct the problem. text/html 2019-01-27T11:28:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_class_not_registered?rev=1548606512&do=diff Error Message Class is Not Registered when attempting to print a Crystal Report. Explanation of Error When Control tries to invoke Crystal Reports, it initiates a call to Windows to create an object of type (a.k.a. class) Crystal Report. This message is an error message from Windows telling the user that the class you are trying to create is not registered in the Registry and so it doesn't know how to create it. text/html 2019-01-27T11:28:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_could_not_load_record?rev=1548606513&do=diff Error Message Could not load record Explanation of Error This is a generic error from Control indicating that a record it was expecting could not be found. This is usually an indication that Control tried to open a dependent record but it could not find it. text/html 2019-01-27T11:28:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_datetime_outside_the_valid_range?rev=1548606513&do=diff Error Message This WIKI page address the following error: “The conversion of char-value to a datetime has resulted in a datetime outside the range” Explanation of Error All Control internal SQLs use the US format for dates (dd/mm/yy). This error can occur when the date formatting of the SQL server does not match the date formatting being used by Control. text/html 2019-01-27T11:28:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_email_authentication_failed?rev=1548606513&do=diff Error Message Error checking email:Authentication failed Explanation of Error The Customer receives this error when trying to email out of Control. Severity Normal. User is not down but cant email from that machine using internal settings. Possible Root Cause(s) text/html 2019-01-27T11:28:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_floating_point_overflow?rev=1548606514&do=diff Error Message Floating Point Overflow (when attempting to print) Explanation of Error This is a problem with the HP2600n drivers (and possibly others). Resolution The HP2600Fix switch needs to be turned on. This can be done in one of three ways. text/html 2019-01-27T11:28:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_invalid_account?rev=1548606514&do=diff Control Error - Invalid Account Error Message The General Ledger entries for Company “xyz”, Order “1234” Contain an unrecognized or invalid account. Please consult Cyrious Technical Support for assistance in troubleshooting this problem Explanation of Error text/html 2019-01-27T11:28:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_invalid_class_type_string?rev=1548606514&do=diff Error Message Invalid Class Type String Explanation of Error Whenever emailing out of Control using Outlook. Severity Normal. User is not down, but can't email out Control. Possible Root Cause(s) The registry entry for Outlook that Control needs is either missing or corrupt. text/html 2019-01-27T11:28:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_invalid_tlv_record?rev=1548606514&do=diff Control Error - Invalid TLV Record Error Message Invalid TLV Record Explanation of Error Unfortunately, this message only means that Crystal Reports hit an unexpected error in the opening of the report. When a report is printed, the system report is extracted to your temp folder. (For custom reports, it is copied there anyway so that multiple people accessing the report don't cause problems with Crystal - which it does.) One situation we've come across is that when you print out of Control … text/html 2019-01-27T11:28:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_log_in_failed._database_group_not_found?rev=1548606515&do=diff Error Message Log in failed. Database group not Explanation of Error The customer receives “database group is not active” when trying to startup Cyrious Control. Severity High.User is down. Possible Root Cause(s) 1) One or more of the database groups inside of database administration in the SSLIP text/html 2019-01-27T11:28:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_login_failed_for_user_cyrious?rev=1548606515&do=diff Error Message Database connection failed: Login failed for user 'cyrious'. The user is not associated with a trusted SQL Server connection. Explanation of Error All connections from Cyrious Control and the SSLIP log into SQL using a SQL user called text/html 2019-01-27T11:28:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_no_data_found?rev=1548606515&do=diff Error Message Printing a report results in a mostly blank page with the text “No Data Found.” in red. Explanation of Error To populate a Crystal Report, a query is generated and sent to the database for results. Many of the system reports in Cyrious are designed to print text/html 2019-01-27T11:28:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_no_names_in_login_user_dropdown?rev=1548606515&do=diff Control Error - No Names in Login User Dropdown Error Message None Explanation of Error The login screen for Control contains a UserName dropdown with a list of all the valid users set to login to Control. The list of names is retrieved from the SSLIP, but the list is empty. (If the SSLIP communication was not successful a different message would be displayed.) text/html 2019-01-27T11:28:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_not_enough_server_storage_is_available_to_process_this_command?rev=1548606516&do=diff Explanation of Error When when you try to access shares on a machine from a client you might receive “Not enough server storage is available to process this command.” error. You may also come across this message and Event ID: 2011 in Event Viewer after you install Norton Antivirus for Windows (which seems to be the most common reason why people see this message). text/html 2019-01-27T11:28:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_not_enough_space_is_available_to_process_this_command?rev=1548606516&do=diff Error Message Not enough space is available to process this command Explanation of Error When trying to create orders, print, or use general functions in Control, the user will sometimes receive this error. Severity Normal : Problem can be temporarily resolved by closing and reopening Control. text/html 2019-01-27T11:28:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_nothing_happens_when_opening_control?rev=1548606516&do=diff Error Message When you double-click on the Control icon, nothing happens. Explanation of Error The most likely causes of this error (in order of priority) are: * A copy of Control is hung in the background. * The user is not double-clicking properly/fast enough or the mouse if not registering the double-click. text/html 2019-01-27T11:28:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_stuck_on_printing_reports?rev=1548606517&do=diff Error Message Eventually results in a SQL Timeout error message for other users. Also causes reports to hang on “Preparing Reports” Explanation of Error When running a Crystal Report with a direct SQL Command, Crystal by default locks the SQL result sets. This means that while someone is viewing a report (has it on the screen) other users may be prevented from opening, saving, etc. their records. text/html 2019-01-27T11:28:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_unable_to_locate_rpc_server?rev=1548606517&do=diff Error Message “Unable to locate RPC Server” when trying to print or email in Control. Explanation of Error The Remote Procedure Call (RPC) service is the mechanism Windows uses for one application to call into another. This is a core component in Windows and any restriction on the service will cause significant problems in Windows. text/html 2019-01-27T11:28:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_unable_to_locate_sslip_message?rev=1548606517&do=diff Control Error - Unable to Locate SSLIP Error Message “Unable to Locate SSLIP” when Control is launched. Explanation of Error When launched, one of the first thing Control does it try to locate the SSLIP to obtain the list of user login names (among other things). It does this using a UDP broadcast on the local network (by default this is on port text/html 2019-01-27T11:28:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_error_-_you_must_use_the_role_management_tool_to_install_or_configure_microsoft_.net_framework_3.5?rev=1548606517&do=diff Error Message You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5. Explanation of Error When attempting to complete the install of Cyrious Control onto a system with the Microsoft Windows Server 2008 R2 operating system you encounter the error above. text/html 2019-01-27T11:28:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_installation?rev=1548606518&do=diff Control Setup Errors This section describes common errors when trying to install Control for the first time. * control_error_-_you_must_use_the_role_management_tool_to_install_or_configure_microsoft_.net_framework_3.5 * control_oob_installation_password text/html 2019-01-27T11:28:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_invalid_floating_point_operation?rev=1548606518&do=diff =Error Message= The user received an “Invalid Floating Point Operation” when creating or editing an order or estimate. =Explanation of Error= A “floating point number” is computer-speak for a decimal number. An “operation” in this case is a math operation. In practive, almost every text/html 2019-01-27T11:28:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_login?rev=1548606518&do=diff Control Login Errors This class of error describes error with being unable to log into Control. Common Control Login Problems * control_error_-_nothing_happens_when_opening_control * control_error_-_unable_to_locate_sslip_message * control_error_-_no_names_in_login_user_dropdown * Control Error - Login Failed Message * control_error_-_login_hangs_at_xxxx|control_error_-_login_hangs_at_xxxx|Control Error - Login Hangs at xxxx * control_error_-_login_hangs_at_xxxx|control_error_-_lo… text/html 2019-01-27T11:28:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_not_enough_storage?rev=1548606518&do=diff Error Message Not enough server storage is available to process this command Explanation of Error Not Enough Storage usually refer to insufficient hard-drive space, though often they are a result of lack of memory or a write failure caused by some other problem (like permissions or anti-virus). text/html 2019-01-27T11:28:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_oob_installation_password?rev=1548606519&do=diff When you are installing Control OOB, you may be prompted for an installation password. This password determines which database is installed during the process. The standard password for independent users is: 56333079963 Version Information * text/html 2019-01-27T11:28:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_order_entry?rev=1548606519&do=diff How-To's * control_-_how-to_write_off_an_order * control_-_how-to_unvoid_an_order * control_-_how-to_retain_prior_tax_rates Other * control_-_order_tax_settings_lookup text/html 2019-01-27T11:28:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_part_usage_cards?rev=1548606519&do=diff Support Topics * recreating_part_usage_cards_from_scratch text/html 2019-01-27T11:28:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_payments?rev=1548606519&do=diff How Do I's * control_-_how_do_i_..._post_a_payment * control_-_how_do_i_..._void_a_payment * how_do_i_..._refund_a_payment * how_do_i....handle_a_nsf_check * how_do_i_..._refund_or_void_a_processed_credit_card_payment_that_fails_to_refund Why's * why_..._is_there_no_overpayment_field_when_applying_a_payment_in_control Online Credit Card Processing with Control * Online Credit Card Processing Options * How Do I contact Capital Q to Signup for Credit Card Processing * How To… text/html 2019-01-27T11:28:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_pricing?rev=1548606520&do=diff Control Pricing Errors This section lists common Control pricing error. Common Control Pricing Problems * control_error_-|Control Error - Price Not Correct * Control Error - text/html 2019-01-27T11:28:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_printing?rev=1548606520&do=diff Control Error - Unable to Print Category * control_error_-_invalid_tlv_record * control_error_-_stuck_on_printing_reports * control_error_-_unable_to_locate_rpc_server * control_error_-_class_not_registered * control_error_-_floating_point_overflow * control_error_-_no_data_found * control_error_-_blank_second_page * external_exception_when_printing * logon_failed._details_database_vendor_code_18456 * unable_to_save_report_as_pdf * Crystal Reports Previews show up as blank… text/html 2019-01-27T11:28:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_production_terminal?rev=1548606525&do=diff Did you install Silverlight? Is Port 80 open on your Web Server? IIS Errors 405_method_not_supported 500 Internal Server Error - No Details 500.19 The requested page cannot be accessed because the related configuration data for the page is invalid. Production Terminal Errors Login Page black_screen_when_opening_production_terminal store_logo_appears_but_is_not_the_correct_image external_exception_when_accessing_production_terminal Work Order production_terminal_-_file_not_found_excep… text/html 2019-01-27T11:28:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_question_-_what_version_of_crystal_reports_do_i_need?rev=1548606526&do=diff Question What version of Crystal Reports does Control use? Answer Control uses Crystal Reports XI. Because Control interacts with the report and does not just tell the Crystal engine to print it, other versions of Crystal Reports will not work with Control. text/html 2019-01-27T11:28:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_question_-_what_versions_of_windows_are_supported?rev=1548606526&do=diff Question What versions of Windows are supported by Control? Answer As of 1/1/2010, the following versions of Windows are supported for use with Cyrious Control or Cyrious SMS: * Windows XP * Windows XP Professional (32-bit) * Windows XP Professional Edition N (32-bit) text/html 2019-01-27T11:28:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_reports_changed_after_update?rev=1548606526&do=diff This page lists common issues concerning report changes raised by customers after an update. From version to version most reports should not change, though Cyrious reserves the right to change any or the system reports based on user feedback or its own business purposes. text/html 2019-01-27T11:28:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_reports_dont_match?rev=1548606527&do=diff This page lists common errors associated with customer requests that differing reports don't match each other. This is generally caused by one of the following issues: Steps to Diagnose * Have copies of the report faxed or emailed over to technical support. text/html 2019-05-24T16:12:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_slow?rev=1558728778&do=diff Control Slowness Control Slowness The software seems slow or freezes when making adjustment. Periodically crashes when saving data. Concept The item rarely ever produces an error message. Commonly this is the result of communication to the server or the SQL Database for a brief moment. The issue is better defined by weather it is intermittent or continuous. text/html 2019-01-27T11:28:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_socket_connection_error?rev=1548606527&do=diff This is a short list of suggestions for fixing the Socket Connection Error in Windows whenever attempting to start Control from a client machine. 1st suggestion setup_a_port_offset 2nd suggestion reset_tcp_ip_and_winsock_settings_for_windows_xp text/html 2019-01-27T11:28:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_add_function_to_compare_inventory_totals_to_log_records?rev=1548606528&do=diff Explanation of SQL This SQL will create a function that returns a table with any discrepencies between the inventory counts of a part and what the inventory should be based on a recreation of all events in the inventory log table. Risk of Data Corruption if Run Improperly text/html 2019-05-23T18:01:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_adjust_reserved_inventory_levels_to_match_orders?rev=1558648876&do=diff Question How do I adjust the Reserved Inventory Levels in Control? Answer The Reserved Inventory Quantity in Control is an auto-calculated count that you can not directly adjust. * The Reserved Quantity is a sum of all estimated usage (minus Actual posted usage) of inventoried parts that are for Orders in a status of WIP & Built. text/html 2019-02-05T11:30:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_ap_integrity_check?rev=1549384230&do=diff Control SQL - AP Integrity Check Explanation of SQL This query compares the A/P balance of bills in the GL with the balance in the TransHeader record. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-02-05T11:30:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_ar_integrity_check?rev=1549384213&do=diff Control SQL - Explanation of SQL This SQL compares the A/R balance in the Order (TransHeader) database with the GL database. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL text/html 2019-02-05T11:20:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_balance_sheet_or_journal_out_of_balance?rev=1549383651&do=diff Explanation of SQL This query looks at each order and each journal entry and makes sure each is in balance according to the rules of the balance sheet. Any orders or journal entries that are not are listed. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:28:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_change_prospect_to_client?rev=1548606530&do=diff Explanation of SQL When customers import contacts from another program that have not placed an order in Control, they are considered a “Prospect” in the system. There is no mechanism in Control to change these manually to be “Clients”. This SQL will set text/html 2019-02-01T10:08:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_check_all_inventory_levels_v_all_inventory_logs?rev=1549033702&do=diff Explanation of SQL SQL finds any discrepancies between the actual inventory record numbers vs the actual inventory log entries that have been posted. This query will show you if any of the parts or inventory records are out of sync. Note: This query is only written for a single warehouse & division. It needs to be modified before running on a multi-division or multi-warehouse system. text/html 2019-01-27T11:28:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_check_inventory_on-order_levels_v_ordered_pos?rev=1548606531&do=diff Explanation of SQL The following query will locate and repair any discrepancies between the On Order amount in inventory and the total on order in P.O.s. NOTE: If you execute this query with @CommitChanges = 0, it will NOT apply any changes and only display a list of the inventory items with discrepancies. text/html 2022-07-07T11:20:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_check_inventory_received_levels_on_pos?rev=1657207205&do=diff Explanation of SQL The following query will locate and repair any discrepancies between the Received amount in inventory and the total Received on P.O.s. This only works with PO's, if you are using Receiving Documents in conjunction with PO's then you will need a different query. text/html 2019-01-27T11:28:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_check_that_gl_accounts_are_under_valid_categories?rev=1548606532&do=diff Explanation of SQL GL Accounts in Control are ordered in a hierarchy, with all GL Accounts under Groups. Occassionally, a GL Account may be in Control that is not under a valid GL Account Group. In this case the account will show in certain cases (when Accounts are listed in a flat list) but not in cases when the hierarchy is used. text/html 2019-01-27T11:28:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_create_inventorylog_and_gl_entries_to_balance_historical_inventory?rev=1548606532&do=diff Explanation of SQL *This is only approved for use in Control version 4.6 or lower. Do not use in Control version 5.1.* This SQL compares the historic GL with the historic InventoryLog and then compares them based on the CURRENT inventory value. It then creates the following to reconcile text/html 2019-01-27T11:28:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_create_inventorylog_records_so_they_match_inventory?rev=1548606533&do=diff Explanation of SQL This SQL is used to adjust the InventoryLog so that the totals match the current inventory in the Inventory table. It does this by creating an adjustment record in the InventoryLog table for any difference found. *Notes:* * This query does text/html 2019-02-05T11:28:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_customer_credit_balance_integrity_check?rev=1549384110&do=diff Control SQL - Customer Credit Balance Integrity Check Explanation of SQL This SQL compares Customer Credits in the GL with Customer Credits in the Customer Database. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-01-27T11:28:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_customer_credit_balance_integrity_checks_5.75?rev=1548606533&do=diff text/html 2019-01-27T11:28:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_customer_write_offs?rev=1548606533&do=diff Explanation of SQL To locate all write offs in the system by company name. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL select * from gl where glaccountid=51 order by entrydatetime text/html 2019-01-27T11:28:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_direct_cost_from_bills_details?rev=1548606534&do=diff Explanation of SQL This query provides a breakdown of the ins and outs for the Direct Cost from Bills GL Account. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL select *, --(select SUM(amount) -- from GL -- where -- GLAccountID = 15 -- and EntryDateTime >= Temp.EntryDateTime -- and ID >= GLID) as RunningBalance, Sum(amount) over ( Partition By TransH… text/html 2019-01-27T11:28:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_duplicate_companies?rev=1548606534&do=diff Control provides an option as to whether duplicate companies are allowed. Even with this option set to not allow duplicates, they may be created from import or have been there from the past. This query will help identify the duplicate company names in the system. text/html 2019-01-27T11:28:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_fill_in_zero_unit_costs_in_inventory_log?rev=1548606534&do=diff =Explanation of SQL= In some cases (reasons not yet identified), the UnitCost is not filled in on the InventoryLog table. If you are trying to compute historical inventory valuations, this can cause problems as the computed price will be zero. This SQL fills in the unit cost with the last unit cost that is not zero for that part. text/html 2019-02-05T11:20:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_find_an_order_number_with_the_transaction_id?rev=1549383615&do=diff Control SQL - GL Out of Balance By Order Explanation of SQL This query shows the ordernumber in the gl when you have just the transaction id. Risk of Data Corruption if Run Improperly Low. No data is modified in the running of this query. SQL select ordernumber from transheader where id= text/html 2019-02-05T11:18:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_find_gl_out_of_balances?rev=1549383488&do=diff Control SQL - Find GL Out of Balance Explanation of SQL This query is run to identify any places the GL: * Is Out of Balance Overall * Is Out of Balance for a Division * Will result in an improper Balance Sheet/Income Statement * This part not implemented yet text/html 2019-01-27T11:28:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_find_large_variances_in_inventorylog_unit_costs?rev=1548606535&do=diff Explanation of SQL This Query identified places in the InventoryLog where the UnitCost changes abruptly (more than 10%) between successive entries for a given part. This may indicate problems with the UnitCost. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:28:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_find_negative_balance_due_orders?rev=1548606536&do=diff Explanation of SQL Use this query to find orders with negative balance due. This is usually due to a bug whereby payments could be doubled (really entered twice without refreshing) or even tripled. This query finds those affected orders. Risk of Data Corruption if Run Improperly text/html 2019-04-23T09:44:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_find_off-of-balance_sheet_issues?rev=1556027054&do=diff Explanation of SQL Prior to mid 2009, Control only checked if the entire GL entry was in balance, not if the Off-Balance sheet portion and on-balance sheet portion were both in balance by themselves. It was therefore possible to set up parts that used On-Balance Sheet Inventory and Off-Balance Sheet Expenses (then called computed costs). text/html 2019-01-27T11:28:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_fix_incorrect_gl_inventory_and_cost_entries_when_wip_orders_voided?rev=1548606537&do=diff =Explanation of SQL= When an order in WIP is voided, any parts not already marked as used should be returned to inventory. The Inventory Activity correctly did so, but a bug in Control caused the GL to record a charge against inventory in in expenses. These entries should have been zero. text/html 2019-01-27T11:28:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_fix_inventorylog_to_point_to_proper_inventory_record?rev=1548606537&do=diff Explanation of SQL This SQL will correct a problem in the InventoryLog table where the InventoryID it points to is a warehouse or division summary and not the actual InventoryID. Risk of Data Corruption if Run Improperly High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL text/html 2019-02-05T11:27:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_gl_balance_integrity_checks?rev=1549384074&do=diff Control SQL - GL Balance Integrity Checks Explanation of SQL This query checks that the following items for consistency between the GL and other areas: * A/Rs - ensures the GL A/Rs match those in the Order database * A/Ps - ensures the GL A/Ps match those in the Bills database text/html 2019-02-05T11:19:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_gl_out_of_balance_by_order?rev=1549383541&do=diff Control SQL - GL Out of Balance By Order Explanation of SQL This query shows a breakdown of any out-of-balance in the GL broken down by Order. Risk of Data Corruption if Run Improperly Low. No data is modified in the running of this query. SQL -- GL Out of Balance By Order DECLARE @StartDate DateTime SET @StartDate = '1/1/2008' SELECT (SELECT DivisionName AS Division FROM EmployeeGroup WHERE OOBGL.DivisionID = EmployeeGroup.ID) AS Division, TransHeader.Orde… text/html 2019-01-27T11:28:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_historical_built_report?rev=1548606538&do=diff Explanation of SQL There is no report in Control that will produce a Built report for a period in the past. This SQL will pull that information and produce a Built report as of the specified time. To Use: Change the date at the start of the report to the target date and time. text/html 2019-01-27T11:28:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_historical_customer_credit_report?rev=1548606539&do=diff Explanation of SQL This SQL will provide a listing of all Customer Credits based on the GL as of a specific date. It can be run for all divisions (use Division = -1) or a specific division. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-01-27T11:28:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_historical_deposits_report?rev=1548606539&do=diff Explanation of SQL This SQL will provide a listing of all Customer Deposits based on the GL as of a specific date. It can be run for all divisions (use Division = -1) or a specific division. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-01-27T11:28:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_historical_wip_report?rev=1548606539&do=diff Explanation of SQL There is no report in Control that will produce a WIP report for a period in the past. This SQL will pull that information and produce a WIP report as of the specified time. To Use: Change the date at the start of the report to the target date and time. text/html 2019-01-27T11:28:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_credit_cards_processed_but_not_saved?rev=1548606539&do=diff Explanation of SQL If Control is terminated (e.g., CTRL-ALT-DEL) while processing an online credit card, the results of the credit card being run may not be written to the database. However, the C3S running as a separate service will still have a record of these. text/html 2019-01-27T11:29:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_deposits_in_a_make_deposit_batch?rev=1548606540&do=diff Explanation of SQL Given the JournalID of a make deposit entry, this query shows all of the payments that went into that Make Deposit. It also includes the make deposit entry itself (this is normally the top entry). Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:29:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_doubled_gl_from_bug_with_posting_payment_and_sale_simultaneously?rev=1548606540&do=diff Explanation of SQL In Control version 4.5 (release in July - September of 2010) a specific bug existed whereby when an order was paid and marked sale simultaneously (from the enter payment screens), the sales and A/R balance would be posted twice one on the payment and once in the text/html 2019-01-27T11:29:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_imbalances_in_make_deposit_entries?rev=1548606540&do=diff Explanation of SQL When funds are transferred from Undeposited Funds into a bank account via Make Deposits, Control posts the transfer and tags all the deposited funds with the DepositJournalID of the resulting transfer. This query compares the GL records of funds deposited with the SummaryAmount in the Journal and the GL record of the transfer and identifiesa any problems. text/html 2019-01-27T11:29:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_manual_postings_to_inventory_gl_accounts?rev=1548606541&do=diff =Explanation of SQL= The total of all GL Accounts that are for Inventory Tracking (GLClassificationType 1003) should match the total value of inventory for that specific period. However, certain user actions may result in these numbers no longer matching. These actions include: text/html 2019-01-27T11:29:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_identify_missing_inventory_entries?rev=1548606541&do=diff Explanation of SQL This query identified Parts that are inventories but are missing their entry in the Inventory table for a particular warehouse. Within Control, editing and saving these parts will automatically recreate the missing entries. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:29:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_invalid_gl_account_error?rev=1548606541&do=diff After upgrading to Control 4.5, marking an order Sale, editing, or posting a payment on an Order marked Sale gives an “invalid or unrecognized gl account” error message. Causes There are records in the GLAccount table with classtypeids of 8055 and 8051 with text/html 2019-02-05T11:32:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_invalid_gl_entries?rev=1549384363&do=diff Explanation of SQL These SQL's are used to verify the GL data is internally consistent. * In some historic data, we have seen cases where the GLClassificationType is not set properly. This field is used in several financial reports, most notably the Balance Sheet and Income Statement. If these reports are producing incorrect values, this SQL will help find/repair this problem. text/html 2019-01-27T11:29:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_log_database_record_locks_every_few_minutes?rev=1548606542&do=diff Explanation of SQL These queries create a temporary table and then every X minutes (set below) it inserts into that table information about any locked records in the SQL Database. Risk of Data Corruption if Run Improperly Small. No user data is modified by this query. text/html 2019-01-27T11:29:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_log_records_saved_without_changing_seqid?rev=1548606543&do=diff Explanation of SQL This SQL creates triggers on the TransHeader, TransDetail, Account, and AccountContact tables that monitor the data for problems that may be caused by refresh problems. Specifically, this query compares the SeqID of the new record and makes sure it is larger than the SeqID of the current record. If it is not, an entry is created in the ErrorTable table (which must be created as part of this). text/html 2019-01-27T11:29:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_look_for_gl_adjustment_entries_on_parts_not_inventoried?rev=1548606543&do=diff Explanation of SQL When you adjust the inventory level on a Part that is NOT accruing costs, no GL entries should be made. In some historic cases (in Control 4.3), these entries were made. This query identifies those entries. Once reviewed, they may be deleted or zero'd if desired. text/html 2019-01-27T11:29:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_move_all_open_artwork_groups_to_produced?rev=1548606543&do=diff Explanation of SQL This SQL marks all active artwork groups as Produced. It will also create the history entries as well. SQL Bridge is required for this query to work correctly. Risk of Data Corruption if Run Improperly HIGH. This query modifies data; therefore, you should make a backup of the database prior to running this query. text/html 2019-01-27T11:29:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_odbc_process_removal_query?rev=1548606544&do=diff Explanation of SQL This query kills all ODBC process in SQL Server that are created for generating reports. This is useful for removing SQL locks without having to close Control or the SSLIP. See control_error_-_stuck_on_printing_reports. Risk of Data Corruption if Run Improperly Moderate text/html 2019-02-05T11:29:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_order_deposit_integrity_check?rev=1549384190&do=diff Control SQL - Order Deposit Integrity Check Explanation of SQL This SQL compares the deposits on orders found in the GL to the deposits found in the TransHeader databse. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-02-05T11:33:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_payments_gl_integrity_check?rev=1549384384&do=diff Explanation of SQL This query compares the the Summary Journal for each payment to the GL record of it. Note that not all records indicated an error, as manual GL entries may show up in this report (and are not incorrect). Note: This report can take a long time to run (1-5 minutes). text/html 2019-02-05T11:27:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_plug_all_ar_balances_for_orders_not_in_sale?rev=1549384036&do=diff Explanation of SQL This query creates offsetting entries for any order not in Sale that have an A/R balance in the GL. Two entries are created, one to reverse the A/R balance and another one to PLUG the difference so the GL is not out of balance. You must set the plug account before using the query. This SQL creates a PLUG entry to balance every GL journal that is out of balance. A plug entry does not actually identify which GL entries were correct/incorrect, it merely locates any transactions … text/html 2019-02-05T11:21:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_plug_all_journal_out_of_balance_entries?rev=1549383691&do=diff Explanation of SQL This SQL creates a PLUG entry to balance every GL journal that is out of balance. A plug entry does not actually identify which GL entries were correct/incorrect, it merely locates any transactions that are out of balance and creates an adjusting entry using the PLUG account (i.e. An account you create, such as Suspense) which will bring the transaction back in balance. text/html 2019-08-09T17:11:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_queries_to_identify_problems?rev=1565385087&do=diff Control SQL Queries to Identify Problems This section is to record queries that might be useful to find, analyze, and fix potential errors in the database. Account Reconciliation Queries * Control SQL - Query to Breakdown Reconciliation Entries * Control SQL - Queries to Search for Reconciliation Problems Artwork Approval Queries * Control SQL - Move all Open Artwork Groups to Produced Credit Card Processing Queries text/html 2019-02-05T11:39:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_queries_to_search_for_reconciliation_problems?rev=1549384788&do=diff Explanation of SQL These queries are used to identify payments that are not included in the Reconciliation but should be. Risk of Data Corruption if Run Improperly High. If you use the fix queries below, data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL text/html 2019-01-27T11:29:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_query_for_evaluation_days_left_on_sql?rev=1548606546&do=diff Explanation of SQL A few of our customers are on a Evaluation version of SQL server, this query will allow you to see how many days left that SQL server has before the Evaluation version Expires. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-02-05T11:40:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_query_to_breakdown_reconciliation_entries?rev=1549384827&do=diff Explanation of SQL This SQL gives a comparison of the Reconciliation entries (in the Journal) with all of the GL entries that were reconciled by it. It also gives grand totals of the two different approaches, which should match. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:29:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_query_to_determine_oob_dataset_version?rev=1548606546&do=diff Explanation of SQL This query will let you know which OOB Dataset is currently being used. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL SELECT Formula FROM StoreConstant text/html 2019-01-27T11:29:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_query_to_fix_gl_entries_without_depositjournalid?rev=1548606546&do=diff Explanation of SQL A bug existed in an earlier version of Control 4.5 (fixed around March 2011) where the DepositJournalID was not recorded in the GL on overpayments. However, since the Payment record is known (the JournalID), this information can be retrieved from there. text/html 2019-01-27T11:29:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_recently_modified_records?rev=1548606547&do=diff Explanation of SQL This query will pull a list of all records modified recently. It will return the TableName, ID, ClassTypeID, ModifiedByUser, ModifiedByComputer, and ModifiedDate of the records modified recently. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:29:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_reclassify_historic_inventory_adjustments_to_the_parts_expense_account?rev=1548606547&do=diff =Explanation of SQL= Prior to 2011, Adjustments made to inventory were posted to the system GL Account called (appropriately) Inventory Adjustments. It is thought more desirable to have those expenses charged to the material's expense account, and so that switch was made in Control 4.5 in late 2010. text/html 2019-01-27T11:29:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_reinstall_sql_bridge?rev=1548606547&do=diff Explanation It may be necessary to reinstall SQL Bridge to clear up an error within the SQL Bridge Assembly. There are 3 ways to reinstall SQL Bridge. * #x-Restart the SSLIP * #x-Reinstall SQL Bridge using the SSLIP (without restarting) * #x-Reinstall the existing SQL Bridge Assembly in SQL Restart the SSLIP Every time the SSLIP starts, it will locate the SQLBridge.dll file and install it into the Control SQL Server database. text/html 2019-02-05T11:33:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_resequence_the_gl_table?rev=1549384410&do=diff Explanation of SQL This Query is use resequence the IDs in the GL table. It should only be necessary if the GL table has some corruption and ends up with duplicate IDs. Risk of Data Corruption if Run Improperly High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL text/html 2019-01-27T11:29:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_shipment_items?rev=1548606548&do=diff Explanation of SQL This query converts the XML of a shipment's line items into a table. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL Replace the ID in the second line with the ID of the Shipment you are querying. text/html 2019-01-27T11:29:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_shows_amounts_from_undeposited_funds_by_division_for_each_deposit?rev=1548606548&do=diff Explanation of SQL This SQL provides a listing of the deposits made, what source (undeposited funds account) they came from, and a breakdown of the amounts for up to 3 divisions. To make this work you will need to correct the division ID in the 2nd and 3rd query to match your divisions. text/html 2019-01-27T11:29:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_shows_payments_that_went_into_each_deposit?rev=1548606549&do=diff Explanation of SQL This SQL provides a table of each deposit made in Control and all of the payments that went into them. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. SQL text/html 2019-01-27T11:29:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_sql_server_expensive_queries?rev=1548606549&do=diff Explanation of SQL This queries will show you the most expensive queries that were recently executed. There are four of options to change the output: * @ResultCount -- Number of Records to be Retrieved in Int * @Database_Name -- Database Name for which the Expense queries needs to be Retrieved in Varchar text/html 2019-01-27T11:29:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_sql_server_foreign_keys?rev=1548606550&do=diff Explanation of SQL This query will list all of the foreign keys for a given table in a SQL Server database. The @TableName variable is used to set the table name to list the foreign keys. The foreign keys where the given table is the parent table will be sorted at the top of the list, sorted by the referenced table's name. All of the tables where the given table is the reference table will follow sorted by the parent table's name. text/html 2019-01-27T11:29:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_sql_server_primary_keys?rev=1548606550&do=diff Explanation of SQL This query will list all of the tables in a SQL Server database and list the Primary Keys on each table. If a table does not have any primary keys, it will appear at the top of the list with NULL in the column list. Risk of Data Corruption if Run Improperly text/html 2019-01-27T11:29:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_sql_server_processes?rev=1548606551&do=diff Explanation of SQL This query will show a list of the SQL Processes. It is the list that will appear in the Activity Monitor's Processes section. If you need to filter the list by a specific database, you can remove the comment from the where clause. text/html 2019-01-27T11:29:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_sql_server_table_indexes?rev=1548606551&do=diff Explanation of SQL These two queries may be helpful when troubleshooting systems that are running slower than they should. They will give a list of the table indexes on a dataset to help determine if any indexes are missing. Risk of Data Corruption if Run Improperly text/html 2019-02-05T11:29:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_vendor_credit_balance_integrity_check?rev=1549384145&do=diff Control SQL - Vendor Credit Balance Explanation of SQL This query compares the GL record of all Vendor Credit Balances with the record in the Vendor (account table). Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2019-08-21T17:29:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_version_history?rev=1566422966&do=diff Explanation of SQL This query will show the version history of Control based on the user login records. There are 3 columns returned: * FirstLogin - The first login record for the version of Control. * LastLogin - The last login record for the version of Control. text/html 2019-02-05T11:30:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_-_wip_and_built_integrity_check?rev=1549384253&do=diff Explanation of SQL This SQL compares the WIP and Built totals in the order (TransHeader) table with the balance in the GL. Note: If the user has the option to not track WIP and Built in the GL selected, all orders in WIP and Built will show up on this report. text/html 2019-01-27T11:29:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_server_configuration?rev=1548606553&do=diff How-To's * control_-_sql_server_maintenance_procedures * control_-_backing_up_the_database_in_sql * control_-_automating_backups_in_sql_express * control_-_how_to_determine_the_size_of_each_sql_database_table * how_to_-_view_and_disable_sql_agent_jobs_with_tsql * SQL Query to rename a sql server instan Troubleshooting * access_denied_when_attempting_to_log_into_sql_management_studio FAQ's * can_i_use_a_vm_virtual_machine_to_host_sql_server * What are the preferred configur… text/html 2019-01-27T11:29:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_sql_server_maintenance_procedures?rev=1548606553&do=diff How-To's * control_-_sql_server_maintenance_procedures * sql_server_-_dbcc_checkdb text/html 2019-01-27T11:29:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_startup_options_-_logactions?rev=1548606553&do=diff Explanation When a user is having issues in Control, sometimes it is helpful to have a log of the actions executed by a users Control session. This is possible using the control:startup_options called “LogActions” or “SaveActionsOnError”. Add one of these options to the Control shortcut of the user experiencing problems, in cases where you would like to log the actions of all users please add this option to the Control_Options.txt file instead. text/html 2019-06-13T18:23:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_support?rev=1560464634&do=diff Control Issues Index This page is the master “index” of WIKI articles for Control. The information is arranged in several formats. You may navigate using the Table of Contents on the right, or by typing Control-F and searching for specific text. text/html 2019-01-27T11:29:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_unable_to_open?rev=1548606554&do=diff Error Message Double clicking on the Control shortcut and nothing is happening. Explanation of Error When you run Control, one of the first thing that it does is look for other copies of Control already running. If so, it sends a message for the copy of Control to open a new login window and then the new copy terminates. text/html 2019-01-27T11:29:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/control_windows_issues?rev=1548606554&do=diff How-To's How Do I's Questions * control_question_-_what_versions_of_windows_are_supported text/html 2019-01-27T11:29:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/correcttransdetailshippingaddressid?rev=1548606557&do=diff Explanation of SQL Sets the ShippingAddressID in the TransDetail table to the correct ID using the ShippingAddressLinkID. This query is automatically ran in versions 04.50.1012.1701 and later during an update for the TransDetail table (Table version 44). text/html 2019-01-27T11:29:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/could_not_find_installable_isam?rev=1548606557&do=diff Explanation Caused by the MS Jet Engine being removed Resolution * Download the Jet40sp8_9xnt.exe from the FTP (Misc folder) * Double click and install text/html 2019-01-27T11:29:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/credit_card_processing_set-up?rev=1548606557&do=diff Users with the SMS credit card processing module can process credit cards online without need for terminals. This document discusses the steps to set up SMS this processing. Specifications for USB Magnetic Card Swipes can be purchased from Cyrious or elsewhere in order to capture the magnetic track data (and obtain more favorable rates), though this is not required in order to use the module. text/html 2019-01-27T11:29:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_130_error?rev=1548606557&do=diff Explanation This error message occurs when trying to save a report as a PDF or other document type file and the path is not valid Resolution * Open the offending report to print * In the Report Criteria, click the Show Details button under Save text/html 2019-01-27T11:29:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_507_pestartprint_error?rev=1548606558&do=diff Explanation This is a Crystal error caused by an invalid path Resolution 1 * Open an Invoice to print * Click the Show Details below the Save * Click the Browse button * if it remaps from a local path to the universal path, click the Save button to test - if it works, you are done text/html 2019-01-27T11:29:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_534_error?rev=1548606558&do=diff Explanation This error can appear if the installation of Crystal has become corrupted, isn't installed, the database is corrupt, or is installed to multiple locations on your system. Resolution 1 * Re-install the Crystal 8.5 DLL files. Resolution 2 text/html 2019-01-27T11:29:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_error_154_invalid_printer_selected?rev=1548606558&do=diff Resolution 1 * On the computer where you are getting the error, shut down Cyrious * Deleted all temp files in Windows Temp folder * Test - this should work Resolution 2 * On the computer where you are getting the error, select the report that gets the error text/html 2019-01-27T11:29:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_error_507_invalid_file_name._execute_pestartprintjob?rev=1548606559&do=diff Explanation This is caused by an invalid path where you are trying to save the report. This can be caused by your computer may not have access to a mapped drive or is trying to access a local path for a different computer. Work Around * Click the text/html 2019-01-27T11:29:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_errors?rev=1548606559&do=diff * invalid_operation_error * crystal_534_error * Crystal 507 error * Can not install Crystal Reports, error 1327: Invalid drive text/html 2019-01-27T11:29:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_related_problems?rev=1548606559&do=diff Common Crystal related printing/email problems * crystal_reports_driver_installation * crystal_534_error * invalid_operation_error * unable_to_preview_report_xxxx._logon_failed._details_database_vendor_code_556_crystal_report_report_file_path_to_report_file * crystal_130_error * crystal_error_154_invalid_printer_selected * Crystal Error 507 Invalid file name. Execute * windows_64bit_pestartprint_error * crystal_reports_bad_image_error text/html 2019-01-27T11:29:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_report_ignores_printer_setting?rev=1548606559&do=diff General Reports generated in Control by default should use the local system's printer settings to determine which print mode will be used. For example, if your printer is set to print all documents in black and white then when printing a report from Control, we would expect the report to print in black and white. text/html 2019-01-27T11:29:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_reports_bad_image_error?rev=1548606560&do=diff Explanation At times the installation for Crystal Reports may become corrupt for various reasons. The error shown above is an example of this occurring. Error text: craxdrt.dll is either not designed to run on Windows or it contains an error. text/html 2019-01-27T11:29:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_reports_driver_installation?rev=1548606566&do=diff Crystal Reports is the primary reporting engine for Cyrious SMS and Control. Each client must have the Crystal Report DLLs installed in order to properly print or preview reports. Crystal Drivers Installation Critical Set-Up Information Crystal drivers must be installed on the boot drive Windows\System32 or Windows\SysWOW64 text/html 2019-01-27T11:29:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/crystal_reports_keeping_sql_connections?rev=1548606566&do=diff Question How do I prevent Crystal reports from keeping an open connection to SQL Sever after closing the report in Control? The connections are closed only after closing Control. Answer To force Crystal reports to close connections to SQL Server in Control: text/html 2019-01-27T11:29:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/ctrlservr.exe_not_in_the_pos?rev=1548606566&do=diff Explanation Resolution * Go to Mgmt>Set-Up>User Options * Select the Network Options * Select Network Client text/html 2019-01-27T11:29:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyclic_redundancy_check_crc_error?rev=1548606566&do=diff Explanation This is caused by a faulty Hard Drive (HD) or sector on the HD Resolution Customer will have to get a local tech to resolve this issue. If the error occurs during the backup of the data, inform the customer they may have to get the tech to recover the data as well text/html 2019-01-27T11:29:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyrious_acts_like_it_is_backing_up_but_nothing_in_the_folder?rev=1548606567&do=diff Explanation This is a bug in a specific version of 8.6. If you check the SSLIP error log, you will see an error that states - Can't Backup File name is blank Resolution * Download the current 8.6 upgrade * Install Cyrious on the server * Test text/html 2019-01-27T11:29:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyrious_freezes_at_the_loading_reports_menu?rev=1548606567&do=diff Explanation This is caused by missing Data or the BDE locked up. Resolution 1 * Open the Data folder * Sort by View by Details * Click on column header Name to sort alphabetically * You will probably find the Account Codes Database missing - possibly the Adjustment table as well text/html 2019-01-27T11:29:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyrious_freezing_at_communicating_with_server?rev=1548606567&do=diff Explanation This is usually caused by someone trying to backup the Data folder and dragging and dropping the Data folder, or Cutting and Copying the Data folder. Due to a limitation in Windows OS, dragging and dropping large files will drop data. text/html 2019-01-27T11:29:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyrious_printing_an_extra_page_for_invoices_and_or_estimates?rev=1548606568&do=diff Explanation When Cyrious prints additional pages for Invoices/Estimates and the additional page is blank except the header and possibly the footer, it is usually caused by a field that has additional carriage returns. They are usually located in the notes fields; however, can be a global issue. text/html 2019-01-27T11:29:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/cyrious_support_and_sales_tax?rev=1548606568&do=diff Question Why am I being charged sales tax on software support? Answer There are several states where we are required to collect sales tax on subscriptions and some support purchases as well as software purchases. * Louisiana - We are required to collect sales tax on software sales, and on some subscription services; more information can be found text/html 2019-01-27T11:29:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/data.config_file?rev=1548606568&do=diff Explanation The standalone SSLIPs will use a new file to store their connection information. The file is named “Data.Config”, and is written in the same folder in which the SSLIP is installed when the SSLIP is run for the first time. *THIS FILE IS NOT NEEDED IN CHAPI SSLIPS text/html 2019-01-27T11:29:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/database_connection_failed_..._not_a_valid_path?rev=1548606569&do=diff Explanation This is caused by a number of things, invalid path/filename in the SSLIP, the Cyrious folder is not shared correctly, Anti-Virus blocking the connection, Firewall blocking the connection. Resolution 1 * Disable the Anti-Virus on the server and/or client machine text/html 2019-01-27T11:29:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/database_group_not_found?rev=1548606569&do=diff Explanation This error means that the Standard Group 'SMS' is missing from the SSLIP. This usually seen in customers that have multiple databases; however, can occur on new installations. Resolution 1 * Connect to the server * Open the SSLIP * text/html 2019-01-27T11:29:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/database_is_read-only?rev=1548606569&do=diff Explanation Occasionally when upgrading to control version 4.4 or 4.5, you will receive this message during initialization. You may use task manager to end the “Control” process as soon as you see this message, because the install will fail. Resolution text/html 2019-01-27T11:29:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/dbrebuild?rev=1548606570&do=diff DBRebuild How To: How to perform a Database Rebuild to repair corruption in your tables, table indexes, and resolve various error messages you may be receiving. Common Errors Resolved By Database Rebuild * Index out of Date * Corrupt Table Other Than Header text/html 2019-01-27T11:29:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/dbrebuild_opens_but_shuts_down_when_verifying?rev=1548606570&do=diff Explanation This is caused by a corrupted table, usually the Account Code table Resolution * Open the DBBrowser, to see what table pops up as corrupted * Replace that table with the same table from the DemoData3 file * Test * If a table other than the AccountCode, you may have to run a query to insert the data (use the appropriate table name and location of the original data text/html 2019-01-27T11:29:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/declaration_has_not_been_closed_line_1?rev=1548606570&do=diff Explanation Resolution * If not global, Back up Data * Open DBBrowser * Navigate to the Order Details DB * Filter by “Orderid = [orderid number]” * Scan all Memo fields (the capitalization indicates something in the memo) * Delete any corrupted data (remeber to backspace and delete repeatedly) text/html 2019-01-27T11:29:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/disable_uac_in_windows_8?rev=1548606571&do=diff Question How do I disable UAC in Windows 8? Answer To disable UAC in Windows 8 Professional: * From the Desktop, press Windows Key + R to access the RUN dialogue. Type 'GPEdit.msc' into the form and click 'OK'. * In the Local Group Policy Editor window edit the Computer Configuration by selecting the follwing items in order: text/html 2019-01-27T11:29:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/does_cyrious_support_emv_transactions?rev=1548606571&do=diff Question Does Cyrious SMS or Control support EMV “chip card technology” transactions? Answer Currently, no. The existing credit card processing interface within Cyrious SMS and Cyrious Control does not currently support EMV transactions. text/html 2019-01-27T11:29:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/double_payment_displayed?rev=1548606571&do=diff Explanation This may be due to the way the click of the mouse interacts with Windows and our program Resolution * Check order to see where payments are duplicated * Open DBBrowser * Filter by OrderID=xxxx in the Adjustment Database * Modify Filter to text/html 2019-01-27T11:29:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/email_set-up?rev=1548606571&do=diff CYRIOUS SMS - Options for setting up Cyrious to Email Note: This must be done on all computers that have Cyrious Setting up Cyrious to use Outlook * Navigate in Cyrious to Mgmt, Set-Up, click on User Options. * Click on the Email Options tab. text/html 2019-01-27T11:29:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/email_set-ups?rev=1548606572&do=diff How to Set-Up Emailing in Cyrious setting_up_email_in_cyrious setting_up_email_based_on_info_from_another_computer_with_email_set-up_in_cyrious text/html 2019-01-27T11:29:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/emv_information?rev=1548606572&do=diff This Page Under Construction ... Chip Cards (EMV) Explained Most major credit card companies have begun releasing Credit|Debit cards (Cards) with an embedded “chip”. This chip cannot be easily replicated and provides much greater security than the magnetic stripe used on Cards for the past decades. This chip technology is referred to as EMV. In addition to new Cards, adoption of EMV pushes merchants (like you) use sophisticated new Card readers. text/html 2019-01-27T11:29:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/entered_by_grayed_out_in_multipayments?rev=1548606572&do=diff Resolution * Ensure that the customer has multiple orders with balances * If they do, View the Customer * Select the Financial tab * Check the “Credit Account Open” checkbox text/html 2019-01-27T11:29:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_-_floating_point_overflow?rev=1548606573&do=diff Explanation Procedure/Walk-Through * Check to see if the customer is using an HP2600n * If so, they need to choose a different computer * You can give them the following link to explain the problem (HP2600n has issues with Delphi, the language we use) text/html 2019-01-27T11:29:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_-_not_authorized_for_this_application?rev=1548606573&do=diff Explanation Resolution for Client machine * Check the key file and ensure it has a program set (SMS or Control) * Check all registry settings to make sure they are pointing to the proper server. * Using the Tech Utility, reinitialize dongle on the server text/html 2019-01-27T11:29:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_-_sslip_needs_to_close_sorry_for_any_inconvience?rev=1548606573&do=diff Explanation Resolution * Navigate to Programs>StartUp * Check to see if there are 2 copies of the SSLIP shortcut in the Startup folder * If so, delete one copy text/html 2019-01-27T11:29:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_130_-_failed_to_retrieve_error_message_from_print_engine?rev=1548606574&do=diff Explanation This is caused by a corrupted report(s). On occassions, the report will work on one computer, but not another. Resolution 1 * Get a copy of the correct SMSSystemConfig.mdb file from I:\Implementation\SMS\SMS v8.6 and the correct store type text/html 2019-01-27T11:29:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_10048_in_function_bind_address_already_in_use?rev=1548606573&do=diff Explanation Most computers only have one network connection, yet lots of programs (including the SSLIP, Control, and SMS) need to communicate on it. Each program running uses a “Port” to identify itself and communication over the network is targetted not only to the IP (computer address) but also the port. text/html 2019-01-27T11:29:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_generating_product_layout?rev=1548606574&do=diff Error Message Error text: Error generating product layout. Evaluation Error: Only similar data types can be compared. Explanation of Error The Product Layout is re-calculated when an order or estimate is edited. In this case, there are variables being used in the products that can not be evaluated because the data types don't match the argument in the CFL code. text/html 2019-01-27T11:29:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_loading_collection_reportmenutemplates_operation_must_use_an_updateable_query?rev=1548606574&do=diff Explanation This error is typically encountered when your script attempts to perform an UPDATE or some other action that alters the information in the database. This error occurs because ADO is unable to write to the database for one of the following reasons. text/html 2019-01-27T11:29:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_not_enough_server_storage_is_available_to_process_this_command?rev=1548606575&do=diff Explanation Resolution * Open the Registry * Navigate to HKEY_LOCAL_MACHINE>SYSTEM>CurrentControlSet>Services>LanmanServer>Parameters * Check DWOORD IRPStackSize * If IRPStackSize Dword does not exsist create it and make it a value of 16 * text/html 2019-01-27T11:29:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/error_sending_email_socket_error_10061_connection_refused?rev=1548606575&do=diff Error sending email: Socket Error # 10061 Connection refused. Explanation The connection to the mail server has been refused. This may be caused by incorrect data being entered in the email options. Possible Resolution(s) 1. If customer is a franchise (Fastsigns, etc) have them contact the corporate office to verify that the email settings for the corporate mail server are correct, and make the necessary changes. text/html 2019-01-27T11:29:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/export_out_of_balance_but_not_the_gl?rev=1548606575&do=diff Explanation Resolution When exporting the Accounting Data, it comes up Out of Balance and you have run the GLOB, with no results. Do the following * Open the DBBrowser * Navigate to the GL Database * Filter by “AccountCode = 0” * The result info retrieved, needs an account code of 4001, 4002, or 4003 text/html 2019-01-27T11:29:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/exporting_to_quickbooks_data_out_of_balance_but_dar_in_balance?rev=1548606576&do=diff For use when all other OOB queries can not findd the issue Resolution * Check subaccount codes for payments in the GL Database match the subaccount codes in Payment Methods Database text/html 2019-01-27T11:29:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/external_exception_c0000006?rev=1548606576&do=diff Explanation Customer receives error message including the string “External Exception: C0000006” Resolution 1 * Ask customer if it is happening on multiple computers * If yes, check the Recommended Network Troubleshooting#toc3 settings on the server - especially the NIC Hibernation text/html 2019-01-27T11:29:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/external_exception_error_c00000006?rev=1548606576&do=diff Explanation Resolution * Ask customer if it is happening on multiple computers * If yes, check the Power Management settings on the server - especially the NIC Hibernation * Can check on the client machines as well * If continues to occur, explain to customer this error is a connectivity error text/html 2019-01-27T11:29:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/external_exception_when_accessing_production_terminal?rev=1548606576&do=diff Explanation Resolution text/html 2019-01-27T11:29:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/external_exception_when_printing?rev=1548606577&do=diff Error Message Unable to Preview report “%Report Name Here%”. External exception E06D7363 Crystal Report (System) System Report ID: (xxxx,17000) Explanation of Error Although the error looks to be generated by Control, the error is actually being returned by Crystal Reports. This error is returned when the report encounters a problem either querying the data, compiling the results, or performing the coded tasks within the report. In some cases the problem may be the actual report, however… text/html 2019-01-27T11:29:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/file_gcr_not_found?rev=1548606577&do=diff Explanation Resolution * Attempt to print that report again but wait at the print dialogue screen. * Press CTRL-S on the keyboard to bring up the Report Selector. * Write down the template name that's being used for the report. * Open the POS directory and go into the Custom Reports folder. text/html 2019-01-27T11:29:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/fonts_were_changed_making_cyrious_labels_too_large_or_small?rev=1548606578&do=diff Explanation The Fonts have changed in the system and either making everything bigger or smaller then usual and printouts come out incorrectly. Cyrious has no font control, the program uses the Default Window's font for use with the system. Resolution text/html 2019-01-27T11:29:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_cyrious_program_information?rev=1548606578&do=diff Overview This page is dedicated to information that is not specific to a particular Cyrious product such as Control or SMS. Cyrious Program Information * what_windows_fonts_does_cyrious_use_for_the_program_interface * What Anti-Virus applications are have known issues Cyrious? How Do I * how_do_i_post_a_payment_for_an_order_that_was_a_write-off_to_bad_debt Credit Card Processing * Capital Q provides integrated credit card processing for SMS and Control in the U.S. * NXGen provid… text/html 2019-01-27T11:29:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_data_backups?rev=1548606578&do=diff Explanation Backing up your data is critical. It is easily one of the most important tasks that you can do, however completing this task and making sure it is happening on a consistent basis is often taken lightly. While the Cyrious offers integrated backup capability, the user is still responsible for configuring the backup, making sure copies of the backup are stored on more than 1 computer, offsite, etc. text/html 2019-01-27T11:29:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_data_conversion?rev=1548606579&do=diff Conversion From Activity POS (APOS) * Conversion - Estimates and Orders Missing Customer Information Formatting Excel Data * split_multiple_lines_of_text_into_seperate_columns text/html 2019-01-27T11:29:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_out_of_balance_issue?rev=1548606579&do=diff Explanation Some of these issues are caused by some sort of corruption when writing to the GL. Others are caused by a bug in SMS when doing order discounts Resolution 1 * After backing up the database, open the DBBrowser * Run Sql #1 * Click on the last record button text/html 2019-01-27T11:29:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_outlook_set-up?rev=1548606579&do=diff General Outlook Set-Up * setting_up_outlook_to_work_with_cyrious_-_without_asking_permission_to_use_every_time text/html 2019-01-27T11:29:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_windows_information?rev=1548606579&do=diff  How-To's * xxx How Do I's * how_do_i_..._connect_to_terminal_services_with_a_macintosh text/html 2019-06-13T16:35:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/general_windows_troubleshooting?rev=1560458159&do=diff Basic Network Troubleshooting * Recommended Network Troubleshooting Common Network Troubleshooting Problems * Logon Failure - The user has not been granted the requested logon type at this computer * Disable UAC in Windows 8 * Networking - Unable to ping server from client computer * Networking - Allowing PING through the firewall in Windows 7 Common Windows Problems * Error - Not enough server storage is available to process this command * Windows How To * Cyclic Redundancy… text/html 2019-01-27T11:29:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/glaccount_6080?rev=1548606580&do=diff Explanation Call Cyrious Software Technical Support. This error indicates an account being classified incorrectly, and will require database modification to resolve. text/html 2019-01-27T11:29:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/gotomeeting_-_how_to_record_a_hosted_meeting?rev=1548606580&do=diff Overview GoToMeeting can be utilized to record the audio and video portion of a session for review later. Configuring GoToMeeting Recording * Open GoToMeeting * Click on File > Preferences. * Locate the section Recording * Under the Audio section select the option text/html 2019-01-27T11:29:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/hide_the_time_clock_to_prevent_users_from_changing_the_time_on_their_computers?rev=1548606581&do=diff Explanation Periodic or repeated dates being off because someone accidentially changed the date on the computer's clock Steps * Right-click on an open area on the Taskbar and select “Properties”. * Uncheck the “Show clock” checkbox. text/html 2019-01-27T11:29:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/historical_ar_balance_by_order_as_of_a_specified_date?rev=1548606581&do=diff Explanation of SQL This SQL statement will pull a list of all records grouped by Order # in the GL database that have a balance in ARs. Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. text/html 2020-03-26T12:43:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/home?rev=1585241025&do=diff Cyrious Technical Support WIKI Welcome to the Cyrious Technical Support WIKI. The purpose of this WIKI is to serve as a living knowledgebase of information. Support Areas * Main SMS Support * Main Control Support * Main SSLIP Support * Utilities Support * General Windows Troubleshooting * General Windows Information * General Cyrious Program Information * General Data Backups * General Data Conversion * General Outlook Set-up Getting Support text/html 2019-01-27T11:30:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how-to_change_the_taxes_label_displayed_on_reports?rev=1548606607&do=diff Question How do I change the Taxes Label Displayed on Reports? Such as changing it so Cyrious SMS can handle requirements to show GST, PST, HST, VAT, or other tax requirements on estimate and invoices? Answer Although these recent changes were made to support a tax change in Canada the steps may apply to your needs as well. For clarifiaction, beginning in July of 2010 Canadian users are switching from GST and PST tax rates to a single HST tax rate. For detailed information on this tax change … text/html 2019-01-27T11:30:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how-to_change_your_sales_tax_rates_in_sms?rev=1548606608&do=diff When sales taxes change it is important that you proactively update your existing orders for the new tax rates. If you fail to do this, tax reporting will be very arduous for a few months after the change. This article covers the guidance Cyrious provided for tax changes that several Canadian provinces under went in 2010. The approach, however, can be generalized to cover all sales tax rate changes. text/html 2019-01-27T11:30:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how-to_refund_a_payment_and_export_into_quickbooks?rev=1548606608&do=diff [[toc|toc]] Concept ---------- Through the course of business you're likely to encounter a case or two where you received a check from a client and through the course of business you need to refund them. If you are using an accounting system such as QuickBooks recording this refund check and ultimate reduction of your bank account balance can be a little challenging. During this How-To we will look at how to best handle these cases so that everything is recorded properly in SMS and QuickBooks… text/html 2019-01-27T11:29:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i....handle_a_nsf_check?rev=1548606584&do=diff Question How do I Settle the Batch in Control? Answer Add “Settling the Batch” to your daily closeout routine. * Until you settle your credit card transactions, the transaction is not finalized and the payment won't be sent to your bank. Therefore, it is important that you settle the batch every day. The easiest way to do this is to add it into the Daily Closeout procedure. text/html 2019-01-27T11:29:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i..._issue_a_customer_credit?rev=1548606583&do=diff Explanation Method 1 * Click on Pay-Status and verify that you have the proper company and or order selected * You may also open the order in question and click on the Payment button on the right. * Again verify that you have selected the proper company and or order text/html 2019-01-27T11:29:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_..._connect_to_terminal_services_with_a_macintosh?rev=1548606581&do=diff Question How do I connect my mac to a windows server so I can access programs such as Control? Answer In order for a location with all Macintosh systems to utilize the Cyrious Control software package, the following technical requirements must be met. text/html 2019-01-27T11:29:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_..._refund_a_payment?rev=1548606582&do=diff Question How do I refund a payment in Control? Answer To refund a payment on a order: * Open the Order Explorer by clicking on Explorer | Explore Orders * Locate the Order with the payment you want to refund. * Right-click on the order. On the pop-up menu click on text/html 2019-01-27T11:29:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_..._refund_or_void_a_processed_credit_card_payment_that_fails_to_refund?rev=1548606582&do=diff Question How Do I ... Refund or Void a Processed Credit Card Payment that Fails to Refund? Description The integrated credit card processing module within Control offers users the ability to process credit card transactions directly in the system. At times you may be requested by your client to refund or void a processed payment, either due to a return, incorrect payment amount, customer states the deposit was posted twice, etc. Control should handle these refunds and voids automatically in… text/html 2019-01-27T11:29:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_duplicate_the_pricing_from_another_location?rev=1548606582&do=diff Steps to export Pricing Data * Open Cyrious at the store where you want to copy the pricing * Click on File in the menu bar * Choose Export then * Choose Product Data * Follow the on-screen instructions to create a product file * Take this file to the other location. You may email it or copy it on a disk. text/html 2019-01-27T11:29:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_post_a_payment_for_an_order_that_was_a_write-off_to_bad_debt?rev=1548606583&do=diff Question How do I post a payment for an order that was a write-off to bad debt? Answer Once an order has been written-off it, that write-off amount can not be removed or voided as that transaction was considered non-collectible. To recognize the payment from that customer you should do the following: text/html 2019-01-27T11:29:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_do_i_recover_a_database_when_the_ldf_log_file_is_lost_or_corrupted?rev=1548606583&do=diff Issue A sql database generally has at least two files, a .mdf (data) file and a .ldf (log) file. Databases can have more than 1 of each of these files but for Control there are always two files unless a user manually created some additional ones themselves. At times when dealing with corruption of databases or possibly a mishap with transferring the physical database files you end up losing the .ldf (log) file for the database and are now left with a database you can not attach or utilize in an… text/html 2019-07-16T12:51:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to?rev=1563295879&do=diff How To for Support Set-Up * Upgrade SMS Silver or Gold Level SSLIP to Unlimited Users * Hide the Time Clock to Prevent Users from Changing the Time on Their Computers * Set-up Emails * Setup Database Backup * Reporting Setup * How to setup Quickbooks to Accept Cyrious Export * How to Create an invisible or Child Line Item * How to get the Child Checkbox Back * How to Start a Marketing Plan Using the Cyrious Marketing Program * How to Utilize Dispositions in SMS * How to S… text/html 2019-01-27T11:29:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_-_change_a_report_export_file_path?rev=1548606584&do=diff Explanation This is a general how to guide for setting desired paths for your exports Select Set up>Reporting Set up Select the menu associated with the location you choose to run the report, ie Quick Reports>GL Exports for Quickbooks. Then drill down to your desired report. text/html 2019-01-27T11:29:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_-_kill_an_application_or_process_without_task_manager?rev=1548606584&do=diff Question How do I kill a process or application without using Task Manager? Answer At times you may not be able to access Task Manager as it may be disabled by a group policy, spyware, etc. If you need to end a process manually then you can do so by using a few utilities through a command prompt. text/html 2019-01-27T11:29:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_-_recreate_lost_logons_in_windows?rev=1548606585&do=diff Explanation Steps * Open the registryS * Navigate to HKLM>Software>Microsoft>Windows NT>Current Version>Win Logon>SpecialAccounts>UserList * Add a DWord exactly the same name as the logon you are replacing * Set to the number 1 text/html 2019-01-27T11:29:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_-_share_cyrious_versions_8_and_up?rev=1548606585&do=diff Explanation This is required when initially setting up Cyrious on a new server. It may also be required when updating mdb files. Initial Steps (NOTE: If Windows 7 or above, you must first Open the Tools and go to Folder Options and select the View tab. Then uncheck Use Sharing Wizard) text/html 2019-01-27T11:29:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_-_view_and_disable_sql_agent_jobs_with_tsql?rev=1548606586&do=diff Question How do I list of all SQL Agent Jobs running on a server. You can use SSMS, however the script below will show you the same information using T-SQL. There is also a script to disable the job within each job record. Just copy and paste that record to disable the job. text/html 2019-01-27T11:29:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_change_regional_options?rev=1548606586&do=diff Explanation Regional Options are hidden as most people do not want or need to access this area. It is where settings for other country's settings that can be adjusted are access. It is also where some advanced settings are accessed. Steps to access Regional settings text/html 2019-01-27T11:29:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_correct_the_balance_on_an_order_that_was_paid_in_full_but_still_showing_money_due?rev=1548606586&do=diff Explanation This is when Cyrious fails to zero out the BalanceOutstanding in the Order Database Steps * NM into customer's machine * Open SMS and run Payments report for particular time frame * Make sure Payment shows up on Payments report text/html 2019-01-27T11:29:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_create_a_recurring_order?rev=1548606586&do=diff This page will give you instructions on how to create a recurring order in Control, and trigger it using the report feature. Concept A recurring order is an order that has been converted or saved to repeat itself in a set pattern until a defined end date (non-inclusive, see warning below). text/html 2019-01-27T11:29:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_create_an_invisible_or_child_line_item?rev=1548606587&do=diff Explanation Hidden line items, or “child items” are used to group related items within an order or estimate. The price of a child item is included in the parent items price. Steps * From within an order or estimate once an item is created, the box labeled text/html 2019-01-27T11:29:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_export_gl_data_from_cyrious?rev=1548606587&do=diff Steps * Navigate to File>Export>Export Accounting Data * Click Preview tab to ensure data is in balance * Check QB or appropriate format radio button * Click save * Note where the file is being saved to locate for importing * Click yes to Mark as Exported text/html 2019-01-27T11:29:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_get_the_child_checkbox_back?rev=1548606587&do=diff Explanation Resolution * Go to View menu * Unclick Advanced Screens * Open New Order/New Estimate screen * Notice the “Child” checkbox is back text/html 2019-01-27T11:29:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_import_my_accounting_data_to_quickbooks_simply_accounting_or_other_accounting_software?rev=1548606588&do=diff Steps * For detailed information on setting up the accounting export, open the Cyrious Help File by clicking on Help * Then Help Contents * Select the Accounting Export topic from the menu. Note: If you have any additional questions, please contact Cyrious Software Technical Support. text/html 2019-01-27T11:29:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_import_product_or_company_data?rev=1548606588&do=diff Explanation This is used to import a list of Companies, or Products directly into Cyrious dataset. The data must be either tab delimited or comma delimited to successfully complete the following steps. Steps * Get everyone out of Cyrious everywhere except the server text/html 2019-01-27T11:29:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_make_a_customer_tax_exempt?rev=1548606588&do=diff Steps * Open the Browse window and select the customer record * Click on the edit button * On the Company Tab check the “Tax Exempt” box * Fill in the Tax Exempt Number, then click the save button Note: All future orders for this customer will be tax exempt. text/html 2019-01-27T11:29:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_make_server_2012_auto_login_admin_account?rev=1548606588&do=diff Concept Many times we run into problems when servers automatically restarts from a windows update or a server reboot after a power outage, and then no one can get into Control because no one has logged into the server to get the SSLIP started. I found an easy way to set this up for those of you who do not know how to do it or for those of you who just want to know for future reference. In some cases we don't have to worry about this because it's already done by the companies who have there own… text/html 2019-01-27T11:29:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_manually_close_day_in_sms?rev=1548606589&do=diff Steps * NM into customer's server * Open up DBBrowser * Select the Closeout Database * Click directional arrows to scroll to the end of entries * Click plus sign (+) to add a new line * Type in date and time for Daily Closeout, tab to Store record, tab to Type field and enter 'D' for Daily, 'M' for Monthly, 'Y' for Yearly, 'X' for Export or 'R' for Royalty text/html 2019-01-27T11:29:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_manually_close_the_export_in_sms?rev=1548606589&do=diff Steps * Open Cyrious * Navigate to File>Export>Export GL Data * Select Chang Export Dates button * Click the Date Period Drop Down button (Since Last Data Export) * Select For Custom Time Period * Select the Export Dates Radio button on the right text/html 2019-01-27T11:29:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_recreate_administrator_user_or_other_user?rev=1548606589&do=diff Explanation Steps * Click Start * Click Run * Type Regedit * Open the following folder: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\SpecialAccounts\UserLis t * Right click in the open space to the left text/html 2019-01-27T11:29:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_refund_a_payment_on_a_closed_order?rev=1548606590&do=diff Steps 1 * Go to Payment screen. * Click on Refunds button and insert the Company name you need to give the refund on * Fill in the necessary information, Amount, Reason, Issued By, and Issue Refund From (Note: Use the same method of payment as the original payment that you are refunding). text/html 2019-01-27T11:29:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_remove_closeouts?rev=1548606590&do=diff Explanation These are the steps to remove any closeout in SMS. It does not matter if it is a Day, Year, Royalty or anything else. BUT this process only removes the last closeout, you'll need to repeat the steps if you want to remove multiple closeouts even if there were multiple done on the same day. For instance, if you closed the day, the month, the year, then closed the month again afterwards on 12/31/12. Then you would need to repeat these same steps 4 times to remove the last 4 closeouts. … text/html 2019-01-27T11:29:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_remove_finance_charges_from_an_order?rev=1548606590&do=diff Steps * Open Order that has Finance Charges * Go to Pay Status screen for that Order * Go to Finance Charges button * Click on Set To Zero button * Fill in a Reason * Click on Adjust/Assess Charges button text/html 2019-01-27T11:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_remove_sales_tax_or_royalties_when_voiding_an_order_from_a_previous_month?rev=1548606591&do=diff Steps * Inform the customer that this will not mess up sales tax or Royalties * Explain that the sales tax or Royalties from that order will be deducted from the current month's sales tax or Royalties text/html 2019-01-27T11:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_save_an_entries_in_cyrious_when_the_mouse_dies?rev=1548606591&do=diff Explanation How To * Using the keyboard * To save any open items (Ctrl + S) * To close SMS, CTRL + F4, * Restart computer after replugging in new PS2 mouse * If USB mouse no need to restart computer, just Cyrious text/html 2019-01-27T11:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_customers?rev=1548606591&do=diff Companies Customer data can be added, deleted, or modified using the Customer Menu. A separate customer record is required for each billing address you wish to use. Each customer, however, can have an unlimited number of contacts. This enables order tracking for different individuals at the same company, without forgoing consolidated billing and overall customer management. text/html 2019-01-27T11:29:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_cyrious_for_credit_memos_or_credits?rev=1548606592&do=diff Steps * Navigate to Mgmt>Set-Up>View/Edit User Options on the toolbar * Click Alt-X * This will show the Regional Options * Select the Regional Options tab * Check the “Enable Credit Memos” box to be able to use Credit Memos * Unchecking it to reverts Cyrious back to using credits text/html 2019-01-27T11:29:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_documents?rev=1548606592&do=diff Explanation Document Management Every print, sign, and graphics business has to manage documents. SMS now includes integrated document management. Folders for storing all those relevant files (artwork, permits, etc.) are automatically created for each order, estimate, and customer. Those files can be accessed by all employees from the documents tab inside the order, estimate, or customer. text/html 2019-01-27T11:29:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_passwords?rev=1548606592&do=diff Explanation There are 2 different Password set-ups that can be used in Cyrious SMS. All versions older than 8.90 have only 1 Password set-up that is the same set-up in all SMS versions and described in Step 1. Step 1 * In Cyrious, navigate to text/html 2019-01-27T11:29:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_passwords_to_access_customer_credit_card_information?rev=1548606593&do=diff How To Set-up Password to View Customer Credit Card information Steps * Select Mgmt/ Personnel/ View/Edit Employee. * Use the employee listing on the left side of the screen to highlight the employee to edit. * Click the “Edit” button on the toolbar. text/html 2019-01-27T11:29:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_product_categories_-_fii?rev=1548606593&do=diff Explanation Resolution * Navigate to the Home page in Cyrious * Hit the Ctrl and F9 keys together at the same time * This will either pop-up a request for a password - we do NOT provide that, they must contact FII for that; or it will pop-up a screen with a number of widgets including View/Edit Product Categories text/html 2019-01-27T11:29:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set-up_sales_goals?rev=1548606593&do=diff Explanation Cyrious SMS allows the User to define monthly sales goals. The sales goal numbers are used on the Sales Graph and the Activity Report as an indicator of what level of sales you want to achieve for a given month. How to access Sales Goals text/html 2019-01-27T11:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_set_up_quickbooks_to_accept_cyrious_export?rev=1548606591&do=diff Explanation Open the PDF below and follow the steps for the initial set up of QuickBooks. Note:It can be used as a guide for making the adjustments to your accounts in QuickBooks to accept Cyrious' export. text/html 2019-01-27T11:29:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_setup_statement_text_in_sms?rev=1548606594&do=diff Steps * Navigate to MGMT>Setup>Setup Store Information * Go to Statement Tab * Click Edit * Modify Statement Text as necessary * Save * Test by printing Statements text/html 2019-01-27T11:29:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_start_a_marketing_plan_using_the_cyrious_marketing_program_-_examples?rev=1548606594&do=diff Explanation There are several examples available in the online help for the Marketing program. Steps * To access the online help, press the F1 key on any screen * or select Help/ Help Topics from the menu bar. text/html 2019-01-27T11:29:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_track_donations?rev=1548606594&do=diff Question Can I track the donations I make in Control? Answer Yes, Control allows for donations to be tracked as a payment method. Explanation Many companies track donations made for the year or quarter in Control for tax write-off purposes. Steps text/html 2019-01-27T11:29:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_unvoid_an_order?rev=1548606594&do=diff Question How do I un-void an order that was aaccidentally voided? Answer Unfortunately, Cyrious does not allow you to directly "unvoid" an order. This is an administrative control point and there is no work-around to "recapture" the invoice number. The only alternative is to create a new order with the same items. text/html 2019-01-27T11:29:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_utilize_dispositions_in_sms?rev=1548606595&do=diff ==Question:== Is it possible to get more detailed tracking by order in SMS other than just the WIP, Built, On Hold, Picked-Up, and Closed statuses? ==Answer:== Yes, you can get a little more detailed with the current disposition of an order by using Dispositions in Cyrious SMS. To setup Dispositions, follow the steps below. text/html 2019-01-27T11:29:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_view_sms_training_videos?rev=1548606595&do=diff Directions * Log into the Cyrious Customer website at www.cyrioussoftware.com with your username and password. * Select Training in the blue navigation toolbar and a new page will load. * Choose Wiki & Archive in the gray sub-navigation toolbar. * Click on the word text/html 2019-01-27T11:29:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_void_a_payment?rev=1548606595&do=diff Explanation Note: You cannot Void part of a payment, you can only Void whole payments! Steps for Voiding a Payment * Open Payments window. * Either choose By Order tab and type in the Order number or choose By Company and browse for the company name and hit text/html 2019-01-27T11:29:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_void_an_order_that_has_a_payment_associated_to_it?rev=1548606596&do=diff Explanation Occassionally, an order will need to be voided that has a payment on it. The steps are straight forward, but the pop-up text tends to be confusing. Decision * Determine if the customer wants a refund or have the money sit in credit to be used on another order text/html 2019-01-27T11:30:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_to_void_an_order_with_no_line_items?rev=1548606606&do=diff Explanation An order will sometimes lose it line items due to corruption, whether it is a cloned order or a converted estimates. Usually it is due to corruption in the source order. Steps: * Rebuild the database * Edit the order * Add a line item, doesn't matter what the Product is (unless you want to recover the order then readd all the missing line items and modifiers exactly as it was before) text/html 2019-01-27T11:30:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/how_you_can_tell_if_the_server_is_a_virtual_machine_or_a_physical_machine?rev=1548606607&do=diff How you can tell if your on a Virtual Machine or a Physical Machine Explanation You can't always tell if your on a Virtual Machine just by checking the network card or other hardware in Device Manager, some do not have VMWare tools installed that normally hang around in the task bar. Some VMware platforms actually will give you real hardware listings ie: NIC card Intel (R) Pro/1000 text/html 2019-01-27T11:30:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/http_error_500.19?rev=1548606609&do=diff Explanation When attempting to view Production Terminal on IIS7/Windows Server 7, you receive: “The requested page cannot be accessed because the related configuration data for the page is invalid.” Resolution The %windir%\System32\inetsrv\config\applicationHost.config file is locking configuration nodes in the Production Terminal's WebSite's web.config. text/html 2019-01-27T11:30:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/id_repair?rev=1548606609&do=diff SMS Utility: IDRepair.exe Description This utility corrects occurrences of Large (>1073741824) IDs found in the critical Cyrious SMS databases. In Cyrious large negative ID's are assigned to temporary records. At times the database engine will improperly assign that large ID to the permanent record in the database rather than the next ID in sequence. When this occurs you'll receive an error message. text/html 2019-01-27T11:30:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/identify_tax_balances_in_gl_not_matching_tax_report?rev=1548606609&do=diff Explanation of SQL This SQL generates a list of the taxable orders, taxable amounts, and tax rates from Sales in the GL from a particular timeframe. You will need to adjust the date range in both queries based on the range you are studying. The results will show you the effective tax rate for all taxable sales during that time period. text/html 2019-01-27T11:30:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/import_to_quickbooks_not_showing_up?rev=1548606609&do=diff Resolution * Connect to the computer that they export from Cyrious * Open the registry * Navigate to HKCU>Software>Cyrious Software>SMS>GLOptions * Delete the GLExportFromat DWORD * Resave an export * Test to see if it imports text/html 2019-01-27T11:30:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/incorrect_time_error?rev=1548606610&do=diff Explanation The likely problem is that the windows time service is not properly synchronizing the time of the computer with the global clocks on the internet. Resolution * To correct the problem, double click the shortcut on your desktop labeled text/html 2019-01-27T11:30:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/index_does_not_exist?rev=1548606610&do=diff Index does not exist Explanation Resolution * Open the NewData folder (If customer is running 8.91, rename the Data folder, then change the NewData folder to Data and open Cyrious so it will update the tables. Then shut down Cyrious and the SSLIP. Then rename the Data folder to NewUpdatedData and the original Data folder back to Data) text/html 2019-01-27T11:30:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/index_out_of_balance?rev=1548606610&do=diff Explanation text/html 2019-01-27T11:30:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/install_crystal_drivers?rev=1548606611&do=diff Install Crystal Drivers Things Required to Install * Use this file for all versions of Windows XP and older * * Use this file for all versions Windows after Windows 7 (32bit) * Use this file for all versions Windows after Windows 7 (64bit) text/html 2019-01-27T11:30:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/installation_in_progress?rev=1548606611&do=diff Explanation When attempting to launch Control for the first time post server install or update an error message is shown stating that an Installation is currently in progress Note: You will get basically the same message when you attempt to start the SSLIP text/html 2019-01-27T11:30:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/insufficient_disk_space?rev=1548606611&do=diff Error Message Insufficient Disk Space Explanation of Error Borland Database, the database that powers SMS, was created back when the maximum size of a Hard Drive was 4GB. With the advent of newer larger Hard Drives, Borland still looks at the storage space in multiples of 4GB. text/html 2019-01-27T11:30:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_file?rev=1548606611&do=diff Explanation This error is caused by the path were the reports are store being changed. Resolution 1 Copy the path were the Marketing report should be saved (preferrably the universal path) 2 It is possible to change the path by going to Mgmt>Set-Up>Machine Set-Up and hit edit text/html 2019-01-27T11:30:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_floating_point_operation_error?rev=1548606612&do=diff Explanation Caused by corruption in the registry or the database Resolution I * Open the registry * Navigate to HKEY_Current_User>Software>Cyrious Software>SMS>UserOptions * Remove the strings: “ExplorerCustIndexes”, “ExplorerOrdIndexes text/html 2019-05-24T16:08:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_gl_account_error?rev=1558728514&do=diff Control SQL - Invalid GL Account Error Control SQL - Invalid GL Account Error After upgrading to Control 4.5, marking an order Sale, editing, or posting a payment on an Order marked Sale gives an “invalid or unrecognized gl account” error message. text/html 2019-01-27T11:30:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_operation_error?rev=1548606612&do=diff (aka Crystal 533 Error: Unable to Open Database, aka PEStartPrint error) Explanation Invalid Operation Error occurs when trying to open Cyrious because the path for the Borland Database Engine is either corrupted or not pointing to the correct location. Fixing this issue requires a little confidence in dealing with the Computer's registry. text/html 2019-01-27T11:30:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_use_of_keyword?rev=1548606612&do=diff Explanation This is caused by the use of special characters in certain fields Resolution * Open SMS * Navigate to where the customer gets the error * Edit the record (may be a customer, or order, or estimate, or contact record) * Look for a special character like text/html 2019-01-27T11:30:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invalid_variant_operation_error?rev=1548606613&do=diff Explanation This is corruption in the SSLIP Microsoft Databases. They need to be replaced. Resolution * Open the SSLIP * Navigate to the Database Administration * Check to ensure the proper Groups are active * Disable the Groups that should not be active text/html 2019-01-27T11:30:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/invoice_and_logo_missing_when_printing_invoices_estimateswork_orders?rev=1548606613&do=diff Explanation This can be caused by an edit of the Store Information not saving properly. When you edit some records, SMS creates a temporary copy of the record (with a negative ID) so that it can work with it without changing the original copy. This error indicates that you are trying to do something that would place the record into edit mode, but there is already a temporary working copy of the record. SMS interprets this to mean another user (or window) is already editing the record. text/html 2019-01-27T11:30:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/issue_-_unable_to_scroll_in_explorer?rev=1548606613&do=diff Program Issue Unable to scroll through orders, estimates, companies within the Cyrious Explorer window. The information on the screen does not fully refresh. Explanation of Issue A user recently reported a problem that began after pressing an unknown sequence of keys on the keyboard by accident, after the key sequence was pressed the explorer screen within Cyrious no longer allowed you to scroll through the results. The only information you were able to see was the information on the initial … text/html 2019-01-27T11:30:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/issueing_a_demo_override_code?rev=1548606614&do=diff Explanation This is neccessary when a customer has to replace a dongle for SMS Version 2000. To have temporary access to SMS till the new key arrives. Procedure/Walk-Through * Obtain the Time on the customer's machine. * Open Tech Utility to the Old Backdoor text/html 2019-01-27T11:30:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/jet_engine_failed_to_connect_to_smsstoredata_on_a_client_machine?rev=1548606614&do=diff Explanation Not sure as to the cause of this issue, but believed to be related to Windows 7 and later Sandbox. Older versions of windows as well as current versions, may be issues with either the sharing or the .MDB file Resolution 1 1 Ensure the that the Cyrious SMS short-cut on the client machine is a shortp-cut and not the executable. If it is the executable, replace with the short-cut text/html 2019-01-27T11:30:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/jet_engine_failed_to_connect_to_sslipdata_on_the_server?rev=1548606614&do=diff Explanation This is caused by a version of Kaspersky Antivirus. To resolve will require the removal of Kaspersky from the server. Resolution * Get permission from the owner to remove Kaspersky (they can try reinstalling again afterwards, but if problem reoccurs, they will have to get a different Anti-Virus) text/html 2019-01-27T11:30:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/known_issues_with_anti-virus_applications?rev=1548606615&do=diff Question What Anti-Virus applications have known issues with Cyrious? Basic Anti-Virus Issues 1. Make sure it does not have a separate firewall that is preventing connection to the database. 2. It should not be scanning files within the Cyrious folder while people are working in the system. text/html 2019-01-27T11:30:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/known_paradox_database_limitations?rev=1548606615&do=diff The Paradox Database Engine has some known file limitations. These include: 25 Length of a Field Name 127 Tables open per system 64 Record locks on one table (16Bit) per session 255 Record locks on one table (32Bit) per session 255 Records in transactions on a table (32 Bit) text/html 2019-01-27T11:30:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/line_items_dropping_periodically_whenever_editing_or_saving_orders?rev=1548606615&do=diff Explanation Resolution * Run DBRebuild an see which tables are coming up with errors. * Check BDE Settings for any abnormalities and adjust when necessary. * Navigate to the BDEAdmin in the Cyrious\Common\BDE folder * Select the Configuration tab text/html 2019-01-27T11:30:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/list_of_companies_with_alternate_tax_regions?rev=1548606616&do=diff Explanation This is an automated query to pull customer information for all customers who are not in the default tax region Steps to use * Download to customer's computer this utility * Paste in the Utility folder (i.e. C:\Program Files\Cyrious\SMS\Utilities) text/html 2019-01-27T11:30:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/logo_appears_stretched?rev=1548606616&do=diff toc Explanation Resolution * Make sure logo is 1“ x 1” and under 50k in size and a bmp * Reimport logo if change was needed to be done to logo file * Test, and if still nogo * Transfer lastest SystemData to their machine and retest ==See Also== * Backlinks text/html 2019-01-27T11:30:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/logon_failed._details_database_vendor_code_18456?rev=1548606616&do=diff Error Message Logon failed. Details: [Database Vendor Code: 18456] Explanation of Error When previewing a Crystal Report, the connection to the database is closed when the report is finished generating. Due to the way Quick Reports are previewed, the connection is dropped before the preview is shown. text/html 2019-01-27T11:30:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/logon_failure_the_user_has_not_been_granted_the_requested_logon_type_at_this_computer?rev=1548606616&do=diff Error Message Logon failure: the user has not been granted the requested logon type at this computer. Explanation of Error This error occurs when the user authentication type being used by a network computer to access a network share on another computer has not been granted specific permission to authenticate. This is a windows security policy and permissions problem and is not directly related to anything within Cyrious however this error will result in your inability to access the files nee… text/html 2019-01-27T11:30:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/maximum_number_of_storesx_exceeded?rev=1548606617&do=diff Explanation Resolution * Log into the SSLIP * Select Database Administration * Ensure the Control System Data and Store Data have the Active checkbox unchecked * If the number of stores is set to zero, correct it using the Cyrious Tech Support Utility. text/html 2019-01-27T11:28:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/mfc71u.dll_was_not_found_error?rev=1548606493&do=diff Explanation After updating a client's Control from 4.6...3.30 to 4.6...7.02, could not open any reporting function without Control.exe issuing the error “This application has failed to start because MFC71U.DLL was not found. Re-installing the application may fix this problem. text/html 2019-01-27T11:30:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/microsoft_word_macro_to_reformat_for_wiki?rev=1548606618&do=diff The following macro will (crudely) reformat a Microsoft Word document into a WIKI document. Capabilities The following changes are made: * Heading Level Changes. A line with style Heading 1 is converted to a line with ```` on both sides. Similarly for other heading levels. text/html 2019-01-27T11:30:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/missing_close_out?rev=1548606618&do=diff Explanation There is more than one cause to needing to have to edit a Daily, Monthly, or Yearly Close out but they are usually easy to fix some of the common reasons are as follows. * Customer Did not close the Day,Month,or Year as they should have. text/html 2019-01-27T11:30:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/missing_icons_no_text_under_icons_or_icon_and_text_is_missing?rev=1548606618&do=diff Explanation This is caused when the toolbars are moved, resized, or changed by the user. Resolution 1 * Click on Mgmt * Click on Maintenence * Click on Utilities * Click on Restore Defaults Resolution 2 * Click on Mgmt * Click on Set-Up text/html 2019-01-27T11:30:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/networking_-_unable_to_ping_server_from_client_computer?rev=1548606618&do=diff Explanation DNS issue Resolution * Get the IPAddress for the server from the server * On the client navigate to C:\Windows\Drivers\Etc * Double click on hosts * If necessary choose Notepad * Scroll to the bottom * Click the tab on you keyboard text/html 2019-01-27T11:30:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/no_active_index?rev=1548606619&do=diff Explanation This error is due to missing ID Sequence Database info Resolution * Navigate to Cyrious\SMS\Data folder * Sort files by Name * Scroll down and ensure all the ID Sequence Database files are there - probably missing the .PX file text/html 2019-01-27T11:30:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/no_data_found_or_data_transfer_error_or_some_data_missing?rev=1548606619&do=diff Explanation Resolution * Walk customer through Edit/Saving Order/Estimate * Try preview of Order/Estimate. Resolutions 2 * Go to Company tab and click “View Company” * Edit/Save Company * Retest by attempting to preview the Order/Estimate text/html 2019-01-27T11:30:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/no_error_message?rev=1548606619&do=diff Cyrious Won't Open Cyrious won't open when you double click on the Icon. * This is caused by Cyrious not closing properly on the computer * Open the Task Manager (Can either Hit Ctrl-Alt-Delete, or left click on the Task Bar) * Select the Processes tab text/html 2019-01-27T11:30:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/no_response_from_sslip_when_checking_record_lock?rev=1548606619&do=diff Error Message No response from sslip when checking record lock Explanation of Error This message can occur when you are trying to save something in Control. Severity High. User is down and can't use the program. Possible Root Cause(s) The sslip is either down or locked up. text/html 2019-01-27T11:30:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/no_response_from_sslip_when_creating_ids?rev=1548606620&do=diff No Response from SSLIP when creating IDs Explanation text/html 2019-01-27T11:30:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/operation_aborted?rev=1548606620&do=diff Explanation This is caused by Outlook refusing the connection from a 3rd party program (Cyrious). The causes are varied and not related to Cyrious. Resolution * Get the MSOffice installation disk * Run the repair utility in the MSOffice Work Around text/html 2019-01-27T11:30:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/order_number_and_logo_are_missing_on_invoices?rev=1548606620&do=diff Explanation This is caused by corruption in the database. Resolution 1 * Replace the Store Information table in the Data folder with one from a backup from a time prior when the reports were working * Test text/html 2019-01-27T11:30:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/out_of_balances?rev=1548606621&do=diff * sms_error_-_break_out_sub_error * export_out_of_balance_but_not_the_gl * general_out_of_balance_issue text/html 2019-01-27T11:30:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/out_of_system_resources?rev=1548606621&do=diff Explanation This is usually an issue with registry entries and sometimes with an actual lack of resources. Check the RAM usage in Performance Monitor first to verify that resources are available. Resolution 1 * Click Start * Click Run * Type in Regedit text/html 2019-01-27T11:30:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/paradox_errors_in_sms_v2000?rev=1548606621&do=diff Explanation Resolution If deleting the lock files does not resolve the issue try the following steps: * Check to see if the server is running Win98 or Win95 * Check to see if the client machine is running Win2000 * If so, replace the P:\POS with the text/html 2019-01-27T11:30:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/passwords?rev=1548606621&do=diff Question How do I Reset A Users Password in Control? Answer To Reset A Users Password in Control: 1. Go to employee setup 2. Select the desired employee 3. Click on Edit User 4. Click on the “Change UserName/Password” button 5. Insert the old password text/html 2019-01-27T11:30:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/payment_missing_in_the_totals_tab?rev=1548606622&do=diff Explanation This is caused by a problem writing to the database. It is usually related ton either networking issues or interface between Cyrious and Windows Resolution * Get order number from customer * View order in SMS - confirm Totals tab is missing payment, but payment is showing in the text/html 2019-01-27T11:30:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/please_verify_that_the_microsoft_data_access_components_2.1_or_later_have_been_properly_installed?rev=1548606622&do=diff Error Message Please verify that the Microsoft Data Access Components 2.1(or Later) have been properly installed. Explanation of Error Control, SMS, or the SSLIP are encountering problems accessing the Microsoft Access databases that are used with the program. These databases are accessed using the Microsoft Data Access Components (MDAC). Microsoft Data Access Components (MDAC) are distributed with various products. Since Windows 2000, they have been a core part of the operating system, and c… text/html 2019-01-27T11:30:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/policies_and_terms?rev=1548606622&do=diff Implementation Services * report_customization_policy text/html 2019-01-27T11:30:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/power_management_issues?rev=1548606623&do=diff * sms_issue_-_constant_db_corruption * external_exception_error_c00000006 text/html 2019-01-27T11:30:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/primary_filegroup_is_full?rev=1548606623&do=diff Error Message Primary File group is full Explanation of Error SQL Allows you to split databases into “file groups”. This functionality is often used by high-end database system to split the database onto different drives. Cyrious Control only uses one (the default) file group. text/html 2019-01-27T11:30:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/printer_driver_related_problems?rev=1548606623&do=diff Printer Driver related printer\email problems * error_-_floating_point_overflow * unable_to_print_2nd_copy_of_report_-_error_or_garbled_characters text/html 2019-01-27T11:30:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/printing_extra_blank_page?rev=1548606623&do=diff Explanation This is usually a Crystal problem. Resolution 1 * Ensure this is not a localized problem, (1 specific order/estimate) * If it is, remove blanks from text fields Resolution 2 * Replace the SMSSystemConfig file (crystal_reports_driver_installation) Resolution 3 text/html 2019-01-27T11:30:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/product_layout?rev=1548606624&do=diff Question How do I keep my Product Layout from being cut-off on an Invoice in Control? Answer The width of the Product Layout window (what is being truncated) can be changed by following these steps: * Go to setup -->system setup * Once in system setup, click on text/html 2019-01-27T11:30:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/production_terminal_-_add_materials_used?rev=1548606624&do=diff How do I add materials/parts used in production terminal? Explanation 1. After logging in to your Production Terminal select the order for which the parts are being used. 2. Select the details tab on the vertical right hand side of the page. Scroll down until you see the Parts hyperlink. Select this menu heading. text/html 2019-01-27T11:30:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/production_terminal_-_file_not_found_exception?rev=1548606624&do=diff Explanation When you click the Work Order Report button, Production Terminal requests that the SSLIP create this file in a certain amount of time. This error occurs if the file is not found at the end of the timeout. This can have several different causes and we will check them in this order: text/html 2019-01-27T11:30:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/production_terminal_-_prompted_to_save_aspx_file?rev=1548606625&do=diff Explanation When you generate the Work Order report from Production Terminal, your browser will open an ASPX page that serves the actual PDF to you. You will receive this message if you do not have a PDF viewer installed on your system. The file you are being asked to save is not actually an ASPX file, but a PDF file. text/html 2019-01-27T11:30:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/production_terminal_-_report_file_not_found_exception?rev=1548606625&do=diff Explanation of error When attempting to view a work order's details in Production Terminal, the user receives an error stating “Report file not found” followed by a path to the Reports folder. Resolution ---------- * Replace the Arial Fonts on the server by following text/html 2019-01-27T11:30:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/question_-_what_is_c3s?rev=1548606625&do=diff Question What is C3S that is running in my system tray? Answer C3S is the Cyrious Credit Card System. It is used for the following purpose: * Handle all encrypted storage in the database. * Handle online credit card processing. C3S was introduced with Control 4.4 and is an integral part of achieving PCI compliance. All of the encyrption and secure processing was broken out into this module so that it was as independent of the main program as possible. This provides greater data security… text/html 2019-01-27T11:30:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/quickbooks_errors?rev=1548606625&do=diff * import_to_quickbooks_not_showing_up * exporting_to_quickbooks_data_out_of_balance_but_dar_in_balance * transaction_split_line_to_ar_must_include_a_customer_on_that_split_line text/html 2019-01-27T11:30:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/recommended_network_troubleshooting?rev=1548606626&do=diff Severity High. Normally new users can't consistentally use SMS until this resolved. Possible Root Cause(s) Resolution * Check the Power Management settings on all computers that have Cyrious installed on them. * Right click on My Computer. text/html 2019-01-27T11:30:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/recreate_missing_administrator_or_user?rev=1548606626&do=diff Explanation Resolution * Click Start * Click Run * Type Regedit * Open the following folder: * Right click in the open space to the left * choose New * Click DWORD Value * Type the missing user ( Administrator, etc. ) * Enter text/html 2019-01-27T11:30:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/recreating_part_usage_cards_from_scratch?rev=1548606627&do=diff Explanation This page describes the process to recreate Part Usage Cards. This may be helpful for a specific order or for an entire system in order to correct errors in the historic inventory valuations. It should ONLY be used by a highly skilled technician as real data is permanently created and there are financial ramifications of the changes. text/html 2019-01-27T11:30:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/reinstalling_mdac?rev=1548606627&do=diff Overview MDAC (Microsoft Data Access Components) can become corrupted in some cases, this is typically seen when you are unable to open a Microsoft Access database, connect to it through ODBC, or in some cases can be the cause to why SMS or Control gets stuck on text/html 2019-01-27T11:30:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/remove_fii_specialty_products_from_db?rev=1548606627&do=diff Explanation This is to remove the specialty products that start with the @ that FII had created in the Product table Resolution * Copy over the latest SMSSystemConfig and replace the old one with it * Run query to remove the specific products text/html 2019-03-21T18:58:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/report_customization_policy?rev=1553209119&do=diff Question What is the Cyrious policy regarding Report Customization, Creation, and Maintenance? Answer * Scope of Services Cyrious Software offers fee-based creation and customization of its standard reports including but not limited to invoice, estimate and work-order report templates. These services are not covered under a technical support contract. text/html 2019-01-27T11:30:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/reporting_set-up?rev=1548606628&do=diff Explanation This is used to customize the Report Groups to meet the customer's needs. Basically broken into 3 groups: 1. Reporting Menu; 2. Quick Reports Menu; 3. Individual Menu. Each of which can be edited to their specific requirements. Basic Steps text/html 2019-01-27T11:30:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/reset_tcp_ip_and_winsock_settings_for_windows_xp?rev=1548606628&do=diff The following steps will reset the TCP/IP protocol in Windows. This is considered and advanced Windows XP Troublshooting technique and should only be done by an experienced technician because if done incorrectly, may cause damage to your Windows OS text/html 2019-01-27T11:30:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/row_number_error_while_updating?rev=1548606628&do=diff Error Message An error has occurred while updating the ““InventoryLog”” table from version 4 to 5. || || 'ROW_NUMBER' is not a recognized function name“ Explanation of Error The update query is using a SQL function called ROW_NUMBER to number the results in order. The function does not exists in SQL Server 2000, only SQL Server 2005 and later versions. text/html 2019-01-27T11:30:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/royalty_report_wont_print?rev=1548606629&do=diff Explanation If all other reports seem to be printing fine and the Royalty report doesn't want to work, it may be due to the customer's logo being too large. Resolution * Open Cyrious * Navigate to Mgmt>Set-Up>Store Information * Select the Logo tab text/html 2019-01-27T11:30:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/security_device_cannot_be_found_system_is_running_in_demo_mode_an_is_not_reconizing_key?rev=1548606629&do=diff Explanation Resolution * Make sure that key is installed on that machine * If running Windows 98, navigate to run Start>Program Files>Cyrious Software>Install HASP * If running Windows 2000 or above, download the current HASP Drivers * text/html 2019-01-27T11:30:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/security_device_expired?rev=1548606629&do=diff Error Message Security Device Expired Explanation of Error The authorization date for the security device has expired or the key information got corrupted and needs to be reset. Severity High. All users are down and can't access the program. Possible Root Cause(s) text/html 2019-01-27T11:30:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/security_device_found_but_not_authorized_for_the_program_terminating?rev=1548606630&do=diff Error Message Secruity device found but not authorized for the program! Terminating Explanation of Error This error happens when the SSLIP has lost the program settings to which it has access to. Severity High. Users are down and can't launch the program until this situation is resolved. text/html 2019-01-27T11:30:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/set_up_the_company_logo_in_sms?rev=1548606630&do=diff Explanation Resolution * Make sure logo is 1“ x 1” bmp and under 50k in size. * Import logo by navigating to Mgmt>Set-Up>Store Information * Select the Logo tab * Click Open Picture * Select Save text/html 2019-01-27T11:30:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/setting_up_cyrious_to_do_the_backups?rev=1548606630&do=diff sms_backup_database_set-up_v8.6_and_higher text/html 2019-01-27T11:30:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/setting_up_email_based_on_info_from_another_computer_with_email_set-up_in_cyrious?rev=1548606631&do=diff Explanation You will be using information available in the registry. IF you are not comfortable working in the registry, DO NOT ATTEMPT Steps * Have the customer connect you to a computer that has Cyrious set-up to email and works. * Open the registry text/html 2019-01-27T11:30:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/setting_up_email_in_cyrious?rev=1548606631&do=diff Explanation Cyrious has the ability to email either directly out or use Outlook. Setting up email in Cyrious is a local setting. Therefore the steps below are required on every computer that has Cyrious. =Resolution= Steps 1(Using Outlook) * Open Cyrious on the computer that needs to be set up text/html 2019-01-27T11:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/setting_up_outlook_to_work_with_cyrious_-_without_asking_permission_to_use_every_time?rev=1548606632&do=diff Explanation While Cyrious does not support MS Outlook, this may prevent Outlook from asking permission to allow Cyrious access to the emal Resolution * Run Outlook in Admistrator Mode. The functions below will not be enabled to be changed otherwise. text/html 2019-01-27T11:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/setup_a_port_offset?rev=1548606632&do=diff The following steps will setup a port offset for the SSLIP and Control applications. Explanation When you open SMS or Control it transmits a UDP broadcast on port 2868 to locate the SSLIP. The SSLIP responds with it's IP, and SMS or Control then connects to that IP on TCP port 2879. text/html 2019-01-17T09:21:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sidebar?rev=1547734877&do=diff home text/html 2019-01-27T11:31:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms-reset_the_dns_server_settings?rev=1548606665&do=diff Concept DNS (Domain Name System) is a way of giving a computer a more human name. Computers resolve DNS addresses like www.google.com and CyriousServer into addresses so that network traffic can go there. Computer can resolve the addresses locally (for other computers on their network) or using a text/html 2019-01-27T11:31:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_add_or_remove_invoices?rev=1548606666&do=diff Explanation In Cyrious SMS you are given the freedom to choose which kind of Invoice, Work Order, or other report that you would like to print when viewing Orders. This can be done in Reporting Setup In Reporting Setup: * Expand the Individual Menu folder on the left-hand side text/html 2019-01-27T11:31:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_backing_up_the_database?rev=1548606666&do=diff * backing_up_sms_v8.6_data * backing_up_sms_v8_data * backing_up_sms_v2000_data3 text/html 2019-01-27T11:31:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_clearing_record_lock_errors?rev=1548606666&do=diff =Error Message= Customer is receiving a message “Record Locked by Another User” when attempting to edit an order or customer (or other object) or apply a payment or change status. =Explanation of Error= SMS tracks whether a customer, product, or several other types of records are being edited by creating a negative record in the database with the same ID. (Eg. A CompanyID=-205 is created when the user edits CompanyID=205.) These tracking records are normally deleted when the edit is canceled … text/html 2019-01-27T11:31:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_configuring_email_settings?rev=1548606666&do=diff These links will provide different options to set up a customer's email. setting_up_email_in_cyrious setting_up_email_based_on_info_from_another_computer_with_email_set-up_in_cyrious text/html 2019-01-27T11:31:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_handling_the_sandbox_issue?rev=1548606667&do=diff Explanation Windows 7+ can be very restrictive towards applications written for the previous versions of Windows. This is the case with the Borland Database Engine (BDE), which has been resolved in SMS version 8.91 Option 1 * Upgrade to 8.91 (Providing there are no current restrictions). text/html 2019-01-27T11:31:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_inserting_a_past_closeout?rev=1548606667&do=diff =Issue= The day, month, year, or GL export was not closed by accident. This WIKI describes the process of inserting a retroactive closeout in the database. =Explanation of Error= Cyrious SMS uses closeouts to track when the daily, monthly, or annual reports were created, or when the GL export file was created. This is simply a date and time entry in the Closeout table. To retroactively closeout, a new record must be manually inserted into this table. text/html 2019-01-27T11:31:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_installing_crystal_reports_8.5?rev=1548606667&do=diff Crystal Reports is the primary reporting engine for Cyrious SMS and Control. Each client must have the Crystal Report DLLs installed in order to properly print or preview reports. Crystal Drivers Installation Crystal Drivers and installation is based on the version of Windows and bit size. It is imperative to use the correct Crystal set-up. text/html 2019-01-27T11:31:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_re-exporting_the_gl_for_a_previous_time_period?rev=1548606668&do=diff Explanation Customer either forgot to export the QB iif or had an out of balance (OOB) which would QB would not allow to be imported. Re-exporting for a previous day * In Cyrious go to File>Export>Export Accounting data * Click on the Change Export Dates button text/html 2019-01-27T11:31:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_re-printing_closeout_reports_from_previous_time_period?rev=1548606668&do=diff Explanation Pulling previous close outs reports from a historic time frame is very limited. Note, that if you are closing the day, month, and year, or the day, and month, you have to pull the reports based on the time frame you want. In other words, you will pull Daily reports using text/html 2019-02-28T14:36:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_rebuild_database?rev=1551382568&do=diff Error Message Various database, key violation, index, or blob messages. Explanation of Process The Database Rebuild utility is used to repair a database table. It does this by doing the following: * Backs up the entire database (on DBRebuilder Ver 8.50.2005.09+). text/html 2019-01-27T11:28:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_removing_a_closeout?rev=1548606492&do=diff =Issue= The day, month, year, or GL export was closed by accident. This WIKI describes the process of removing a closeout in the database. =Explanation of Error= Cyrious SMS uses closeouts to track when the daily, monthly, or annual reports were created, or when the GL export file was created. This is simply a date and time entry in the Closeout table. To retroactively closeout, a new record must be manually inserted into this table. text/html 2019-04-03T15:06:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_repairing_key_violations?rev=1554318361&do=diff Error Message Various forms that include the words “Key Violation” in them. Explanation of Error Every row in the database has a unique “Key”. This is the ID that the database uses to identify that row. No two rows in the same table can have the same Key (since it would mean the database could not tell which one you wanted). text/html 2019-01-27T11:31:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_reset_password?rev=1548606669&do=diff Explanation Customer forgot password Resolution * Ask customer what time it is at their office * Get the Old Backdoor passcode from the Tech Utility for the appropriate time * Navigate the customer to Mgmt>Set-Up>Change Passwords * Give them the backdoor passcode text/html 2019-01-27T11:31:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_restart_sslip?rev=1548606669&do=diff Restart the SSLIP * Have everyone get out of Cyrious * Try shutting the SSLIP down by right clicking on the icon on the taskbar and selecting Shut Down * Click on the Start button * Select all Programs * Go to the Startup folder * Start the SSLIP text/html 2019-01-27T11:31:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_setting_permissions_on_cyrious_folder?rev=1548606669&do=diff Explanation Windows requires sharing of folders to be accessed across the network by other computers. Cyrious uses a hidden share (designated by the $ at the end of Cyrious) Set up the Shared Folder * Navigate to the C:\Program Files (x86)\ (or text/html 2019-01-27T11:31:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_setting_up_the_backup_options?rev=1548606670&do=diff * setting_up_cyrious_to_do_the_backups text/html 2019-01-27T11:31:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_sms_client_installation?rev=1548606670&do=diff =Condition / Cause= This WIKI applies when a customer wants to install SMS on a new client. The SSLIP must be running on the server/host computer at the time of installation. =Explanation of Process= To properly install SMS on a client requires components be installed: text/html 2019-01-27T11:31:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_sms_server_installation?rev=1548606670&do=diff SMS Server Installation These are the steps to install Cyrious SMS V8.6 and v8.91. There are several versions and all basically install the same way. SMS 8.91 - New Server Installation * Download the latest version of SMS from the support website. text/html 2019-01-27T11:31:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_sms_server_swap?rev=1548606671&do=diff These are the steps to move the server installation of Cyrious onto a new computer. Notes SMS 8.5 and older will not run on Vista, Windows 7, or later operating systems. Only versions SMS 8.6 and higher support these operating systems. SMS 8.91 requires Windows 7 Professional or higher. text/html 2019-01-27T11:31:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_upgrade_8.91_to_latest_release?rev=1548606671&do=diff These are the steps to upgrade Cyrious v8.91 to the latest version of 8.91. If you are running an older version of SMS, see sms1_-_upgrade_version_8.x_to_8.91. Prepare * Close all copies of SMS. * Shut down the SSLIP on the server/host. * Download the latest version of SMS from the support website. text/html 2019-01-27T11:31:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_upgrade_license_with_license_key?rev=1548606672&do=diff Explanation Customer doesn't have a dongle or dongle does not function for reasons undetermined, will require a key file Steps * Open the Tech Utility * Click on the tab File Key * Open the Customer Record in Control and go to the Authorizations tab for the required information for the following steps: text/html 2019-01-27T11:31:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_upgrade_license_with_security_dongle?rev=1548606672&do=diff Upgrade License Severity High Limited use of the program Resolution * Check the customers record to see if they still have a balance outstanding. * Connect to customer's server machine. * Copy over the Tech Utility to the customer desktop * text/html 2019-01-27T11:31:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_upgrade_version_8.x_to_8.91?rev=1548606673&do=diff These are the steps to upgrade Cyrious SMS versions 8.0, 8.5, and 8.6 to SMS version 8.91. Prepare * Close all copies of SMS. * Shut down the SSLIP on the server/host. * Download the latest version of SMS from the support website. * If upgrading from 8.0 or 8.5 to 8.91, download and install the 8.6 upgrade and run it first. text/html 2019-01-27T11:31:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms1_-_upgrade_version_2000_to_8.91?rev=1548606672&do=diff Explanation Upgrading Cyrious Version 2000 to 8.91 requires checking the specific version of Cyrious before upgrading. If Cyrious Version 2000 is SR-3, it must be upgraded to Cyrious Version 2000 SR-5 before proceeding to upgrade to 8.91. Previous versions (SR-1 and SR-2) follow the same procedure as upgrading SR-5 to 8.91. text/html 2019-01-27T11:31:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms2_-_creating_bug_tickets_for_standard_reports?rev=1548606673&do=diff text/html 2019-06-21T11:27:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms2_-_inserting_missing_records_from_a_backup_table?rev=1561130842&do=diff Condition / Cause This WIKI applies when data that exists in a backup does not exist in the live version of the data, and the customer wants the data re-inserted. The most common application of this is to re-insert Line Items for Orders and Estimates that may have been lost due to an error during the save process. text/html 2019-01-17T09:21:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms2_-_repairing_gl_out_of_balance?rev=1547734877&do=diff Condition / Cause This WIKI applies when the GL (financial information) is not in balance. The only valid case when this should occur is with starting balance numbers (since Cyrious SMS is not a full ledger). This is usually caused by a bug in SMS or by missing/inconsistent data when the GL is being computer. The most common causes in SMS for this are: text/html 2019-01-27T11:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_add_new_company?rev=1548606632&do=diff Add New Company * From the Home screen in SMS Click on the Company tab up top, or press Ctrl+U on the keyboard. * Enter the all of the Company information in all required fields on the Company Tab. Make sure to add or remove the check box for active customer depending on the customer, you will also need to check the Check if Tax Exempt checkbox if they are exempt. text/html 2019-01-27T11:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_ar_aging_summary_and_ar_aging_detail_reports_not_showing_contacts_and_phone_numbers?rev=1548606632&do=diff Explanation of Error Crystal Reports are looking for the data based on the linking of key data fields and is unable to locate the data Severity High Possible Root Cause(s) Rebuilding of the database on occassions will resequence the order of the indexes. Once this occurs, the only recourse is to either resequnce the order or use the old text/html 2019-06-04T12:54:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_configuring_multiple_store_databases?rev=1559667253&do=diff Explanation This procedure allows a store location to have two or more separate databases for access and is utilized via two or more v8 executable files on their desktop. All database paths are stored in the SSLIP upon making the change. Please see text/html 2019-01-27T11:28:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_daily_closeout?rev=1548606492&do=diff Error Message (NONE) Severity Low. User is not down, and the close out can be done at the end of the day or at the beginning of the day when there is no business taking place, depending on the choice of the user. How to Close Out Go to cyrioussoftware.com and go to tech support and go to Trainging videos and search for closeouts, then simply follow the instructions. text/html 2019-01-27T11:30:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_error_-_default_payment_term_is_missing_please_contact_cyrious_technical_support?rev=1548606633&do=diff Explanation Receiving “Default Payment Term is missing , please contact Cyrious Technical Support” when attempting to apply finance charges. Resolution * Ensure that payment terms are set for each customer that currently has an order with a status of Picked-Up text/html 2019-01-27T11:30:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_error_-_row_cannot_be_located_for_updating?rev=1548606633&do=diff Explanation Resolution * Close and reopen application. * Try once more. text/html 2019-01-27T11:30:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_error_-_unable_to_edit_the_zero_record?rev=1548606634&do=diff Error Message * Unable to edit the zero record * 'xxx.xxx' is not a valid timestamp Explanation of Error Severity High. User is not down. Possible Root Cause(s) If the error occurs when viewing a customer record, the TaxIDExpDate field is the wrong field type. text/html 2019-01-27T11:30:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_error_unable_to_edit_zero_record?rev=1548606634&do=diff Error Message Unable to edit the zero record. Explanation of Error When attempting to edit a customer record in SMS you receive an error advising: “Unable to edit the zero record”. Severity Low Possible Root Cause(s) The TaxIDExpDate field for that customer contains an improperly formatted date which is causing an error when SMS attempts to edit the customer record. text/html 2019-01-27T11:30:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_error_unable_to_purge_contact_table?rev=1548606635&do=diff Explanation Resolution 1 * Remove Lock files (Remove lock files procdures) Resolution 2 SMS - Error Unable to Purge Contact table - Contact Table is locked * Shut down Cyrious * Shut down the SSLIP * Rebuild the database using the dbrebuild utility - this is usually due to corruption in the Contact or Daily Contact table text/html 2019-01-27T11:30:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_failed_to_set_the_caledar_date_or_time?rev=1548606635&do=diff Explanation This caused because a Due Date or Time has not been set for new order/estimate Resolution 1 * Set the Due Date and Time Resolution 2 * Navigate to Mgmt>Set-Up>User Options * Check the Automatically claculate due date for orders text/html 2019-01-27T11:30:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_how_do_i_..._void_a_payment?rev=1548606635&do=diff Question How do I ... Void a Payment in SMS? Answer To void a payment in SMS: * Click on Pay-Status. * Select your order at the top of the screen. * Click on the Void Payment button (tab) in the middle of the screen. * Select the payment you want to void. text/html 2019-01-27T11:30:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_identifying_the_sms_program_version_with_the_data_folder?rev=1548606636&do=diff Question How do I identify which version of SMS a particular database was last used on if I only have the Data folder? Answer * Copy the Data folder to your system. * Using the DBBrowser.exe browse to the Store Information Database table. * text/html 2019-01-27T11:30:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_installation_errors?rev=1548606636&do=diff * database_group_not_found text/html 2019-01-27T11:30:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_marketing_errors?rev=1548606636&do=diff Marketing Errors * invalid_file text/html 2019-01-27T11:30:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_modifiers_not_listed_in_view_and_edit_modifiers?rev=1548606636&do=diff Program Issue Price Modifiers appear when viewing and edit products or when creating an estimate or order, however you can not find them under View/Edit Modifers. Explanation of Problem This issue is caused by having a space as the first character of the text/html 2019-01-27T11:28:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_monthly_closeout?rev=1548606492&do=diff Error Message (NONE) Severity Low. User is not down, and the close out can be done at the end of the day or at the beginning of the day when there is no business taking place, depending on the choice of the user. How to Close Out Go to cyrioussoftware.com and go to tech support and go to Trainging videos and search for closeouts, then simply follow the instructions. text/html 2019-01-27T11:30:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_payment_errors?rev=1548606637&do=diff Type of Errors * entered_by_grayed_out_in_multipayments * double_payment_displayed * payment_missing_in_the_totals_tab text/html 2019-01-27T11:30:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_quick_price_screen_appearing_with_blank_window?rev=1548606637&do=diff Program Issue The Quick Price screen shows up with a blank window as shown in the image below. You can still use the Quick Price screen by clicking on the Products tab, however this tab should be the default window shown when entering Quick Price. text/html 2019-01-27T11:30:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_statements_errors?rev=1548606637&do=diff * statement_pulling_incorrect_info * statement_not_pulling_any_info * statement_printing_all_statement_notes * statement_not_selecting_the_ap_contact_for_emailing text/html 2019-01-27T11:30:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_support_expired_at_the_bottom_of_cyrious?rev=1548606638&do=diff Explanation This is a reminder of when your support contract ends. This will not disable any features in your Cyrious. If you are not on monthly support contact Cyrious Technical Support if you believe this to be an error. If you are on monthly support text/html 2019-01-27T11:28:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_-_yearly_closeout?rev=1548606492&do=diff Error Message (NONE) Severity Low. User is not down, and the close out can be done at the end of the day or at the beginning of the day when there is no business taking place, depending on the choice of the user. How to Close Out Go to cyrioussoftware.com and go to tech support and go to Trainging videos and search for closeouts, then simply follow the instructions. text/html 2019-01-27T11:30:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_1_-_support_expired?rev=1548606638&do=diff Explanation This is a reminder of when your support contract ends. This will not disable any features in Cyrious. Resolution * Open Company record in Control and go to Service Contact tab * Note the Expiration Date* * Open you Tech Utility text/html 2019-01-27T11:30:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_8.5_sslip_needs_a_keyless_file?rev=1548606644&do=diff Explanation Older version of SMS can not use a license.ckf file. Resolution * Create a txt file called SSLIP_Options in the SSLIP folder * Get Greg to create a keyless file * Open the SSLIP_Options txt file * Add the following: 'Keyless=' and then the number Greg gives you and save text/html 2019-01-27T11:30:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_2000_client_installation?rev=1548606644&do=diff This is a step by step instruction on how to install Cyrious SMS 2000 on a client machine Procedure/Walk-Through Obtaining the Computer Name: (On the server) * Click on Start * Right-Click on My Computer * Click on Properties * Click on Computer Name , write down the Computer name text/html 2019-01-27T11:30:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_2000_server_installation?rev=1548606644&do=diff This is the step by step process to install Cyrious SMS 2000 on the server. Procedure/Walk-Through Creating the Cyrious folder * Click on Start > My Computer * Double click on the: C Drive * Click on File > New Folder * Rename the folder to Cyrious text/html 2019-01-27T11:30:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_access_violation?rev=1548606645&do=diff SMS Access Violation Errors SMS Access Violation Error An access violation is a poorly named error in Windows when a program is trying to access memory in Windows that it does not own. This is usually caused by: •Uninitialized Object. When a program references an object that has not been created. (The error will reference an address that starts with FFFF or 0000.) text/html 2019-01-27T11:30:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_backup_database_set-up_v8.6_and_higher?rev=1548606645&do=diff Explanation This is only for SMS V8.6 and higher. This is the recommended way to ensure that you get complete backups of you Cyrious Data, including the MDB files. This is also the recommended way to ensure off-site backups do complete backups, not incremental backups. The steps for set-up is below the issue that is occurring on Windows 7 and higher. text/html 2019-01-27T11:30:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_client_installation_-_deprecated?rev=1548606645&do=diff SMS Client Install - DEPRECATES This is the old client installation procedure. Refer to SMS1 - Client Install for the current (and much simpler) process. Client Install A: Items Required to Complete Install * SMS Installation CD or SMS Downloadable Installer * text/html 2019-01-27T11:30:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_client_machines_cant_startup?rev=1548606646&do=diff Error Message Driver or network connection failure error, when you try to open the SMS shorcut. Explanation of Error Severity High. User is down on all the systems with the problem. Possible Root Cause(s) * DNS Server is not set properly Resolution text/html 2019-01-27T11:30:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_close_out_issues?rev=1548606646&do=diff Close Outs * sms_-_daily_closeout * sms_-_monthly_closeout * sms_-_yearly_closeout Close Out Errors * missing_close_out * closed_out_and_the_daily_totals_on_daily_activity_report_is_zero Version Information * Reported : 07/2009 * Version(s): SMS 8.5, 8.6, 8.9 Beta * Fixed in :07/2009 Related Errors SMS - Error Missing\Incorrect closeout text/html 2019-01-27T11:30:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_company_entry?rev=1548606646&do=diff See sms_-_add_new_company Version Information * Reported : 07/2009 * Version(s): 8.6,8.9Beta * Fixed in : 07/2009 Related Errors text/html 2019-01-27T11:30:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_computer_hardware_specifications?rev=1548606647&do=diff What are the system requirements for running Cyrious SMS? Minimum Recommended Server Recommended Client Processor Intel Dual core Processor Intel i5 Processor Intel i3 Processor Memory 1 GB 4 GB 4 GB Hard Drive 15 GB free SATA or SAS Drive text/html 2019-01-27T11:30:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_configuration_related_problems?rev=1548606647&do=diff SMS configuration related printing/email problems * unimplemented_5.1.1 * whenever_printing_anything_out_of_the_system_the_logo_resembles_a_big_black_box * statement_not_selecting_the_ap_contact_for_emailing * cyrious_printing_an_extra_page_for_invoices_and_or_estimates * sms_invoice_shows_voided * sms_-_ar_aging_summary_and_ar_aging_detail_reports_not_showing_contacts_and_phone_numbers * error_130_-_failed_to_retrieve_error_message_from_print_engine * order_number_and_logo_are_… text/html 2019-01-27T11:30:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_database_error?rev=1548606647&do=diff SMS Database Errors SMS utilizes a Paradox database for most of its information, though some of the more recently added information is stored in a Microsoft Access Database. Neither of these databases are server-based databases, meaning each client must open the files and process any necessary information. Because of this, they have many text/html 2019-01-27T11:30:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_delayed_write_error?rev=1548606647&do=diff Windows Error - Delayed Write Error Error Message Explanation of Error Severity High. User can not use SMS fully. Possible Root Cause(s) * “Enable write caching on the disk” is enabled * Wrong cable type for the hard drive * text/html 2019-01-27T11:30:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_access_violation?rev=1548606648&do=diff Windows Error - Access Violation Error Message Explanation of Error Severity High. Client is down. Possible Root Cause(s) Resolution * Shut down and restart Cyrious * If that does not resolve it, shut down that computer and restart Cyrious text/html 2019-01-27T11:30:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_access_violation_while_printing?rev=1548606648&do=diff SMS Error - Access Violation While Printing Error Message Explanation of Error Severity Normal. User is not down. Possible Root Cause(s) * Printer Driver Incompatibility * Windows DEP interfering with the Print Driver. * Out of drive space. text/html 2019-01-27T11:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_blob_error?rev=1548606649&do=diff Error Message(s) Explanation of Error BLOB is an acronym for “Binary Large OBject”. It is the database term for any (usually large) amount of data that is not a fixed size. In SMS, common BLOB types are * Memo * Image * Report File text/html 2019-01-27T11:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_break_out_sub_error?rev=1548606649&do=diff Explanation When trying to export Accounting data from Cyrious for Quickbooks, you get an error: Break Out Sub Resolution * This requires you contact Cyrious Tech support, but this is what they will be doing to resolve the issue * Open DBBrowser text/html 2019-01-27T11:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_cannot_perform_action_on_closed_dataset?rev=1548606649&do=diff Explanation This is usually corruption in the database Resolution * dbrebuild * If that does not work, contact Cyrious Tech Support text/html 2019-01-27T11:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_cant_find_isactive?rev=1548606649&do=diff Correct Error of can't find IsActive * Shut down Cyrious everywhere * Shut down the SSLIP * Navigate on the main Cyrious computer to the Utilities folder in the SMS folder * Add this file to the Utilities folder * Click the Execute button text/html 2019-01-27T11:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_class_not_registered?rev=1548606650&do=diff Explanation This occurs due to a failure to link to MicroSoft Office. Resolution * Work around - Open Excel or Word, depending on what's format is required, now export it from Cyrious. * To fix - use the MS Office Disk and run the repair utility therein. text/html 2019-01-27T11:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_corrupt_table_other_than_header?rev=1548606650&do=diff Error Message “Table Corrupt Other Than Header” ... “Corrupt File Other Than Header” ... Explanation of Error The BDE has found an inconsistency in the data portion of the DB file (which also contains the Header information - hence the poorly named error message). text/html 2019-01-27T11:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_directory_is_controlled_by_other_.net_file?rev=1548606650&do=diff SMS Error - Directory is controlled by other .NET file. Error Message Directory is controlled by other .NET file. Directory: <\\ComputerName\CYRIOUS$\SMS>\ File: <\\Computername\CYRIOUS$\SMS\DATA\PDOXUSRS>.LCK Explanation of Error The BDE (Borland Database Engine) utilizes the PDOXUSRS.NET, PARADOX.LCK, and PDOXUSRS.LCK text/html 2019-01-27T11:30:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_employeeid_has_an_open_timecard_but_no_employeeid_present_in_database?rev=1548606651&do=diff Explanation Resolution * Open DBBrowser * Click on SQL Tab and go to “Advanced” tab * Run SQL 1 * * Run SQL 2 for an employee that is not in the employee list * Reopen SMS and go to TimeClock Adjustments screen to verify correction text/html 2019-01-27T11:30:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_error_104?rev=1548606651&do=diff Error Message A Crystal Reports error has occurred. Error 104 Failed to obtain Version Information from CRPE32.DLL - GetCrpc.Version Window Error Number:1812 - The specified image file did not contain a resource section Explanation of Error text/html 2019-01-27T11:30:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_field_breakoutsub_not_found?rev=1548606651&do=diff Error Table: Field 'BreakOutSub' not found. Explanation This error will appear if an update failed to add some extra fields to the Account Code Database table that are needed in later versions to allow users to break out Income by the base price, modifier price, install price, and discounts. text/html 2019-01-27T11:30:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_index_out_of_bounds?rev=1548606651&do=diff Explanation Resolution * Close all SMS sessions, leave only SSLIP running. * Reopen SMS on one computer, but do NOT go beyond home screen. * Select MGMT > Maintenance > Utilities > Database Cleanup * Run Cleanup with no one in SMS Note:If this does not fix then contact senior tech DB will have to be scanned for NAN's text/html 2019-06-13T19:37:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_index_out_of_date?rev=1560469020&do=diff SMS Error - Index Out of Date Error Message “Database Index Out of Date” … Severity Moderate. The chance for data loss is Moderate, but the user is unable to use the database until it is corrected. Occassionally, if the errors are in the Estimate Details or Order Details tables, it is not uncommon to lose line items for the order/estimate that was corrupted. For many users, this error occurs frequently. For others, it almost never occurs. text/html 2019-01-27T11:30:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_invalid_file_name?rev=1548606652&do=diff Explanation This error usually indicates a bad Marketing installation or an invalid file path for the reports. See Resolution 3 for Windows 7 issue Resolution 1 (SMS V2000) * Make sure no instances of Marketing are running. * Browse to POS directory. text/html 2019-01-27T11:30:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_invalid_operation?rev=1548606652&do=diff Explanation Problems connecting to the database. See Resolution 3 for Windows 7 and newer Resolution 1 * Ensure the Borland registry path is correct - see borland_registry_installation Resolution 2 * Ensure that the BDE folder is in the Common folder and it is populated text/html 2019-01-27T11:30:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_invalid_pointer_error?rev=1548606652&do=diff Explanation When clicking on the explorer tab, you get an error that says “Invalid Pointer”. From this point, the system locks up and you must task manager close and restart. This is a result of the customer resizing the view of one of the columns in the explorer window text/html 2019-07-18T12:53:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_key_violation?rev=1563468822&do=diff Key Violation Each record in the SMS datbase (and most others) has a key field. This field uniquely identifies the record (row of data) and is used by the database to quickly find the record. In SMS tables, the first column in the table (usually ending in text/html 2019-01-27T11:30:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_lock_file_has_grown_too_large?rev=1548606653&do=diff Explanation This can be a problem with the BDE settings, but can also be an issue with Sharing and lock files. Resolution 1 * Unshare and reshare Cyrious (See: how_to_-_share_cyrious_versions_8_and_up * Remove any and all lock files (See: SMS Error - .NET File Error) * Test Resolution 2 * Open the BDEAdmin text/html 2019-06-13T18:57:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_missing_line_items?rev=1560466643&do=diff Missing Products in an Order Severity Explanation of Error Possible Root Cause(s) Resolution * Determine the date the order was created or last edited (money change or status change). * If created since the last backup, the customer will have to edit the order and reenter the Products. text/html 2019-01-27T11:30:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_missing_order?rev=1548606654&do=diff Missing Orders Severity Explanation of Error Possible Root Cause(s) Resolution * Check in the DBBrowser that the record is missing from ALL of the following tables: Adjustment Database, GL Database, Order Database, Order Details Database, and Order Modifiers Database, and Payments Database text/html 2019-01-27T11:30:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_modifier_already_in_use?rev=1548606654&do=diff Explanation Explaination This is caused by a duplication in the AV Database Resolution * Have customer show you the Modifier that has the issue * Look in Modifier list to see if they already have a modifier with a duplicate Modifier Code (e.g. text/html 2019-01-27T11:30:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_record_locked_by_another_user?rev=1548606655&do=diff SMS Error - Record Locked by Another User Error Message Can not edit record. Record Locked by Another User. Explanation of Error When you edit some records, SMS creates a temporary copy of the record (with a negative ID) so that it can work with it without changing the original copy. This error indicates that you are trying to do something that would place the record into edit mode, but there is already a temporary working copy of the record. SMS interprets this to mean another user (or win… text/html 2019-01-27T11:30:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_rpc_server_is_unavailable?rev=1548606655&do=diff SMS Error - RPC Server is unavailable Error Message Explanation of Error Severity Normal. User is not down. Possible Root Cause(s) Resolution * Open control panel in windows, and locate “administrative tools”. * Double click on “services text/html 2019-01-27T11:30:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_stream_read_error?rev=1548606656&do=diff Error Message Stream Read Error Explanation of Error When attempting to launch Cyrious SMS the loading halts just after the “Loading Reports...” and an error appears notifying you of a Stream Read Error. Severity High. The user is unable to load the program until resolved. text/html 2019-01-27T11:30:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_table_or_field_missing?rev=1548606656&do=diff Explanation This is just some corruption in the database. Usually, rebuilding will fix this issue. In some cases, the Table or Field needs to be recreated. Resolution * dbrebuild * If that does not resolve issue, contact Cyrious Tech Support to recreate the missing Table Or Field from a backup text/html 2019-01-27T11:30:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_unable_to_connect_to_system_database?rev=1548606656&do=diff SMS Error Error Message Unable to connect to one of the system databases. Explanation of Error This Error happens when the SMS client cannot connect to either of the Access System Databases (SMSSystemData.mdb, SMSStoreData.mdb and SMSSystemConfig.mdb). These databases holds the menus, reports, security rights, and other key information used by SMS. text/html 2019-01-27T11:30:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_unable_to_locate_all_reports_template_menu?rev=1548606656&do=diff Explanation This is caused by corruption in an .mdb file Resolution * Renamed the Customer's SMSStoreData.mdb file * On Cyrious14 navigate to the Implementation folder and select the SMS folder * Choose the appropriate version * Choose the appropriate franchise or independent folder text/html 2019-01-27T11:30:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_unknown_internal_operating_system_error?rev=1548606657&do=diff Explanation This error usually indicates a bad BDE install or a corrupt BDE. Also a possibility that not all of the language drivers are installed. Procedure/Walk-Through 1 * Open the Registry. * Click Start. * Click Run. * Type in Regedit and hit Enter. text/html 2019-01-27T11:30:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_error_-_unknown_internal_os_error_bad_file_number?rev=1548606657&do=diff Explanation Indexes are out of sequence or corrupted Resolution * dbrebuild text/html 2019-01-27T11:30:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_estimate_entry?rev=1548606657&do=diff Severity Normal. User has to enter the information to create a new Estimate Procedures * Click on New Estimate. * On the Company tab select Company for Estimate. * On the Items Tab, select the Line Items that are to be on the Estimate. * text/html 2019-01-27T11:30:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_explorer?rev=1548606658&do=diff Overview This page contains information relating to Cyrious Explorer, a search and lookup feature within Cyrious responsible for locating and accessing orders, estimate, companies, etc. Documented Issues * issue_-_unable_to_scroll_in_explorer text/html 2019-09-25T10:50:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_how-to_export_a_product_list_into_excel?rev=1569423009&do=diff Question How do I export a list of products into excel for viewing? Answer Cyrious does not support the ability to export products into an excel list within the program. There is an alternative solution that relies on a SQL query to export the data into an excel format. You will download and execute this query on the server for Cyrious, once executed you will have the opportunity to export the data into excel. text/html 2019-01-27T11:30:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_in_windows_8?rev=1548606658&do=diff Question How do I disable UAC in Windows 8? Answer To disable UAC in Windows 8 Professional: * From the Desktop, press Windows Key + R to access the RUN dialogue. Type 'GPEdit.msc' into the form and click 'OK'. * In the Local Group Policy Editor window edit the Computer Configuration by selecting the follwing items in order: text/html 2019-01-27T11:30:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_install_hasp_drivers?rev=1548606659&do=diff SMS Install HASP Drivers SMS Install HASP Drivers Things required to install * If necessary, download new drivers from Aladdin HASP4 Drivers. Download the file to C:\Program Files\Cyrious\Common\HASP. Note for Cyrious Techs: For SMS 2000 use HASP drivers located in text/html 2019-01-27T11:30:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_installation?rev=1548606659&do=diff =Notes= SMS 8.5 and below will not run on Vista, Windows 7, or later operating systems. Only versions SMS 8.6 and higher support these operating systems. =Installation Links= * sms1_-_sms_server_installation * sms1_-_sms_client_installation * sms1_-_sms_server_swap =Additional Installation Wiki Pages= * sms_-_configuring_multiple_store_databases * crystal_reports_driver_installation * borland_registry_installation * text/html 2019-01-27T11:30:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_invoice_shows_voided?rev=1548606659&do=diff Explanation Usually caused by either corruption or a conversion of a customer, where the Primary and Collections contact info is lost or never entered. Resolution * Navigate to the Company. * Select the Contacts tab. * Make sure Primary and Collections contacts are present. text/html 2019-01-27T11:31:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_issue_-_constant_db_corruption?rev=1548606660&do=diff Issue Repeated/Frequent Database Corruption Explanation of Issue Some users experience a repeated problem with database corruption. This can be caused by inconsistent connections to the network. Severity Normal. User is not down though repeated nature of problem is frustrating. text/html 2019-01-27T11:31:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_manual_client_installation?rev=1548606660&do=diff [[toc|toc]] Things Requried to Install * Crystal Reports zip Files (see crystal_reports_driver_installation) * Name of the Cyrious server (aka Main Cyrious computer, Master) Installation * Create a shortcut for Cyrious SMS on the client desktop. * Click Start. * Click on text/html 2019-01-27T11:31:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_manual_client_installation_or_remap?rev=1548606660&do=diff [[toc|toc]] Things Requried to Install * Name of the Cyrious server (aka Main Cyrious computer, Master) Installation * Right click on the Cyrious short-cut * Rename Target and Start in with the new server name * Click Save * Open the Registry text/html 2019-01-27T11:31:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_order_entry?rev=1548606661&do=diff General Issues * Entering the Order * From the Home screen Click on the New Order button. * You will next need to fill in the information under the tabs in the new window that opens, which would include Company, Products, as well as any notes that you may have for this order. text/html 2019-01-27T11:31:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_order_entry_-_how_to?rev=1548606661&do=diff How To how_to_unvoid_an_order sms_order_entry text/html 2019-01-27T11:31:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_payment_entry?rev=1548606661&do=diff How-To's How Do I's * how_do_i..._issue_a_customer_credit * how_to_void_a_payment text/html 2019-01-27T11:31:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_pricing?rev=1548606661&do=diff SMS Pricing By Subject * how_do_i_duplicate_the_pricing_from_another_location * how_to_set-up_product_categories_-_fii text/html 2019-01-27T11:31:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_printing?rev=1548606662&do=diff SMS Printing/Email Errors This page contains common SMS Printing Errors. Common SMS Printing/Email Problems * crystal_related_problems * windows_related_problems * printer_driver_related_problems * sms_configuration_related_problems * socket_errors * royalty_report_wont_print * operation_aborted * printing_extra_blank_page * cant_print_sales_report_sales_tax_report_or_export_accounting_data * invoice_and_logo_missing_when_printing_invoices_estimateswork_orders * starttls… text/html 2021-11-17T17:26:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_query_to_rebuild_contacts_from_order_information?rev=1637187974&do=diff Explanation of SQL This SQL will insert any missing contacts in the “Contact Database” using information found in the Order and Estimate tables. Risk of Data Corruption if Run Improperly High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL text/html 2019-01-27T11:31:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_sql_-_delete_unused_products_and_prep_product_set_for_import_of_new_products?rev=1548606662&do=diff Explanation of SQL Routinely users will want to clean up their set of products within SMS, in some cases over years of working with SMS it is not uncommon for there to be 200+ products in the system. Users often want to clean up their products by removing all old products and importing a new set. text/html 2019-01-27T11:31:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_sql_-_insert_memo_fields_from_backup_into_order_and_estimate_tables?rev=1548606663&do=diff Explanation of SQL This SQL statement will take fields from one database table then fields from another database table and combine them into a single temporary table. You can then utilize that temporary table to insert the combined data into a new set of database tables and indexes. text/html 2019-01-27T11:31:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_supplemental_program_errors?rev=1548606664&do=diff * this_application_has_failed_to_start_because_vcl50.bpl_was_not_found * when_running_the_product_importer_getting_directroy_controlled_by_another_.net_file text/html 2019-01-27T11:31:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_support?rev=1548606664&do=diff This page is the master “index” of WIKI articles for SMS. The information is arranged in several formats. You may navigate using the Table of Contents on the right, or by typing Control-F and searching for specific text. By Tier This organization of issues is arranged based on the Tier-designation used internally by Cyrious Software for their support technicians. A Tier-1 issue is well understood and the steps to repair it are straight forward. A Tier-2 issue is generally less common, present… text/html 2019-01-27T11:31:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_unable_to_backup_database_before_upgrading_to_v8.9?rev=1548606664&do=diff Explanation V8.9 requires a backup of the database before installation can proceed. For whatever reason, the path is missing from the Options.ini file in the Data folder Resolution * Navigate to the Data folder * Open the Options.ini file * Paste in the following information: text/html 2019-01-27T11:31:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_unable_to_open?rev=1548606664&do=diff Error Messages * unable_to_locate_sslip_server * unable_to_open_application_database._could_not_use_file_already_in * database_connection_failed_..._not_a_valid_path * invalid_operation_error * invalid_variant_operation_error * error_10048_in_function_bind_address_already_in_use * no_active_index * security_device_found_but_not_authorized_for_the_program_terminating * security_device_found_but_not_authorized_for_the_program_terminating * error_loading_collection_reportmenute… text/html 2019-01-27T11:31:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_upgrade_instructions?rev=1548606665&do=diff Question How do I upgrade my version of SMS? Answer All program updates are available on the Cyrious Customer Website located at <http://www.cyrioussoftware.com>. To download those updates please follow the steps below. * Visit <http://www.cyrioussoftware.com> * Log into the website with their username and password, if you do not know your password click the link text/html 2019-01-27T11:31:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sms_v2000?rev=1548606665&do=diff * sms_2000_server_installation * sms_2000_client_installation * ctrlservr.exe_not_in_the_pos * paradox_errors_in_sms_v2000 * file_gcr_not_found * security_device_cannot_be_found_system_is_running_in_demo_mode_an_is_not_reconizing_key * sms_error_-_invalid_file_name * upgrade_from_v2k_to_v8_action_sheet * dbrebuild_opens_but_shuts_down_when_verifying * issueing_a_demo_override_code text/html 2019-01-17T09:21:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/socket_errors?rev=1547734877&do=diff ={$page}= Explanation Socket Errors are messages sent from the mail server on why the mail server is refusing connection to send an email. List of codes for failure to connect Socket error 10004 - Interrupted function call Socket error 10013 - Permission denied text/html 2019-01-17T09:21:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.category_summary?rev=1547734878&do=diff How-To's * Control - How-To xxx How Do I's * Control - How Do I ... xxx text/html 2019-01-17T09:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.control_sql_statement?rev=1547734879&do=diff Explanation of SQL Risk of Data Corruption if Run Improperly None. This is a selection query and no data is modified in the running of it. or High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL text/html 2019-01-17T09:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.control_support_issue?rev=1547734879&do=diff Error Message Explanation of Error Severity High/Normal/Low. User is/is not down. Possible Root Cause(s) Resolution Version Information * Reported : //20__ * Version(s): * Fixed in : See Also * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.default?rev=1547734879&do=diff ={$page}= Explanation See Also * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.general_information?rev=1547734880&do=diff Question Answer Version Information * Version(s): text/html 2019-01-17T09:21:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.sms_support_issue?rev=1547734881&do=diff Error Message Explanation of Error Severity High/Normal/Low. User is/is not down. Possible Root Cause(s) Resolution Version Information * Reported : //20__ * Version(s): * Fixed in : text/html 2019-01-17T09:21:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.sms_tier_1_actions?rev=1547734881&do=diff =Error Message= =Explanation of Error= =Severity= High / Low =Tier 1 Actions= * Close all copies of SMS and the SSLIP * Check Computer Management to confirm that no files in the ..\Cyrious$\SMS hierarchy are open. If they are, close them. text/html 2019-01-17T09:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.sms_tier_2_actions?rev=1547734882&do=diff =Condition / Cause= This WIKI applies when .... =Explanation of Process= .... Notes: * Existing users do / do not need to exit for these actions to be run. * Always backup first! Running a SQL query is a powerful tool and a misplaced comma can result in data loss. text/html 2019-01-17T09:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.sslip_support_issue?rev=1547734882&do=diff ={$page}= Error Message Explanation of Error Severity High/Normal/Low. Users are/are not down. Possible Root Cause(s) Resolution Version Information * Reported : //20__ * Version(s): * Fixed in : See Alos * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/space.template.support_summary_page?rev=1547734882&do=diff Overview Common SMS|Control Problems * xxx_error_-|xxx Error - * xxx_error_-|xxx Error - text/html 2019-01-17T09:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/split_multiple_lines_of_text_into_seperate_columns?rev=1547734883&do=diff Question How do I split multiple lines of text into seperate columns within Excel? Answer There are a couple different methods for splitting the text, 2 of the most common are listed below. Using Data | Text to Columns * Open Your Excel Document text/html 2019-01-17T09:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sql_query_to_rename_a_sql_server_instance?rev=1547734883&do=diff Explanation Sometimes you will encounter a pre-installed copy of SQL server that does not have an instance name setup, thus it makes it difficult to get the SSLIP to interact with the server. To rectify this, you will rename the instance to something recognizable, preferably CYRIOUS text/html 2019-01-17T09:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sql_recovery_when_the_database_is_corrupted?rev=1547734883&do=diff Question How do I recover or repair the database if it ever becomes corrupted? Common Causes of Corruption * Sudden shutdown of computer, typically due to power loss or other cause. * Failing hard drive in the computer or bad sectors on the drive. text/html 2019-01-17T09:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sql_server_-_dbcc_checkdb?rev=1547734883&do=diff Question What are the commands to reindex, rebuild, or check the SQL database for Errors? Answer SQL Server has a built-in set of functions that allow you to perform tasks to check and repair the overall integrity of the SQL database. There are many different functions available, refer to the reference links listed below for additional information. text/html 2019-01-17T09:21:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/ssl_provider_when_starting_sql_server?rev=1547734884&do=diff SSL Provider error when starting SQL Server Error Message A connection was successfully established with the server, but then an error occurred during the pre-login handshake. ) provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server) text/html 2019-01-17T09:21:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sslip_freezes_at_checking_for_another_server?rev=1547734884&do=diff Explanation of Error When attempting to launch SSLIP, the mdb files are corrupted or not accessible preventing opening Severity High User is down on all of the affected machines because with no connection to the SSLIP you can not run Cyrious SMS. text/html 2019-01-17T09:21:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sslip_support?rev=1547734884&do=diff SSLIP Support By Subject By Type of Error/Problem * Unable to locate SSLIP Server * Unable to locate SSLIP Data * Unable to find registry entries * error_-_not_authorized_for_this_application * error_-_sslip_needs_to_close_sorry_for_any_inconvience * SSLIP will not open - no error messages * sms_8.5_sslip_needs_a_keyless_file Customizing Cyrious SSLIP * can_the_sslip_be_run_as_a_service text/html 2019-01-17T09:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/sslip_will_not_open_-_no_error_messages?rev=1547734885&do=diff SSLIP will not open - no error messages For SMS and pre-CHAPI Control : If the SSLIP flashes on screen briefly and then closes, this usually indicates an issue with the license. Either the license dongle needs to plug back in or the license.ckf file is corrupt or missing from the SSLIP folder. text/html 2019-01-17T09:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/starttls_error?rev=1547734885&do=diff ={$page}= Explanation STARTTLS is an extension to plain text communication protocols, which offers a way to upgrade a plain text connection to an encrypted (TLS or SSL) connection instead of using a separate port for encrypted communication. Resolution text/html 2019-01-17T09:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/startup_folder_in_windows_8_and_windows_server_2012?rev=1547734885&do=diff Find the Startup Folder in Windows 8 or Windows Server 2012 Explanation The Startup folder is hidden by default in Windows 8 and Windows Server 2012. Solution 1 Open the Windows Run dialog by using the Windows Key + R key combination. Type %AppData% text/html 2019-01-17T09:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/statement_not_pulling_any_info?rev=1547734885&do=diff Resoluton * Navigate to that customer's record * Navigate to the Contacts tab * Click the Edit button * Select a contact to be the Primary Contact and Collections Contact if none is selected text/html 2019-01-17T09:21:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/statement_not_selecting_the_ap_contact_for_emailing?rev=1547734886&do=diff Explanation When originally designed, SMS would by default always select the Primary Contact. This is not an issue with the report. Resolution * Upon release, upgrade to SMS V8.9 * Open up a company * Select to print the statement * In the Report Criteria, click the Show Details under the Email Options text/html 2019-01-17T09:21:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/statement_printing_all_statement_notes?rev=1547734886&do=diff Resolution * Navigate to the Company * Select the Financial tab * Click edit * Click credit Account Open * Select Payment Term from the Drop Down List text/html 2019-01-17T09:21:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/statement_pulling_incorrect_info?rev=1547734886&do=diff Resolution * Check to ensure customer has payment terms and not null * Check Payment Terms for the correct grace period * Ensure that there is not another Customer with a duplicate name * If it does, rename customer * Run Statements to ensure it corrects issue text/html 2019-01-17T09:21:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/steps_to_setup_cyrious_for_automated_backups_-_sms_v8.6_and_higher?rev=1547734887&do=diff ={$page}= sms_backup_database_set-up_v8.6_and_higher See Also * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/store_logo_appears_but_is_not_the_correct_image?rev=1547734887&do=diff Issue This can happen if Production Terminal has a cached copy of your Store Logo that it is unable to update or unaware that it is out of date. Resolution Confirm Proper Settings for Production Terminal * From the server, locate the path to the Production Terminal install folder. text/html 2019-01-17T09:21:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/store_logo_specifications?rev=1547734887&do=diff Question What is the optimal size for my company logo in Control? Answer Very high quality images take a considerable amount of time to send to the printer and can dramatically slow printing. For this reason, Control resizes the image to a size that is appropraite for the size allocated to the logo on system reports. text/html 2019-01-17T09:21:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/stream_write_error?rev=1547734887&do=diff Explanation A “stream” is generic term for information coming in (Read Stream) or going out (Write Stream). This can be from various source (Memory = DataStream, Network = TCPStream), but the most common problems are found around reading and writing files (FileStream). text/html 2019-01-17T09:21:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/stream_write_error_whenever_performing_backup_in_control?rev=1547734888&do=diff ={$page}= Error Message “Stream Write Error” whenever performing backup in Control Explanation of Error There is not enough space on the local drive or the drive the path is set to back up the data to. Severity Normal. Users are not down but can't back their system to the local drive. text/html 2019-01-17T09:21:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/summary_of_wiki_formatting_commands?rev=1547734888&do=diff {$page} Commonly used WIKI markup codes ... Text Formatting Meaning Text Code Heading 1 ``heading 1`` Heading 2 `` heading 2`` Heading 3 `` heading 3`` Bulleted List ``* List`` `` SubList`` || || Numbered List || ``# numbered`` || || Bold || `` text/html 2019-05-22T18:23:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/support_department_policies?rev=1558563788&do=diff Support Department Policies Mandatory Overtime Mandatory Overtime is necessary at times to meet the needs of our customers. When Control queue is above zero. * When closing for the day, if the queue is not zero all techs will be required to work overtime the next day. text/html 2019-05-22T17:06:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/support_how_do_i_recover_a_database_when_the_ldf_log_file_is_lost_or_corrupted?rev=1558559208&do=diff Issue A sql database generally has at least two files, a .mdf (data) file and a .ldf (log) file. Databases can have more than 1 of each of these files but for Control there are always two files unless a user manually created some additional ones themselves. At times when dealing with corruption of databases or possibly a mishap with transferring the physical database files you end up losing the .ldf (log) file for the database and are now left with a database you can not attach or utilize in an… text/html 2019-01-17T09:21:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/support_schedule?rev=1547734888&do=diff Technical Support Schedule Cyrious Technical Support is open: * 7:30 am through 7:00 pm CST (GMT-6). * Monday - Friday excluding the following US Holidays: * New Years Day * Good Friday * Memorial Day * Independence Day (July 4th) * text/html 2019-01-17T09:21:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/support_services_taxability?rev=1547734889&do=diff Question We are often asked to explain if/why Cyrious support services are taxable. This WIKI page attempts to do that and gather the reasoning in one place. Answer Taxability of technical support is governed by several considerations. These include: text/html 2019-05-22T15:51:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/support_sql_recovery_when_the_database_is_corrupted?rev=1558554705&do=diff SQL Recovery when the database is corrupted How do I recover or repair the database if it ever becomes corrupted? Common Causes of Corruption * Sudden shutdown of computer, typically due to power loss or other cause. * Failing hard drive in the computer or bad sectors on the drive. text/html 2019-01-17T09:21:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/systemreportmenuitem_error_message?rev=1547734889&do=diff SystemReportMenuItem is expecting to be at X but is set to X-1 Unable to locate SystemReportMenuItem text/html 2019-01-17T09:21:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/systemreportmenuitem_is_expecting_to_be_at_x_but_is_set_to_x-1?rev=1547734889&do=diff Description The SMSSystemData does not match what is expected from the SMSSystemConfigData. Explanation In order to know if a table is at the current version, Cyrious creates a record in each table to store the table version. The ID of this record is -1 and the version of the table is stored as the ClassTypeID. Each time a table is updated in the program, the latest version is updated. text/html 2019-01-17T09:21:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tax_reporting?rev=1547734890&do=diff Question How do I use Cyrious for cash based tax reporting? Answer * Cyrious is an accrual based system for accounting not cash based. There is not a cash based tax report in Cyrious. * Cyrious does have a sales tax on closed report that shows all taxes on order that have been fully paid and closed in that period. text/html 2019-01-17T09:21:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tbdetail_dataset_not_in_edit_or_insert_mode?rev=1547734890&do=diff ={$page}= Explanation This is usually corruption in the database Resolution * dbrebuild * If that does not work, contact Cyrious Tech Support See Also * Backlinks include page="{$page}" component="backlinks" text/html 2020-11-06T16:25:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tech_checklist?rev=1604697938&do=diff Test text/html 2020-11-06T16:28:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tech_checklists?rev=1604698106&do=diff Tech Checklists This page is a reference to our tech checklists. These are to be used as guick guides when troubleshooting. These lists to no have detailed steps. When adding a checklist please be sure to include a link to the wiki that does containt he detailed steps. text/html 2019-05-22T18:25:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tech_reference?rev=1558563945&do=diff Tech Reference Status IDs Transheader.StatusID Orders 0 = New 1 = WIP 2 = Built 3 = Sale 4 = Closed 6 = Open 9 = Voided Estimates 11 = Pending 12 = Lost 13 = Converted 14 = Voided 20 = Credit Memo 21 = Recurring Order 21 = Template text/html 2019-01-17T09:21:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/telephone_support_information?rev=1547734890&do=diff Telephone Support Information You can reach Technical Support by dialing any of these numbers: * 888-552-9823 (North America) * 225-752-2867 include component="page" wikiName="support" page="support_schedule" wrap="1" =Email= * mailto:supportcyrious.com Emergency Off-Hours Support Information Emergency Off-Hours support is available if needed. text/html 2019-01-17T09:21:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/the_drive_or_network_connection_that_the_shortuct_cyrious_control.ink_refers_to_is_unavailabe?rev=1547734890&do=diff Error Message The drive or network connection that the shortuct 'Cyrious Control.Ink' refers to is unavailabe Explanation of Error This message is informing you that Windows can't access the file/program specified by the shortcut you are running. This usually means the connection to the server is not accessible or that the shortcut is not pointing to a valid location. The connection could be invalid because: text/html 2019-01-17T09:21:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/the_parameter_is_incorrect?rev=1547734891&do=diff Error Message * The parameter is incorrect Explanation of Error * The current user machine can not open Cyrious because a parameter in the form position is not correct. Severity High User is down on the affected machines because you can not run Cyrious SMS. text/html 2019-01-17T09:21:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/the_specified_procedure_could_not_be_found?rev=1547734891&do=diff ={$page}= Explanation This is caused by Cyrious trying to call to another application, executable or dll. Depending on where in the opening process the error message pops-up. Resolutions Resolution: Error at Launching SMS If this error occurs at start-up, it could be while the Home Page is being created. We have seen this when creating the text/html 2019-01-17T09:21:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/this_application_has_failed_to_start_because_vcl50.bpl_was_not_found?rev=1547734891&do=diff Explanation When attempting to execute a compiled SQL query, you receive the following error message “This application has failed to start because Vcl50.bpl was not found. Reinstalling the application may fix this problem.” You will also get this error message when running certain utilities in the Utilities folder text/html 2019-01-17T09:21:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/this_version_of_sms_has_expired?rev=1547734892&do=diff Explanation Resolution * NM * Copy current executable from FTP * Paste to the SMS folder * Open Cyrious Resolution 2 If you receive this message on a specific computer, however other computers appear to load Cyrious SMS without any complications, verify the following. This problem occurs frequently with International locations due to the default setting on new computer systems being set to a U.S. Standard Timezone. text/html 2019-01-17T09:21:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tier1_-_configure_sslip_firewall?rev=1547734892&do=diff Explanation SMS and Control clients access the SSLIP using two ports, UDP 2868 and TCP 2879.If the PortOffset option is used, the port offset it added to these numbers and the correct ports are UDP (2868+Offset) and TCP (2879+Offset). However, the user of a Port offset prevents the use of the Client Launcher and causes other problems and text/html 2019-05-23T18:26:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/tier_2_issues_workspace?rev=1558650362&do=diff Frequently Used Links Daily Tech Briefing Department Links Tech Tool Links Control Release NotesSupport Dept. PoliciesGetting a Copy of a Customer's DatabaseSMS Release Notes 8.91Tech ReferenceUsing the Order Export ReportControl Wiki ChangesSQL Queries to Identify ProblemsCreate a Backup of a Single TransactionSMS Wiki ChangesModule AuthorizationSSLIP Startup Options ListBug Search Cahoots Recent Issues Recent Issues Accounting Unable to Save PDF or Corrupted PDF When EmailingUnable to Emai… text/html 2019-01-17T09:21:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/transaction_id_not_orig_pnref_required?rev=1547734893&do=diff Transaction ID Not Found / Orig PNRef Required Error Message Transaction ID Not Found / Orig PNRef Required Explanation of Error Attempting to post a refund or void settled credit card payments using Merchant Warehouse, this error will appear if the user's account is set to require the PNRef for refunds. The option is on the Merchant Warehouse account and can be changed by MW. text/html 2019-01-17T09:21:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/transaction_log_not_shrinking?rev=1547734893&do=diff We have run into cases where the SQL Server transaction log would not shrink. This could be caused by a few things. Logging Mode (Note: The exact steps might vary slightly based on the version of SQL you are running.) * Open SQL Management Studio text/html 2019-01-17T09:21:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/transaction_split_line_to_ar_must_include_a_customer_on_that_split_line?rev=1547734893&do=diff Explanation This error message usually indicates that Quickbooks is using the default Accounts Receivable account. In order for the accounting import from Cyrious to work, a custom Accounts Receivable account needs to be created. Resolution * In QuickBooks, edit the Accounts Receivable account name inside of the text/html 2019-01-17T09:21:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/type_mismatch_in_expression?rev=1547734894&do=diff ={$page}= Explanation This can be caused by a number of issues in Windows set-up preventing Cyrious from pulling a query Possible resolution * Navigate to the Windows Regional settings * Ensure that the short date is set to yyyy/mm/dd or dd/mm/yyyy - it can text/html 2019-01-17T09:21:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_find_regestry_entries?rev=1547734894&do=diff Error Message * Unable to find registry entries \software\ cyrious software\SSLIP\Systemdata. Explanation of Error * This error message is telling you that the current file of the SSLIP\Systemdata can not be found when it is running the process in SSLIP in essence it is missing the Sytemdata file, or it just can not find it. text/html 2019-01-17T09:21:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_find_registry_entries?rev=1547734894&do=diff Error Message * Unable to find registry entries \software\ cyrious software\SSLIP\Systemdata. Explanation of Error * This error message is telling you that the current file of the SSLIP\Systemdata can not be found when it is running the process in SSLIP in essence it is missing the Sytemdata file, or it just can not find it. text/html 2019-01-17T09:21:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_find_the_data_path_when_doing_a_rebuild?rev=1547734895&do=diff Problem Unable to select a database when using the DBRebuild utility. The select button is in a disabled, grayed out state. Severity High. You can not do a database rebuild with out the UDP(UtilityDataPath) being set up properly. Possible Root Cause(s) text/html 2019-01-17T09:21:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_locate_sslip_data?rev=1547734895&do=diff Error Message “Unable to locate SSLIP Data” when starting the SSLIP. Explanation of Error Older versions of the SSLIP read the location of the SSLIP database and System databases from the users registry (HKCU). As of SMS V8.9 and Control 4.0, these entries are not necessary unless you want to change the default behavior of the SSLIP. text/html 2019-01-17T09:21:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_locate_sslip_server?rev=1547734895&do=diff Error Message Unable to locate SSLIP server. A copy of the SSLIP server must be running in order to login. Socket Connection Error: Connection Timed out Would you like to retry? Explanation of Error When attempting to launch Cyrious an error appears as outlined below. The SSLIP is responsible for providing all users of Cyrious will database connection information, report information, sequencing of database table records, licensing, etc. This error typically appears if the Cyrious SSLIP on… text/html 2019-01-17T09:21:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_locate_sslip_server_on_the_vm?rev=1547734896&do=diff Explanation This is usually caused by one of 2 things. Either the computer hasn't finished opening the Virtual Machine and the SSLIP or the SSLIP failed to open when the VM finished starting. Resolution 1 * Give your computer a few more minutes to finish opening the VM and the SSLIP text/html 2019-01-17T09:21:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_locate_sslip_server_vm?rev=1547734896&do=diff Explanation This is usually caused by one of 2 things. Either the computer hasn't finished opening the Virtual Machine and the SSLIP or the SSLIP failed to open when the VM finished starting. Resolution 1 * Give your computer a few more minutes to finish opening the VM and the SSLIP text/html 2019-01-17T09:21:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_locate_systemreportmenuitem?rev=1547734896&do=diff ={$page}= Explanation This is caused by corruption in the SMSSystemConfig. Resolution 1 * Get everyone out of Cyrious * Close the SSLIP * Replace the SMSSystemConfig from a backup or give the customer a current one * Restart the SSLIP * text/html 2019-01-17T09:21:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_application_database._could_not_use_file_already_in?rev=1547734897&do=diff ={$page}= Explanation Unable to open application database. Could not use “; file already in use Resolution 1 * Log into the server * Correct the sharing and security settings, ensuring everyone is added Resolution 2 * Replace the BDE folder with a fresh BDE from the ftp text/html 2019-01-17T09:21:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_application_database._mulitiple-step_ole_db_operation_generated_errors._check_each_ole_db_status_value_if_available._no_work_was_done?rev=1547734897&do=diff ={$page}= Explanation Something has broken the link between the Cyrious program and the Cyrious data. Resolutions (SMS V8.60 Steps to fix (1) * Shut down Cyrious everywhere and close the SSLIP * Attempt to replace the MDB files from a backup. text/html 2019-01-17T09:21:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_application_database?rev=1547734896&do=diff Error Message When trying to login into SQL Server, the error message “Cannot connect to the instance (InstanceName). Configuration system failed to initialize (system configuration) Explanation of Error When you run Control, it references the SSLIP to gain access to the database which is located within SQL Server. If the instance which contains the database is inaccessible, the SSLIP would load it, and Control can't recognize it. text/html 2019-01-17T09:21:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_application_database_-_dbnetlib?rev=1547734897&do=diff Error Message Unable to open Application database. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied Explanation of Error The client computer is failing to initiate a successful connection to SQL Server. Severity text/html 2019-01-17T09:21:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_control_client_on_a_mac?rev=1547734898&do=diff Error Message 1 On start-up on a MAC parallels system, Control fails with its own, non-descript error message. Error Message 2 Unable to locate SSLIP Server Explanation of Error During start-up, Control and the SSLIP check their respective times to ensure they are in sync. If not, the Control user is prompted to reset their local time. Some part of that process is failing on the Mac Parallels system. If the time on the SSLIP is different, Control crashes with no explanation. text/html 2019-01-17T09:21:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_ms_outlook?rev=1547734898&do=diff Error Message Unable to Open MS Outlook : (Server execution failed, ProgID: “Outlook.Application”) Severity Low. User is able to continue working in the software. Explanation of Error User Account Control (UAC) is blocking the software from trying to use MS Outlook. text/html 2019-01-17T09:21:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_open_or_login?rev=1547734898&do=diff Unable to Open.cyriouswiki.com/login_control the_drive_or_network_connection_that_the_shortuct_cyrious_control.ink_refers_to_is_unavailabe security_device_expired unable_to_open_application_database unable_to_open_application_database_-_dbnetlib unable_to_open_control_client_on_a_mac text/html 2019-01-17T09:21:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_preview_report_xxxx._logon_failed._details_database_vendor_code_556_crystal_report_report_file_path_to_report_file?rev=1547734899&do=diff Explanation Unknown at this time. However we have had success resolving this issue by uninstalling and reinstalling Crystal Reports on the system displaying the issue. Resolution * Uninstall Crystal Reports from Programs and Features * Reinstall Crystal Reports using the Client Launcher text/html 2019-01-17T09:21:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_print_2nd_copy_of_report_-_error_or_garbled_characters?rev=1547734899&do=diff Explanation of Issue Unable to print 2nd copy of a report you have selected. We have seen issues with certain print drivers on computers display errors on the 2nd copy of a printout, there seems to be an issue with the print driver understanding the crystal report has requested multiple copies of the same report. text/html 2019-01-17T09:21:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_print_from_rdp?rev=1547734899&do=diff Problem Unable to print from any application from an RDP client session to a locally installed HP Printer. It appears to print but is never seen in the print spooler. Specfic HP models are not compatible with printing from RDP sessions (more info below). text/html 2019-01-17T09:21:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_resize_the_field_elementname?rev=1547734899&do=diff Explanation Can not modify the design of table 'ReportElement'. It is a read only database. Resolution * First try replacing the SMSSystemData.mdb * If that does not work, check Sharing and Securities * Ensure that Everyone has full control in Permission. text/html 2019-01-17T09:21:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_save_pdf_or_corrupted_pdf_when_emailing?rev=1547734900&do=diff Explanation This issue is caused by an automatic update from Windows KB3102429 which causing issues with any Arial fonts utilized on Crystal Reports. This is a wide-spread problem that is affecting all computer systems and users of Crystal Reports and is not unique to Cyrious Control or SMS. Reinstalling the Arial fonts will correct this issue. text/html 2019-01-17T09:21:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unable_to_save_report_as_pdf?rev=1547734900&do=diff Error Message Error saving report “Filename” to file C:\Users\......\filename.pdf Failed to export the report. Crystal Report Report File: Filename.rpt Explanation of Error Unable to save report as PDF. This may happen on one report but not others. text/html 2019-01-17T09:21:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/unimplemented_5.1.1?rev=1547734900&do=diff Explanation This error normally occurs when a customer has “authentication required” enabled under their outgoing mail settings and is not required. Resolution * Navigate to Mgmt>Set-Up>Set-Up User Options> * Select the Email Options tab * text/html 2019-01-17T09:21:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/updating_control?rev=1547734901&do=diff How-To's * control_-_updating_the_system_while_control_is_running * Upgrade to Control 4.4 * Attempting a add an invalid son type ERROR text/html 2019-01-17T09:21:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/upgrade_from_v2k_to_v8_action_sheet?rev=1547734901&do=diff ={$page}= Explanation Requirements for upgrading from V2K to V8 See Also * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/upgrade_sms_silver_or_gold_level_sslip_to_unlimited_users?rev=1547734901&do=diff ={$page}= Explanation Originally, SMS was limited to a certain number of users based on the level (except Platinum). There has been an update of the SSLIP to allow owners that have SMS at these level to purchase any number of users. Resolution * text/html 2019-01-17T09:21:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/upgrade_to_control_4.4?rev=1547734901&do=diff ={$page}=Upgrade to Control 4.4 Error Message None Severity Normal. User is down until the upgrade is completed(about 45min to an hour). Resolution * Copy C3S, Hast.rar, and the Control4.4rar to the Desktop. * Kill SSLIP, Kill any open sessions in control (stop SQL Server for additional security) text/html 2019-01-17T09:21:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/using_sp_who2_and_dbcc_inputbuffer_to_identify_problematic_sql_processes?rev=1547734902&do=diff This article is still in-progress! Explanation When Control / SQL performance degrades, often it can be the result of SQL processes that have become stuck or are blocking other processes from being completed. The Stored Procedure 'sp_who2' and management command 'DBCC InputBuffer' can be used to identify the specific T-SQL commands that are causing the problem. text/html 2019-01-17T09:21:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/utilities_support?rev=1547734902&do=diff Other Utilities gotomeeting_-_how_to_record_a_hosted_meeting text/html 2019-01-17T09:21:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/voiding_and_refunding_payments?rev=1547734902&do=diff text/html 2019-01-17T09:21:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/what_windows_fonts_does_cyrious_use_for_the_program_interface?rev=1547734903&do=diff Question What windows fonts does Cyrious use for the program interface? Answer * Arial * Courier * Courier New * Fixedsys * MS Sans Serif * Tahoma * Times New Roman * Verdana text/html 2019-01-17T09:21:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/when_running_the_product_importer_getting_directroy_controlled_by_another_.net_file?rev=1547734903&do=diff Explanation This is due to the fact that the registry for the server machine may be using the Local Drive Paths for the Database whereas the SSLIP may be using the UNC Paths, therefore, causing the conflict between the two programs... Resolution * text/html 2019-01-17T09:21:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/whenever_printing_anything_out_of_the_system_the_logo_resembles_a_big_black_box?rev=1547734903&do=diff Explanation If this is occuring on their printouts, this means that their logo is too big in file size for the system to handle correclty. Resolution * Need the logo file size to be no bigger than 50k in size. * If size of logo exceeds this amount, notify customer that they will need to shrink file size so that it's in the accepted range. text/html 2019-01-17T09:21:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/why_..._is_there_no_overpayment_field_when_applying_a_payment_in_control?rev=1547734903&do=diff Question Why is there no overpayment field when applying a payment in Control? Answer The overpayment field is optional for any payment method. For some payment methods (like cash) they are usually not wanted and removing the field helps prevent mistakes. To turn on the overpayment field for a given payment method, follow these steps: text/html 2020-11-06T15:05:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/wiki_formatting_guidelines?rev=1604693110&do=diff Control WIKI Guidelines This page provides recommended formatting guidelines when using a Control WIKI. Helpful Info * Wiki Formatting Syntax * Getting started tutorial Template Page Name Description Topic 1 - Item 1 - Item 2 Steps 1. Step 1 2. Step 2 See Also * Links [link to a relevant wiki] text/html 2019-01-17T09:21:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/windows_8_to_8.1_upgrade_concerns?rev=1547734904&do=diff WARNING - PLEASE READ PRIOR TO UPGRADING !!! When installing Windows 8.1, the option to keep “Windows settings, personal files and apps” requires that the Windows 8 system matches the system default UI language. In addition, The Windows 8 edition can only be upgraded to an equivalent or higher Windows 8.1 edition. text/html 2019-01-17T09:21:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/windows_64bit_pestartprint_error?rev=1547734904&do=diff ={$page}= Explanation Occasionally the standard crystal install fails to remove and relocate certain dll files. This should resolve the issue. Resolution * Install the Crystal 8.5 DLL files to the C:\WINDOWS\SYSWOW64\ folder. * Register the DLL to the C:\WINDOWS\SYSWOW64\ folder. Be sure you do not register them to the SYSTEM32 folder. text/html 2019-06-13T17:21:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/windows_how_to?rev=1560460881&do=diff * How To - Kill an Application or Process Without Task Manager * How To Recreate Administrator User or Other User * How To - Recreate Lost Logons in Windows * How To - Share Cyrious Versions 8 and Up text/html 2019-01-17T09:21:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/windows_related_problems?rev=1547734905&do=diff ={$page}= MS\Windows related printing/Email problems * sms_error_-_rpc_server_is_unavailable * sms_error_-_class_not_registered * stream_write_error * type_mismatch_in_expression See Also * Backlinks include page="{$page}" component="backlinks" text/html 2019-01-17T09:21:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.cyriouswiki.com/windows_sandbox?rev=1547734905&do=diff ={$page}= Explanation Windows 7 can be very restrictive towards applications written for the previous versions of Windows. This is the case with the Borland Database Engine (BDE), which is not capable of running in Windows7 unless two settings have been changed: