You use this program to maintain details about your SYSPRO companies according to the terms of your software license agreement.
Field | Description |
---|---|
Set company password |
Configures a password for the company that will be requested whenever an operator attempts access. |
Prevent Login |
Prevents unauthorized access to this company (useful if you are maintaining a company and want to restrict other operators from capturing data). This does not affect operators currently accessing the company. |
Reason |
The message you want to display to any unauthorized operator attempting to access the company. |
Field | Description |
---|---|
Company ID | Displays the company code of the currently selected company. |
Company Name | Displays the company name as entered at the Company name field on the Registration tab. |
Reference | Enter a company reference. This is not used by the system or printed, but you can use it to describe the company. |
Company Address | Indicate the company's address details that can be printed on any free-format stationery. |
Geolocation | This indicates the geographic location of the address in terms of
longitude and latitude and includes a hyperlink to the map directions.
An additional hyperlink is available (Resolve GeoLocation from address) to resolve addresses using the long or short name. |
Delivery Address |
Indicate the company's physical address to which goods must be delivered (used by the Purchase Orders module). |
Geolocation | This indicates the geographic location of the address in terms of
longitude and latitude and includes a hyperlink to the map directions.
An additional hyperlink is available (Resolve GeoLocation from address) to resolve addresses using the long or short name. |
Field | Description | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company Values | |||||||||||||||||||||||||||||||||||||
Company tax registration number |
Indicate the company tax registration number. This can be printed on delivery notes, invoices, statements and purchase orders. |
||||||||||||||||||||||||||||||||||||
Company registration number |
Indicate your company registration number. This can only be printed on delivery notes, invoices, statements, creditor's remittance advices and purchase order requisitions. |
||||||||||||||||||||||||||||||||||||
Default warehouse |
This is the warehouse displayed as the default at most Warehouse fields in the system. Specifying a default warehouse is useful if you are only using one warehouse in the system and do not want to have to re-enter the code repeatedly. You can override the default warehouse at operator level. |
||||||||||||||||||||||||||||||||||||
Local currency |
Indicate the default currency in which you want to process transactions within the system. You cannot change this currency once you have added the company. |
||||||||||||||||||||||||||||||||||||
Local currency description |
Enter the description for the Local currency code assigned to the company. |
||||||||||||||||||||||||||||||||||||
Accounting periods | This is typically determined by the frequency of your
company's financial and management reporting cycles. It also determines the relationship between the General Ledger and the sub-ledgers with regard to the posting of the sub-ledger transactions into the General Ledger. Once defined, you should not change the number of accounting periods per year, or you may lose historical information (i.e. the history buckets for transactions written to the files in the sub modules are not moved, adjusted or corrected when you change the accounting periods per year).
|
||||||||||||||||||||||||||||||||||||
GL information | You define these accounts using the General Ledger Integration program. You can only access these fields when you are adding a new company and you require the General Ledger module to be installed. | ||||||||||||||||||||||||||||||||||||
Forced balance account |
This account is used by the system to correct an out-of-balance situation in the General Ledger. It does so by posting an entry to this account to correct the imbalance. The value posted can then be journalized out to the correct ledger code manually. The following programs add a GL Account called FORCED if it doesn't exist on the GenMaster file: Company Maintenance, Add Company Wizard and Companies - login window (when it first creates the 00 record on ADMCTL). |
||||||||||||||||||||||||||||||||||||
Forced balance description |
Indicates the description for your forced balance account. |
||||||||||||||||||||||||||||||||||||
Retained earnings account |
This account is updated with the net income/loss for the year when you run the Year end function of the General Ledger. It is also used if you select to close out your expense and revenue accounts when you run the year end. |
||||||||||||||||||||||||||||||||||||
Retained earnings description |
Indicates the description for your retained earnings account. |
||||||||||||||||||||||||||||||||||||
Edit Date Format |
Although always stored in a CCYYMMDD format, this option enables you to define how you want dates to be displayed and requested within SYSPRO, at company level. Note that dates in forms are determined by the Date format only (i.e.DDMMYY or YYMMDD). The short/long date format is not applied to any date fields in forms. |
||||||||||||||||||||||||||||||||||||
Override system date format |
This overrides the date format settings made within the System Setup program. |
||||||||||||||||||||||||||||||||||||
Date format | Select the format in which you want all system dates to be displayed and requested within SYSPRO for this company. | ||||||||||||||||||||||||||||||||||||
User defined date formats |
Your selection here provides an alternative way of viewing and printing dates and does not affect the way in which dates are physically stored on file. |
||||||||||||||||||||||||||||||||||||
Long date format |
Select how you want the system to display the long version of the date for this company.
|
||||||||||||||||||||||||||||||||||||
Short date format |
Select how you want the system to display the short version of the date for this company.
|
||||||||||||||||||||||||||||||||||||
Report date format |
Select how you want the system to display dates on reports printed within this company.
|
||||||||||||||||||||||||||||||||||||
Test date |
The date entered here is used by the samples below to confirm that you have correctly configured your user-defined dates. |
||||||||||||||||||||||||||||||||||||
Long date sample |
Displays how the setting for the Long date format will appear in the system. |
||||||||||||||||||||||||||||||||||||
Short date sample |
Displays how the setting for the Short date format will appear in the system. |
||||||||||||||||||||||||||||||||||||
Report date sample |
Displays how the setting for the Report date format format will appear in the system. |
||||||||||||||||||||||||||||||||||||
Company nationality code | |||||||||||||||||||||||||||||||||||||
Override system nationality code |
Enables you to set your nationality code at company level (i.e. overrides the setting made within the System Setup program, unless this conflicts with an existing tax option that has been defined). |
||||||||||||||||||||||||||||||||||||
Nationality code |
This indicates the nationality of your company (e.g. USA - United States of America; GB - Great Britain; AUS - Australia; CAN - Canada; RSA - South Africa). The nationality entered here affects the display of region-specific fields within the system (e.g. tax). |
||||||||||||||||||||||||||||||||||||
Email/SMTP Settings | |||||||||||||||||||||||||||||||||||||
Method when emailing |
Select the preferred emailing method within SYSPRO.
|
||||||||||||||||||||||||||||||||||||
SMTP server IP address |
Indicates the default IP address of the specific SMTP server that SYSPRO will use to send messages. |
||||||||||||||||||||||||||||||||||||
Outgoing email address |
Indicates the default email address of the sender of the message. |
||||||||||||||||||||||||||||||||||||
User name |
Enter the user name for the email account specified above. |
||||||||||||||||||||||||||||||||||||
Password |
Enter the password for the email account specified above. |
||||||||||||||||||||||||||||||||||||
Server port |
Indicate the server port to be used. |
Field | Description | ||||
---|---|---|---|---|---|
Options | |||||
Job logging required | Creates a log file detailing each program that is
accessed by each operator. You can enable job logging selectively by module and program using the Security Access function of the Operator Group Maintenance program. |
||||
Job logging for business object | Includes job logging entries for business objects in
the log file. Enabling this option may lead to excessive entries in the log from automated and semi-automated processes. Disable this option if you don't want to create log entries for business objects invoked from e.net Solutions, Web-based applications, DFM and VBScripting (from forms, customized panes, etc). If a regular SYSPRO program (e.g. Sales Order Entry) invokes a business object to perform a database update or query, then a job log entry is created as normal. Job logging entries are not created when running SRS reports. |
||||
Print operator name on journals | Prints the name of the operator who made any postings
to the journal file, on the report. This applies to following journals:
|
||||
Print report options selected | Prints the report options you selected for a report on
the first page of any system report. You would typically use this option to indicate why some entries were included/excluded from a report, as well as if you print multiple copies of the same report with different report options. SRS Reports will take longer to run when you select this option. |
||||
Edit postal/zip codes 5-4 | Prints and displays postal codes as a 5-4 field (i.e. the first five characters entered are separated from the remaining four characters by a dash). | ||||
Close previous month automatically | Closes a sub-ledger month automatically when you complete a month end within the relevant module. You would typically use this if you generally only post to the current month. If you need to post transactions to a prior month then you will have to reopen the month manually. | ||||
Shared inventory for custom forms | If are using shared inventory, then this indicates that
custom forms configured for the shared company must be used
for each of the companies sharing the same inventory
files. (See the Shared inventory considerations topic (Custom Forms Overview). |
||||
Shared inventory for multimedia | If you are using shared inventory, then this indicates
that multimedia objects configured for the shared company must
be used for all the companies sharing the same inventory
files. You won't be able to view any Inventory multimedia that is configured in the individual shared companies. |
||||
Presentation length for multimedia %key | Enable this to instruct the Multimedia
program to access the objects using the presentation key
length in the file path. Note that this does not rename the multimedia files. It simply alters the %key value returned for Multimedia. This applies when you use the %key variable in a multi-media object path. Depending on the %key, objects may not be accessible when this option is not enabled. |
||||
Number of decimals | Indicate the default number of decimals to use for all
tax rates. This is applied to the Tax rate
decimals field in the Tax Codes Setup
program. You can still change the number of decimals for individual tax codes which will override your selection here.
|
||||
Shared companies |
These options enable you to share inventories across companies with different currencies and general ledgers across companies with differing accounting periods. If both Inventory and General Ledger are shared, then the Inventory Interface setup in the Inventory 'holding' company is used to determine the General Ledger accounts to which transactions processed using the Inventory Movements program are posted. If only Inventory is shared, then Inventory transactions update the files of the 'holding' company and the General Ledger side of the transactions are posted to that company's own General Ledger files. It is not advisable to share Inventory files across companies that have different base currencies (generally accepted accounting practice assumes that the value of inventory is stated in the local currency of the company). However, if no transactions are processed across the companies' warehouses (e.g. you want to share Inventory for query purposes only) then this can be done without compromising the integrity of the General Ledger. Refer to Shared files and tables for a list of files/tables which are shared. |
||||
Ledger file company |
Indicate the company that will be the holding company for all the general ledger master, history and detail transactions. This defaults to your current company, but can be changed. You would typically use this facility if you want to produce consolidated financial reports for more than one company using the Financial Report Writer. Although general ledger data for each company is stored in the same physical database, only the Financial Report Writer can access the data of other companies.
|
||||
Inventory file company |
Indicate the company that will be the holding company for inventory data. This defaults to your current company, but can be changed. You would typically use this facility if all companies sell the same inventory and you require a consolidated view of the stock holding of all companies.
|
||||
Numeric formatting |
All numeric formatting is also applied to any numeric custom form fields added. |
||||
Decimal character |
Indicate the type of decimal character you want to use for numeric fields that contains decimals (e.g. values, costs, prices, quantities, units of measure conversion factors, currency conversion factors, etc). This character must be different from the 1000's separator character. You can override this at operator level (Operator Maintenance). In a client/server environment, the decimal character entered here must match the character defined in the Regional Settings on the client machine. Otherwise incorrect values could be saved for transaction entries processed in SYSPRO. An error is displayed in programs that include an editable data grid in which there is at least one numeric column, when the decimal character in the Regional Settings on the client does not match the decimal character defined here. Windows Regional Settings affect the formatting of numbers in SYSPRO graphs and currency values in SYSPRO Analytics. In addition, variables have been added to the System Information section of all SRS reports to indicate the number of decimals to display (DecimalsToDisplay) and the decimal character to use (DecimalCharacter). This, in conjunction with the SeparatorToUse variable, can be used to format reports to meet your requirements. If you define the decimal character as a comma (,) then entering a dot (.) is translated into a comma. This is to accommodate the use of numeric keypads which only have a dot (.) to indicate a decimal point. This also applies to the Regional Settings on the client machine. |
||||
Use1000 separators | Defines a delimiter for numeric values over 999.00 (e.g. a value of 123456789.12 can be displayed as 123,456,789.12. | ||||
1000's separator character | Indicate the character (symbol) to use as the 1000's
separator. This character can be a space (for example, if you
want to have 1 000.00). This character must be different from the decimal character. In a client/server environment, the separator character entered here must match the character defined in the Regional Settings on the client machine. Otherwise incorrect values could be saved for transaction entries processed in SYSPRO. |
||||
Style for values | These options enable you to indicate how transaction
values must be printed/displayed in SYSPRO. Reports changed to support extended field sizes remain visually unchanged unless the printed values exceed the available print space, in which case the report print line could change to print two lines instead of one. You can override these settings at operator level. |
||||
Number of digits after decimal | Indicate the number of decimals you want to use for
numeric values. If you enter zero in this field then decimals are removed from entry and display/print fields when values are used.
This does not affect free format stationery that assumes a minimum of two decimals for any price field, and three decimals for any Inventory unit cost field. |
||||
Style for costs/prices | You can override these settings at operator level using the Numeric formatting options (Operator Maintenance). | ||||
Use1000 separators (reports) | Indicates how you want to print costs/prices on
reports. Reports changed to support extended field sizes remain visually unchanged unless the printed values exceed the available print space, in which case the report print line could change to print two lines instead of one. |
||||
1000's separator character (reports) | Indicate the character (symbol) to use as the 1000's separator (e.g. a value of 123456789.12 can be printed as 123,456,789.12). | ||||
Minimum number of decimals to print | This indicates the minimum number of decimals that must
be printed for a cost/price field (e.g. a price of
123456789.12000 may be printed as
123,456,789.120 if the decimal option is
set as 3). This does not affect free format stationary, which assumes a minimum of two decimals for any price field and three decimals for any inventory unit cost field. The option: Maximum decimals to show for price/cost (System-wide Personalization) controls the number of decimal zeroes displayed in price and cost list view columns. |
||||
Style for quantities in list views | |||||
Edit qty's using decimals | Displays stock code-related quantities in list views according to the Maximum number of decimals defined against the stock item (Stock Code Maintenance). | ||||
Style for labor times | |||||
Maximum number of decimals to print | Indicates how many decimal places to print for all
labor times in reports. This applies to the printing of all Work in Progress operation times (such as run time, teardown time, wait time, etc.) on reports. It defaults to four decimal places, but can be set anywhere from zero to six. |
||||
Multiple currency options | |||||
Triangulation required | Converts from one currency to another using an intermediate currency (to conform with European Monetary Union regulations). | ||||
Print triangulation audit | Prints a currency exchange audit line for each foreign currency transaction using triangulation. |
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Database | |||||||
Company format | |||||||
Company data format | Indicate whether your company data is ISAM or SQL Server-based. This option cannot be accessed if your data for all companies is defined as C-ISAM-based or is a mix of C-ISAM and SQL Server (System Setup). | ||||||
Database name | Indicates the name of the database in which your company data is stored. | ||||||
ISAM Location | |||||||
ISAM file location | Indicate whether all your data files for the company
are stored in a one or multiple folders. You would typically use multiple folders to store large files on a different physical drive or file system. |
||||||
File path | Indicates the folder in which your company data is located. | ||||||
Database format | |||||||
Company database format |
|
||||||
Change company format | |||||||
Set company to ISAM | Resets a SQL Server-based company to enable access
C-ISAM data files without actually migrating data from SQL
Server to C-ISAM. You would typically use this function if you have migrated your data to SQL Server, but are not yet in possession of a license number. You should not process any transactions as they will be posted to the C-ISAM database and will no longer match the SQL Server data. It will require you to either remove the SQL Server database or remove the data in the tables and redo the migration to SQL. |
||||||
Migrate to SQL Server | Migrates your C-ISAM data for this company into a
database format that will be accessed using SQL Server. A wizard guides you through this process (SQL Company Setup). |
||||||
Paths | Assign different folders for different data files (C-ISAM only). |
Field | Description | ||||
---|---|---|---|---|---|
Company License | |||||
Company name |
This must reflect the company name as specified on the registration form supplied with the software. |
||||
License expiry year |
The year in which your Software License Agreement expires. |
||||
Expiry month |
The month in which your license expires (if specified within the terms of your Software License Agreement). This applies to temporary licenses. |
||||
License start date | For temporary licenses this indicates the date from which the license is valid. | ||||
Registration |
The registration number assigned to your company. |
||||
Import License |
Imports the LICENSE.XML file into your system (see License Import Wizard). You must run this function to access any e.net Business Object or Web-based Application and when using the Document Flow Manager.
|
||||
System settings |
The number of users currently licensed to use the system as well as the number of licensed seats for:
You maintain these numbers using the System Setup program. Espresso user licenses are allocated using the Espresso User Licenses program. |
||||
Modules |
This pane displays the list of available modules, indicating the ones that are installed. Your selections must match the list of modules indicated on your Software License Agreement. |
SQL Table Name | C-ISAM File Name |
---|---|
All tables beginning with INV, except the following:
|
All file names beginning with INV, except the following:
|
All tables beginning with BOM | All file names beginning with BOM |
All tables beginning with IOP | All file names beginning with IOP |
All tables beginning with ECC | All file names beginning with ECC |
All tables beginning with CFG | All file names beginning with CFG |
All tables beginning with GTR | All file names beginning with GTR |
All tables beginning with LCT, except the following:
|
All file names beginning with LCT, except the following:
|
All tables beginning with LOT | All file names beginning with LOT |
Table: ArcBomRef | File: ARCBOM |
SQL Table Name | C-ISAM File Name |
---|---|
GenMaster | GENMST |
GenTransaction | GENTRN |
GenHistory | GENHST |
GenAltCurCtl | GENACC |
GenAltCurDet | GENALD |
GenAltCurHst | GENALH |
GenControl | GENCTL |
GenBudgets | GENBUD |
GenGroups | GENGRP |
GenBudAltDesc | GENPAR |
GenApportion | GENAPP |
GenCommitDetail | GENPCD |
GenCommitment | GENPCM |
GenAnalysisSection | GENGLA |
GenAnalysisCommit | GENGLU |
GenAnalysisBudget | GENGLB |
GenJournalCtlPrd | GENCJN |
GenLastRevalRate | GENLRR |
GenRevalLog | GENRLG |
GenCopyAltCtl | GENCAC |
GenCopyAltDet | GENCAD |
GenCopyAltHst | GENCAH |
GenCopyBudgets | GENCBU |
GenCopyCommmitDet | GENCCD |
GenCopyCommmitment | GENCCM |
GenCopyControl | GENCCT |
GenCopyGroups | GENCGR |
GenCopyHistory | GENCHS |
GenCopyMaster | GENCMS |
GenCopyBudAltD | GENCPA |
GenCopyTrans | GENCTR |
You should always re-import the new e.Net license using the Configure e.net License program when you update the company's SYSPRO license.
Amendment journals are automatically created for changes made to the company options. See Setup Amendment Journals.
Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.
You can embed an Application Help Pane:
in the main SYSPRO menu
in any program with panes, if not using roles
when adding a role layout in Design Mode.
Inserting Application Help
You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.
Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.
Open the program for which you want to insert application help into a customized pane.
This functionality is only available for a program that has panes.
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
Select Insert Application Help from the context-sensitive menu.
The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.
Removing the Application Help pane
If you no longer want to display application help in a pane for your current program, you can simply remove it.
Select the Close icon in the right-hand corner of the application help pane.
Confirm that you want to delete the pane.