This is the two-character language code you want to use by default for all users (e.g. EN, FR, ES, DE, ZH).

This lets you save and print inventory notes against stock items in up to 80 languages.

Any existing stock code narrations (i.e. narrations saved in your database with spaces against the language field) are then labeled as Global Notes.

The global narrations print by default when printing documents (if you don't select the Print Foreign Text option).

If the Multi-language for document printing option is enabled, then you can select the Configure List hyperlink to select up to 80 language codes that you want to use within the system for multi-language document printing.

This indicates the nationality of your site.

Entering one of the reserved nationality codes (i.e. CAN, USA, AUS, RSA, UK) affects the display of certain fields (e.g. tax-related) within the system.

This ensures that characters are rendered correctly when using SYSPRO Reporting Services.

This is used by support personnel to identify your site.

This is used to output a script or text file in the \Base\Settings folder to monitor and debug problems in e.net or SQL environments.

This lets you place the entire system into maintenance mode and prevent unauthorized access to all companies in your environment while conducting maintenance. It solves the issue of having to maintain each SYSPRO company to prevent operators from capturing data in SYSPRO or e.net Solutions when you're conducting maintenance (e.g. upgrading to a new release).

The login process checks this configuration before the company-specific maintenance mode to either allow or deny access to the system.

Indicate the message to display to any unauthorized operator attempting to access the company during the maintenance period.

This logs a record when the number of SYSPRO licenses used reaches the value set in the Log within x users of maximum field.

This lets you indicate the point at which you want to record a log entry for SYSPRO license limits.

The log entry created is: Login attempted - license limit approached and is output to the System Audit Query program.

This lets you log a record when the number of CMS only users reaches the value set against the Log within x CMS users of maximum field.

This lets you indicate the point at which you want to record a log entry for CMS only user license limits.

The log entry created is: Login attempted - CMS license limit approached and is output to the System Audit Query program.

This lets you configure system-wide license parameters.

Changes are validated as part of the registration mechanism and will require you to update the license registration details for each company.

This indicates the maximum number of companies that can be used concurrently on a site.

An entry of 0 means that up to 36 companies may be defined for this system.

This indicates the number of Contact Management users allowed to run the system concurrently.

• Denoted by IMPCMO= in the IMPACT.INI file.

This indicates the number of Point of Sale users allowed to run the system concurrently.

• Denoted by IMPPOS= in the IMPACT.INI file.

This defines the maximum number of users that may access the Universal Data Dictionary concurrently via ODBC. You won't be allowed to make any changes to the dictionary.

• Denoted by IMPODB= in the IMPACT.INI file.

This defines the maximum number of users that may be running the U/SQL Manager concurrently.

An entry other than 0 indicates that you intend modifying the Universal Data Dictionary (UDD) using the U/SQL Manager software.

• Denoted by IMPUSQ= in the IMPACT.INI file.

This indicates the number of Dialog System seats you have purchased (if you purchased the Micro Focus Dialog System), which allows you to customize screens using the Screen Customization Kit.

This indicates the number of Client Access Licenses (i.e. SQL Server seats) as defined by Microsoft that matches your license information.

• Denoted by IMPCAL= in the IMPACT.INI file.

This indicates the maximum number of users who may access the SYSPRO Analytics Viewer concurrently.

• Denoted by IMPSVS= in the IMPACT.INI file.

This indicates the maximum number of users who can concurrently be defined as report designers and may therefore design reports using the SYSPRO Reporting Services program.

• Denoted by IMPRSD= in the IMPACT.INI file.

This indicates the maximum number of companies that can be used concurrently on a site.

This indicates the number of Espresso seats you are licensed to use.

Espresso user licenses are allocated using the Espresso User Licenses program.

• Denoted by IMPESP= in the IMPACT.INI file.

This indicates the number of Espresso licenses that you have given your customer, allowing them limited access to queries and transaction posting applications.

• Denoted by IMPESX= in the IMPACT.INI file.

This indicates the number of licensed workflows, if you are using the Workflow Services Professional module.

• Denoted by IMPWFL= in the IMPACT.INI file.

This indicates the number of named-users that have access to the SYSPRO Supply Chain Portal.

Portal users are created and maintained using the Portal User Management program. These users have limited access to portal-specific functions.

• Denoted by IMPPOR= in the IMPACT.INI file.

This lets you indicate that each of your SYSPRO concurrent licensed users has access to SYSPRO Espresso.

• Denoted by IMPESL= in the IMPACT.INI file (where 1 means checked).

This lets you change the format in which you want all system dates to be displayed and printed within SYSPRO.

Although your selection here does not affect the way in which dates are stored in the system (i.e. this is always in a CCYYMMDD format), there are instances where SYSPRO overrides your preferred date display format and shows dates in a CCYYMMDD format.

This typically occurs in list views where the date column can be used for sorting purposes.

This lets you indicate your preferred date display format.

dddd	The day of week (e.g. Monday)
ddd	Abbreviated day (e.g. Mon)
dd	A two-digit day of month (e.g. 01 through 31)
d	A zero- suppressed one digit day
D	A zero-suppressed day of month with 'st', 'nd', 'rd' and 'th' (e.g. 1st, 2nd, 3rd, 4th, etc.)
MMMM	The month in full (e.g. September)
MMM	The month abbreviated (e.g. Sep)
MM	A two-digit month
M	A zero-suppressed one digit month
yyyy	A four-digit year (e.g. 2007)
yyy	A three-digit year (e.g. 007)
yy	A two-digit year (e.g. 07)
y	A one-digit year (e.g. 7)

H	A zero-suppressed 24 hour format
HH	A two-digit 24 hour
h	A zero-suppressed 12 hour format
hh	A two-digit 12 hour format
m	A zero-suppressed minute
mm	A two-digit minute
s	A zero-suppressed second
ss	A two-digit second
tt	A two-character AM/PM indicator

This indicates how the system will display the long version of the date.

It does not affect the way dates are physically stored on file, it merely provides an alternative way of viewing and printing them.

This indicates how the system will display the short version of the date.

It does not affect the way dates are physically stored on file, it merely provides an alternative way of viewing and printing them.

This indicates how you want to represent the Printed: date that appears in the footer of reports alongside the name of the operator who printed the report.

The other dates printed on the report are rendered according to the short date format.

This indicates a sample of how the Long date format will appear in the system.

This indicates a sample of how the Short date format will appear in the system.

This indicates a sample of how the Report date format will appear in the system.

This indicates the folder that is used for creating temporary files typically used for sorting.

This indicates the default folder in which you should store all your multimedia files. If undefined, this defaults your working directory.

Although this field is disabled on the client, you can use the Edit Client Configuration function to define the path on the client.

This indicates the primary location for your SYSPRO data files. You may define alternate folders and configure companies to use alternate locations as required.

This indicates the 2nd folder in which you want to store data files for your companies.

This indicates the 3rd folder in which you want to store data files for your companies.

This indicates the 4th folder in which you want to store data files for your companies.

This indicates the 5th folder in which you want to store data files for your companies.

This indicates the 6th folder in which you want to store data files for your companies.

This indicates the 7th folder in which you want to store data files for your companies.

This indicates the 8th folder in which you want to store data files for your companies.

This indicates the 9th folder in which you want to store data files for your companies.

This indicates the location of your Requirements Planning snapshot files.

These files are created when you take a new snapshot from within the Requirements Calculation program (if the Requirements Planning module is installed).

This lets you indicate whether your entry at the User name login prompt refers to the operator code, or whether the system must use the network user name to establish the operator code.

Indicate the default entry you want to use at the User name field of the Login window.

This lets you indicate whether access to the User name field is allowed.

This lets you indicate whether you want the system to remember previous successful user names entered.

This lets you indicate the default entry you want to use at the Company field of the Login window.

This lets you indicate whether you want the system to remember previous successful login attempts.

This lets you indicate whether access to the Company field is allowed.

Enable this option if you require SYSPRO operators to be managed by Microsoft Active Directory (AD) once assigned within the Active Directory User Management program (i.e. access to SYSPRO will be controlled by Microsoft Active Directory (AD) for the defined operators).

Define the endpoint for the SYSPRO 8 Active Directory Sync Service used when installing the service (e.g. net.tcp://MachineName:8733/SYSPRO.AD.Sync.Service).

Select the Test AD connection hyperlink to confirm that your settings are configured correctly.

Enable this option to receive an email whenever operators managed by Microsoft Active Directory (AD) require configuration or management in the Active Directory User Management program.

The following variables are passed to the email template when the Microsoft Active Directory (AD) synchronization takes place:

• $SsoUserCount$: Count of users added for review.

• $SsoOpChanged$: Count of operators with changes (email, name, etc.).

• $SsoOpActivated$: Count of operators whose status has changed to active from disabled or removed.

• $SsoOpDisabled$: Count of operators whose status has changed to disabled.

• $SsoOpRemoved$: Count of operators whose status has changed to removed.

Select the Configure review email template hyperlink to define the review email template and indicate who must be notified when new users (belonging to the SYSPRO.ERP security group) are added to Microsoft Active Directory (AD)

Enable this to receive an email if the SYSPRO 8 Active Directory Sync Service fails.

The following variables are passed to the email template when the Microsoft Active Directory (AD) synchronization takes place:

• $FailedMsg$: If the synchronization fails then this contains the message as it is written to the log file.

Select the Configure failure email template hyperlink to define the failure email template and indicate who must be notified if synchronization fails.

Enable this to receive an email every time the SYSPRO 8 Active Directory Sync Service runs successfully.

Select the Configure success email template hyperlink to define the success email template and assign which email address must be used.

Enable this option if Multi-Factor Authentication is required when an operator logs into SYSPRO.

This option is disabled by default.

Indicate the operators that require Multi-Factor Authentication:

This method sends an email to the defined MFA operators containing a Time-based One-time Password (TOTP) that is required as part of the verification process.

Indicate whether an operator can enter their own email address when first configuring the email authentication for logging into SYSPRO.

If this option is disabled, the email address defined against the operator code is used and can't be changed.

If the Operator can set own email address option is enabled, use this field to define the pattern to which the manually entered email address should conform.

Use the ; character to separate multiple entries, without spaces.

Indicate whether an operator is allowed to see the email address when logging into SYSPRO.

Select the Configure PIN email template hyperlink to define the email template that operators receive.

Select this to make use of the Google Authentication app (or FreeOTP) for authentication.

A QR code is generated when operators first configure their Google authentication for logging into SYSPRO and a Time-based One-time Password (TOTP) then becomes required as part of the verification process for the defined MFA operators.

A Time-based One-time Password (TOTP) is then required for all subsequent logins to SYSPRO.

This indicates the SQL Server name that will be used. This is typically the name of the computer on which SQL is running.

This indicates the SQL driver used in the connection string:

• SQL Server (the default selection)
• ODBC Driver 13 for SQL Server
• ODBC Driver 17 for SQL Server

Select this to ensure that the connection between SYSPRO and Microsoft SQL Server is encrypted.

If you enabled the Encrypted connection string option then you can select this to indicate that the encryption must use a self-signed server certificate.

This indicates the database of SYSPRO's configuration tables.

If you enabled the Use generated SQL user details option then you can enter characters that you want to prefix the operator code with and use as the SQL login name. Leave blank if no prefix is required.

Up to 20 characters can be used. These characters cannot contain backslash or embedded spaces or start with $ or @.

Enter the minimum number of characters for the password. This can be a value of between 0 and 99, however a warning is displayed if less than 8 characters.

Enter the maximum number of characters for the password. This can be a value of between 0 and 128 but cannot be less than the minimum password length.

Enter the minimum number of digits (0 – 9) that must be included in the password. This can be a value between 0 and 99.

Enter the minimum number of alphanumeric characters (A – Z, a-z) that must be included in the password. This can be a value between 0 and 99.

Enter the minimum number of special characters (excluding [ ] { }( ) , ? * ! @) that must be included in the password.

This can be a value between 0 and 99.

This indicates the administrator login with the authority to perform advanced SQL functions.

This indicates the password assigned to the administrator login.

Indicates the standard user login.

The user entered here must have the following permissions enabled:

• datareader
• datawriter

This indicates the password assigned to the SQL Server standard user login.

This indicates the system-wide language character set used by the BULK INSERT statement when special characters exist that SQL Server needs to recognize.

Indicates the temporary folder for storing intermediate bulk copy format files (*.bcp).

In a 3-tier environment, ensure that the temporary folder is available to both SQL server and the application tier.

Typically, use a Universal Naming Convention (UNC) address (e.g. \\server-name\path-to-shared-resource).

This lets you use a SQL Managed Instance created in Azure (i.e. this makes programs use logic written specially for SQL Managed Instance).

This is the address that is used to store objects in Azure.

This indicates the credentials that will be used when accessing resources in the Azure Blob storage container.

This is the Azure external data source name (used by SYSPRO for Bulk Inserts).

This indicates the name of the SQL Server hosting the database.

Specify the SQL authentication login here.

Specify the SQL authentication password here.

Select an authentication mode to use when processing transactions on the Harmony database.

Indicate the name of the SQL server that will be used for the Harmony database.

Provide a valid SQL login name for the Harmony database.

Indicate the corresponding password for the SQL login.

This indicates the address to the reporting host service (e.g. localhost:1979).

Enter the scheduler authentication user name (i.e. the Windows Task Scheduler permission that allows the operator to create and maintain schedules on the server).

Enter the scheduler authentication password (i.e. the Windows Task Scheduler permission that allows the operator to create and maintain schedules on the server).

This lets you purge the document print queue automatically.

Enter the number of days (up to 999) you want an item to remain in the queue before it is automatically purged.

This is the default IP address of the specific SMTP server that SYSPRO will use to send messages when the user requests a password reset.

This is the default email address of the sender of the message.

This entry must contain a valid email structure (e.g. auto.generated.mail@company.com).

This the user name of the email account.

This is the password of the email account.

This indicates the server port to be used.

We recommend using Port 587 for SMTP communications in SYSPRO, as it includes TLS encryption and adheres to IETF guidelines.

We advise against using Port 25 and Port 465:

• Port 25 is typically used for SMTP relaying, but is traditionally blocked by Internet Service and Cloud Hosting Providers to curb the amount of spam relayed from compromised computers or servers. We don't recommend any email traffic using this port unless you're specifically managing your own mail server.

• Port 465 is not compliant. IANA has reassigned a new service to this port, so you shouldn't use this port for SMTP communications anymore. It's typically only used if your email server demands it.

This indicates that communication with the SMTP server requires SSL encryption (i.e. send email via an SSL connection).

Select this to use the Email/SMTP settings defined in the System Setup program for your companies (i.e. system-wide).

When you enable this option and save your selections, you are prompted to apply the settings to all your companies.

If you choose to update all companies, the Use system-wide SMTP details in the Setup Options program is enabled against each company.

If you choose not to update all companies, then the settings defined in the System Setup program only apply to new companies (i.e. existing companies are unaffected).

This indicates the id of your active directory in the Microsoft Azure portal.

Your SYSPROOfficeCloud application will be added to this directory.

This indicates the URI to your exchange web service address.

If you don't have an exchange server, you can use the default provided by Microsoft Office 365 (i.e. https://outlook.office365.com/ews/exchange.asmx).

This indicates the client ID of the SYSPROOfficeCloud application added to your active directory in Microsoft Azure.

This is pre-populated with https://login.microsoftonline.com.

This is pre-populated with https://graph.microsoft.com.

Indicate the SYSPRO Avanti website address on your local system (e.g. http://localhost/SYSPROAvanti).

This enables you to use the Notifications Inbox in SYSPRO Web UI (Avanti).

Indicate the address of the Espresso Server which is used to push notifications to a user's devices (e.g. http://localhost/SYSPRO8Espresso).

Indicate the address of the SYSPRO OData layer (i.e. the base portion of the SYSPRO OData URL and your particular endpoint) that will be used to connect to the SYSPRO OData Service (from SYSPRO 8 2021 R2).

This lets operators who have been configured as OData users to access data within the SYSPRO databases using the SYSPRO OData Service.

This lets you indicate the companies for which you want to enable the Rules Engine.

After configuring this setting the following processes occur in the background:

• The applicable SQL tables are created within the SYSPRO database (prefixed by: Rules).
• A new SYSPRO operator (__RUL) is created (required for services to run).

This lets you indicate the companies for which you want to enable Harmony.

Indicate the URL of the SYSPRO 8 Harmony API Service (i.e. the Harmony service installed within IIS).

Indicate the SYSPRO 8 Harmony Service address (used to process Harmony transactions).

Enable this option for records to be permanently deleted from the database automatically.

This option is disabled by default.

Indicate how long beat records and beat information must be retained in the database (the default is 3 months).

This indicates the period after which purging will take place.

This indicates how old data can be when surfaced to the Harmony client (the default is 3 months).

This reflects how data is surfaced to the Harmony client in years (i.e. if the entry at the Detailed data visibility (months) option exceeds 12 months.

This option is related to how data is surfaced to the Harmony client. It is used for calculating various aspects across beats within the system. These include:

• Minimums
• Maximums
• Averages
• Standard deviations
• Importance of beats based on historical data in the system

In other words, all of these counters are used to determine how important a certain beat is.

By default this value is 3 months.

This reflects how summary data is surfaced to the Harmony client in years (i.e. if the entry at the Summary data visibility (months) option exceeds 12 months.

This is the prediction endpoint address of the SYSPRO Artificial Intelligence service (e.g. http://localhost:30238/SYSPROMLE/rest) that is used by the SYSPRO Machine Learning module to perform predictions.

This is the training endpoint address to the SYSPRO Artificial Intelligence service (e.g. http://localhost:30238/SYSPROMLE/rest) that is used to train projects to generate a model that can be used to perform predictions.

Indicate the Azure App service URL/endpoint where the SYSPRO Bot is hosted (e.g. https://sysproken.azurewebsites.net).

This lets you start Bot conversations with an options menu instead of a "What can I do for you" message.

This lets the SYSPRO Bot respond with debugging informational messages (i.e. additional error details).

Enter the server image path to be displayed on the SYSPRO Bot login screen

Enter the organization name to be displayed on the SYSPRO Bot login screen.

Enter the website URL to be displayed as a link on the SYSPRO Bot login screen (e.g. https://syspro.com).

This lets operators change their own passwords in a SYSPRO Desktop environment. This option does not effect the SYSPRO Web UI (Avanti) and SYSPRO Cloud ERP versions.

The Select operators hyperlink lets you select the operators you want to force to change their passwords.

This forces operators to define a new password when next they load SYSPRO. This can be applied to a single operator, a range of operators, or all operators.

You would typically use this when adding new operators and applying an arbitrary password to the operator code. When the new operator logs into SYSPRO for the first time, the operator can define a new password as required.

Operators who don't define a password are locked out of SYSPRO (with the exception of the ADMIN operator). This lock can be removed manually using the Operator Maintenance program.

This forces an entry at the Expiry period field, ensuring that operators change their passwords at prescribed intervals.

Enter the number of days that must elapse before operators are required to change their passwords. A daily countdown is activated by the system 7 days before a password is due to expire, warning operators to change their passwords.

When a password expires, the operator is prompted to change the password immediately by entering the old password, followed by the new password. The expiry period is calculated from the time you set the password.

Enter the number of days prior to the expiry of the current password that the operator must be warned that the password is going to expire.

The default warning period is 14 days.

The warning is only relevant in a SYSPRO login environment and does not apply to the e.net login process.

This lets you send auto-generated emails to the user and system administrator when a request to reset the password is received or when the password has been reset.

Select the Configure change email template hyperlink to use the Send Email program to change the template that is used to send out the email regarding a password change request.

This lets you create a password that can be used as a substitute whenever an operator password is requested.

This is useful when access to an operator's account is required but the operator is either unavailable or has forgotten the password.

The supervisor password can also be used instead of the Alternate Password defined against the operator.

This lets you configure the supervisor password.

This lets you confirm the supervisor password.

This lets you allow the operator to reset the password.

This will enable the Forgot password link on the SYSPRO login window.

Enter the number of hours for which the temporary password is valid.

Select the Configure forgot password email template hyperlink to use the Send Email program to change the template that is used to send out the email with the temporary password details.

This lets you notify the system administrator when an operator has exceeded the number of login attempts permitted.

Select the Configure login exceeded email template hyperlink to use the Send Email program to edit the email template of the email that is sent to the administrator when the number of login attempts is exceeded.

This lets you define the rules governing the entry of new passwords.

Indicate the minimum number of characters for a password.

A minimum of 4 characters is recommended.

This lets you indicate that at least one numeric character must be included in the password.

A combination of words and numbers in a password makes it more secure.

This lets you indicate that at least one alphabetic character must be included in the password.

You can optionally specify whether the alphabetic character must be in uppercase or lowercase.

Forcing passwords to contain a mix of upper and lowercase characters makes it more secure.

This lets you indicate that at least one uppercase alphabetic character must be included in the password.

This lets you indicate that at least one lowercase alphabetic character must be included in the password.

This lets you prevent operators from recycling their passwords. The system verifies any new password against an encrypted file of previously-used passwords.

If you enabled the Verify password against old passwords option, then you can enter the number of previously-used passwords to retain for comparison purposes. The default is 3.

When an operator enters a new password, that password is compared to the previously-used passwords.

Select the Reset operator password history hyperlink to remove all records of password history generated for operators.

This applies a minimalist theme (Office 2013) to the SYSPRO interface to give it an uncluttered feel.

It hides icons (e.g. Menu, Autohide, Maximize and Close) and titles for docking panes (F12 toggles these titles).

Also, a field's caption is not displayed in bold type when the field is highlighted.

This lets you select a specific visual theme for each type of control (e.g. docking pane, list view column, calendar and toolbar) and apply it throughout SYSPRO.

If you do not want to override the individual operators' setting for this option, select Not set by administrator.

Indicate the style you want to apply to the ribbon bar.

Select Not set by administrator if you don't want to override the individual operators' setting for this option.

The Predictive Search facility in SYSPRO automatically shows suggestions of search results as you type text into any key field in the product (e.g. stock code, customer, supplier, etc).

The search uses a web service (configured within the System Setup program) to interrogate the database and return values based on a pre-defined configuration.

Indicate whether you want to display images when showing search items. This option is enabled by default (i.e. an administrator needs to switch it off, if this is required). Switching off this option may improve the performance when showing search items.

This shows the Next, Prev, etc., toolbar navigation buttons when the Enable minimalist user interface option is in use. By default, these options are hidden except for browse-style programs.

This enables the Customize Task Dialogs option (SYSPRO Ribbon bar > Administration > Customization).

This lets you show dialogs with single buttons as auto-expiring messages.

This lets you set how long you want the toast notification to be displayed on the screen before disappearing. The default is 4 seconds and can be set to a maximum of 2 minutes.

This lets you override the toast notification delay (if defined) and close the toast notification as soon as you start typing into a form field or a toolbar entry field.

By default the web browser control is currently an embedded version of Internet Explorer 7, as this is how Microsoft originally published the control. However, by applying a setting to the registry, the SYSPRO web browser can be made to emulate any version of IE.

Enable this option to allow SYSPRO to create new registry entries that indicate to the web browser control to default to IE11 compatibility mode.

These entries reside in:

HKLM (or HKCU)
SOFTWARE
Microsoft
Internet Explorer
Main
FeatureControl
FEATURE_BROWSER_EMULATION
SYSPRO.exe = (11000) version
SYSPROClient.exe = (11000) version

Select this to save the primary window position of a program upon exiting the program. When next the program is loaded, the primary window is restored to its saved position.

Primary windows for each program default to being centered within the MDI frame of the main menu.

This only applies if you enabled the Structured General Ledger facility (GL Structure Definition).

This applies to the launching of the system help when clicking on SYSPRO version in the status bar of the Main SYSPRO menu.

This applies when a system-wide view has been designed to be contained in the main menu.

Selecting this option forces the system-wide view in the main menu to be visible when the operator logs in.

This applies when a role view has been designed to be contained in the main menu and the operator is associated with a role.

Selecting this option forces the role view in the main menu to be visible when the operator logs in.

This lets SYSPRO work with roaming users - a configuration that allows operators to seamlessly access documents from any computer on the same network, without losing their desktop settings or preferences.

This is typically used by system administrators and when a workstation is accessed by different users.

Enable this option if you want to use the system-wide generic browse program for all browses in SYSPRO. The advanced browse consolidates SYSPRO's traditional browse look-up programs into a single program, making it easier to use, administer and customize.

If you don't enable this option, then only new programs (from SYSPRO 8 2021 R2) that require browses will use the advanced browse facility.

Enable this to store operator user interface settings (e.g. personalized views of toolbars, charts, etc.) in the SysSettings table of the system-wide database for backup purposes. These settings are usually stored in the \Base\Settings) folder. The files are compressed and inserted into the SQL table when an operator exits SYSPRO. Once the operator logs in again, these files are restored from the database, overwriting the local settings.

This indicates whether RTS and CMS files reside in SQL.

If the option is unticked, then the Migrate RTF files to SQL from file system hyperlink lets you migrate RTF notepad files and Contact Management Activity attachments to the SQL database instead of retaining them on the file system.

If the option is ticked, then the Migrate RTF files to SQL from file system hyperlink lets you migrate data back to the file system (e.g. you later decide that storing the RTF and CMS data in SQL is not suitable for your environment, typically because third party applications require access to the files).

This allows address lines in forms to be formatted, such as the wording for Building, Street, City, etc.

When you select the Configure hyperlink, a window is displayed with the following field and column information:

This sets the font to use for all forms and list views in SYSPRO.

Indicate the font you want to use.

This displays all form captions in bold.

Indicate how you want to align numeric values system-wide (e.g. to the left, right or center of the available column or field).

Enabling this option ensures that the Default numeric alignment the option is always applied to all forms, regardless of any previously-saved alignment options.

This option applies to the descriptions for key fields entered on a form (e.g. Branch, GL code, Currency, etc).

Indicate the color you want to use to highlight editable form fields.

Indicate the Map application you want to use for directions (e.g. Google Maps, Bing Maps, etc.).

You can use any map product that accepts latitude and longitude as parameters.

If you selected Use other at the Map URL to use for directions field, then enter the URL of the Map application you want to use for directions.

Enter the key (obtained from Google) that will allow you to resolve addresses to GPS co-ordinates within SYSPRO.

Enable this to use the short names when applying a selected address from Google Maps (e.g. NY instead of New York and UK instead of United Kingdom).

Additionally, you can toggle between using short and long names directly from the address list when you click on the Resolve GeoLocation from address option at the Geolocation form field.

The drop-down list indicates whether the long or short name is in use. The operator can use the hyperlink to toggle between them, but this applies only to the current run of SYSPRO.

The system-wide setting is re-applied the next time the operator logs in.

This uses Microsoft Excel to export data from SYSPRO list views and forms.

Deselect this option to be able to export list views to an application other than Excel.

The Export application field then becomes enabled for you to specify the application to use.

Enter the program to use (including the full path) to export list views when not using Microsoft Excel.

You can use any application that accepts a file containing an HTML table as its first parameter.

Enter a description for the export application.

This lets you change the default font and font attributes (e.g. bold, italic) of the Quick View displays in SYSPRO.

Indicate the default font.

Indicate the format you want to use for all dates displayed in a list view.

Optimized list views perform faster the more columns are not visible. Select an icon to indicate list views that support optimization.

Select the Edit icon hyperlink to select the icon to be shown in a list view header to indicate an optimized list view.

This displays icons alongside the various types of custom form fields (including dates) in forms.

This displays the built-in toolbar for list views, where applicable.

When enabled, operators won't be able to deselect the Show List view Toolbar option by clicking on a list view column to customize the list view.

This shows a watermark image for list views against all companies (typically useful if want to avoid having to apply the same image to multiple companies).

The image must be located in the \Base\Samples folder.

Indicate the watermark transparency required.

Indicate the required alignment of the watermark image.

Indicate the number of decimals to display in list views for prices and costs. This applies to list view columns that include the words: price, cost, prc or cst in the column heading.

The purpose of this option is to only reduce trailing decimal zeroes to a minimum.

So, if the number of decimals of the actual cell value is greater than the minimum number defined here, then the number of actual decimals in the value is displayed.

For example:

If the Maximum decimals to show for price/cost is set to 2, then:

• 5.12 is displayed as 5.12
• 5.12000 is displayed as 5.12
• 5.1234 is displayed as 5.1234
• 5.10 is displayed as 5.10

This lets you indicate the default number of rows to display when first loading a limitless list view (defaults to 100 rows).

The default number of rows is only applied for the initial loading of a list view because, thereafter, the number of rows can be controlled by list view by operator.

To enforce this default number of rows on initial load for all operators, enable the Always apply default number of rows option.

This lets you always load the number of rows specified at the Default number of rows to return option in list views, regardless of any operator preferences set for displaying the number of list view rows.

Although the operator can change the required number of rows to display during the run of a program, the Default number of rows to return is re-applied when the program is closed.

Indicate the maximum number of list view rows to display before the threshold option below applies (the default is 30 000). This option can be used to overcome issues when there is a large number of rows to display in a list view (this does not apply to editable data-grids).

This lets you indicate what you want the system to do when the threshold limit for returned rows is reached. Options include:

• Give warning message (the warning is only displayed once)
• Prompt operator to continue (the question is only displayed once)
• Do not add more rows

This lets you set the default font for notepad editors that support Rich Text Format.

This lets you set the default font for text-only notepad editors that don't support Rich Text format. Typically, you would use a fixed width font here (e.g. Courier New) to help with text alignment.

Enable this to save a history of previously-queried entries for key fields. The history is displayed in a drop-down when scrolling on the entry field for the key.

When this option is disabled and then re-enabled, the previously saved drop-down list is restored.

Indicate the number of days from the previous year that occur in the first week of the current year.

This enables you to control the week numbering against SYSPRO's Date Navigator.

If the first week of the current year contains four or more days from the previous year, then the first week of the year is numbered as week 53. If it contains three or less days from the previous year, then it is numbered as week 1.

Select this to highlight non-working days within SYSPRO's Date Navigator utility.

You use the Calendar program to define the specific working and non-working days on your company calendar.

This lets you automatically check for messages that have not yet been actioned, upon loading the system.

Messages are posted to the Inbox from various sources within the system.

You can also check for new messages by launching the Message Inbox window (right-click within the window and select Refresh Inbox).

This prevents unauthorized access to VBScripts by ensuring that they are only stored on the server.

This ensures that all VBScripts are encrypted on all client machines.

This prevents operators from entering invalid or special characters ( including spaces) into a key field.

Enter the list of special characters you want to restrict operators from entering in key fields.

If no special characters are entered, then this implies that the {space} character must be prevented from being entered.

This lets you strip all leading spaces from key fields in toolbars, entry fields, form fields and data-grid cells after entry (e.g. tabbing off the field).

This lets you improve the performance of documents produced using SRS document printing (by pre-loading the Crystal runtime when SYSPRO loads).

Indicate the time interval (not less than 1 minute) within which you require SYSPRO to send a blank message to the server to keep the connection alive.

SYSPRO stops responding if it is idle for longer than the timeout time.

This only applies in a client/server environment where timeouts have been configured.

The SYSPRO 8 Communications Service defaults to a 30 second timeout if the connection to the server fails, after which the system allows the operator to Retry or Cancel (to exit gracefully).

This option lets you configure the length of time (in seconds) before the Retry message appears when the Internet connection is lost.

If the default timeout is subsequently changed back to 30 seconds, then the SYSPROSCSTimeouts.txt file is deleted from the client when logging in.

Indicate the time interval (in minutes) before SYSPRO Web UI (Avanti) will require the operator to re-enter their password, after the system becomes idle.

A value of 0 indicates no timeout.

Indicate the time interval (in minutes) before SYSPRO Web UI (Avanti) will exit, if no password is entered.

A value of 0 indicates no timeout.

Indicate how many additional instances of SYSPRO Web UI (Avanti) is allowed per user. You should consider restricting this facility as each instance consumes memory on the application server. A new instance is typically created when a user is logged into a SYSPRO Web UI (Avanti) program and then runs another program from the hamburger menu.

A value of 0 indicates no additional instances are allowed.