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 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, such as a description of the
company for example. If you are using the USA AVP sales tax system (Company Tax Options Setup) then enter AVP in this field if you require the ShipToAddr4 and SoldToAddr4 fields in the ArCustomer table to be updated with the State value against the Extended tax code (Extended Tax Code Maintenance) and the ShipToAddr5 and SoldToAddress5 fields not to be updated at all. |
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. The Use short names when resolving addresses option (System-wide Personalization) determines which name to use by default. SYSPRO reads the name returned from the map provider in XML. If the short name returned in the XML is the same as the long name, then no short names are available from the map provider. |
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. The Use short names when resolving addresses option (System-wide Personalization) determines which name to use by default. SYSPRO reads the name returned from the map provider in XML. If the short name returned in the XML is the same as the long name, then no short names are available from the map provider. |
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. Whenever you add or change the default company warehouse, you need to restart SYSPRO for your changes to become effective. |
||||||||||||||||||||||||||||||||||||||
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 New Company Wizard and Company Setup (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. You can use any character as a date separator. |
||||||||||||||||||||||||||||||||||||||
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 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.
|
||||||||||||||||||||||||||||||||||||||
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 list of SYSPRO Nationality codes is defined in the IMPNAT.IMP file located in the SYSPRO ..\Programs folder. 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. |
||||||||||||||||||||||||||||||||||||||
Use SSL | Enable this option to specify that communication with the SMTP server requires SSL encryption (i.e. send email via an SSL connection). |
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 Groups 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 for SRS reports | Includes job logging entries for the running of SRS reports. The log file lets you see the date, time and name of the operator who ran the report. | ||||
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. | ||||
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 option for the Multimedia program to access
objects using the presentation key length in the file path
when you're using the %key variable in
the multimedia object path. It doesn't rename the multimedia files, it just alters the %key value returned for multimedia.
Single field example - Customer 40: The key length of the Customer field is 15 characters. If you set the presentation length to 7 characters then the system looks for:
Compound field example - Customer 40; Invoice 1: The key length of the Customer field is 15 characters. The key length of the Invoice field is 15 characters. If you set the presentation length of the Invoice field to 6 characters and the Customer field to 7 characters, then regardless of whether the Presentation length for multimedia %key option is enabled, the system looks for:
|
||||
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 Code 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 and general ledgers across companies. If both Inventory and General Ledger are shared, then the Inventory Interface setup in the Inventory 'holding' company is used to determine the ledger accounts to which transactions processed in 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.
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 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. 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 (Operators). | ||||
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 zeros displayed in price and cost list view columns. |
||||
Style for quantities in list views | |||||
Edit quantities using decimals | Displays stock code-related quantities in list views according to the Maximum number of decimals defined against the stock item (Stock Codes. | ||||
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 (ISAM to SQL Migration Wizard. |
||||||
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. 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 e.net License Import Wizard program when you update the company's SYSPRO license.
You must be logged into the company for which you want to maintain custom form field values. If you save company details for a company that you are not currently logged into, then the custom form values for that company are cleared.
In addition, if you create company custom form fields then you will have to create the same custom forms fields for each company.
You can add custom form fields to each pane. Right-click on a caption and select the Field Selector option.
The Microsoft Outlook option cannot be used if Microsoft Outlook 2010 is installed.
Outlook's rich email client interface is only invoked if you have Microsoft Office Outlook 2003 (or later) installed on the client machine.
If you have Microsoft Office 2003 you need to download Microsoft Office 2003 PIAs from the Microsoft website.
This is not required if you have Microsoft Office 2007.
Earlier versions of Outlook use the old-style email client interface.
The Macro using VBScript option is not supported for SRS document printing.