Local menus
In the application, some specific database information is displayed in the form of a restricted selection list: Yes / No, Round codes, Report groups, etc. These all correspond to tables that hold the limited list of items available for selection.
These datasets are called Local menus and are identified by a Chapter number, which is assigned to the corresponding table of available items. When a field in the database is linked to this type of data, the rank (row) number is actually recorded in the corresponding table. For instance, Local menu number 1 contains the two choices No and Yes (in this order): what is actually sorted in the database is '1' for the value No, and '2' for the value Yes.
A large number of local menus is used in the software. As with Miscellaneous tables, this system is used to avoid the creation of a large number of annex tables: the description of these local menus is stored in a single table in the database (table APLSTD). These local menus can be translated: as only the rank number is stored in the table, you only need to change your connection language to display or enter the table in this language.
When modifying these tables, make sure not to insert values but only add values at the end of the list. Inserting a value will move down all the following values and cause inconsistencies as only the row number is stored (unless no data has been assigned yet to the local menu). For example, if you enter Maybe on the first row of the No / Yes table, all the fields in the database set to Yes will be now set to No, and the ones set to No will display the value Maybe! The number of choices in a local menu is limited to 123.
Besides 'Local menus', some chapters in the table are used to store other messages, such as error messages. As a standard, when a specific message needs to be displayed to the user (for instance, a confirmation request, an error message, a comment in a log file, etc.), the message is stored in a chapter dedicated for that purpose, in order to make these messages translatable based on the connection language.
All the developers of specific functions are advised to follow this same process. To get easy access to the text in processes or calculation formula, the standard function mess provides access to the messages. Use mess(NUM,CHAP,1) to get access, in the current connection language, to the message number NUM coming from chapter CHAP.
As a general rule, all adonix technology softwares define their own chapter mapping by allocating number ranges to the functional modules for each product. Please refer to the appendix to know more about the assigned modules for each product.
Prerequisites
Refer to documentation Implementation
Screen management
Entry screen
Presentation
The entry is performed by chapter on a single tab. A chapter can be a local menu or even a group of messages. On exiting this function, if at least one local menu has been modified, the system will automatically launch an update of the local menus in order to update sequential files, used as caches for the local workstations depending on the languages managed in the folder.
Close
Fields
The following fields are present on this tab :
Identifier
| Define the number of the chapter that is to be parameterized. |
| Title associated with the previous code. |
| When this box is checked, the chapter is usable as a local menu and not simply as a list of messages. |
Characteristics
| Select a module for the setup. Use this field to specify if the screen has to be created in the folder database. This is the case when the module linked to the screen is active on the folder. |
| An activity code is used to:
If the activity code is disabled:
|
| This field is used to indicate if the local menu is modifiable by the user in a parameterization phase, directly in the menu Parameterization / General parameters. |
| Upon the creation of a new line, this indicates that the text will not be created in the other languages of the current folder. |
Size
| This field makes it possible to specify the maximum text width in the different local menu choices. |
| This field makes it possible to indicate the minimum number of possible choices that the local menu must include. |
| This field makes it possible to indicate the maximum possible number of choices that the local menu include. |
Grid List of values
| Define the message number in a chapter A local menu defines by this rank the value of the field corresponding to the title. |
| Code on one character associated with the title. |
| Define the title associated with the message number in a chapter. It is this title that is displayed in a component of the type "rolling list" or "radio button" when the field is used as a local menu. |
Close
Reports
By default, the following reports are associated with this function :
PRTSCR : Screen print
APLSTD : Local menus
This can be changed using a different setup.
Specific Buttons
The following fields are included on the window opened through this button : Block number 1
Block number 2
Close This button is used to copy the record definition from or to another folder. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
incorrect value
A user has attempted to modify a non modifiable chapter (example: chapter 200).
Appendix: number ranges used
The number ranges assigned to the Supervisor module are common to all software written in adonix technology. Click Reserved codes list from the Actions icon in the Chapter field to know the reserved code ranges.
Chapter numbers vary from 1 to 29.999.
The standard Local menus are grouped according to the distinct modules in the software. The table below defines the ranges common to all Sage X3 products:
Number ranges | Number range content |
1-99 | Supervisor |
900-949 | Web |
1000-1999 | Reserved for vertical local menus |
2281-2300 | Crystal report |
2900-2954 | Supervisor |
4000-4999 | Reserved for Add-ons |
5200-5999 | Reserved for vertical local menus |
6200-6999 | Reserved for custom local menus |
8000-8099 | Localization for the USA |
8100-8199 | Localization for England |
8200-8299 | Localization for Spain |
8300-8399 | Localization for Portugal |
8400-8499 | Localization for Italy |
8500-8599 | Localization for Argentina |
8600-8699 | Localization for Germany |
8700-8799 | Localization for Switzerland |
In addition to the local menus, the messages can be entered in the chapters for the number groups reserved for them. The number range 160 to 169 is reserved for custom/specific developments. The messages can this be translated into the languages managed by the folder.
The table below defines the various ranges common to the Sage X3 products:
Number ranges | Number range content |
100-159 | Supervisor messages |
160-164 | Reserved for custom messages |
165-169 | Reserved for vertical messages |
5000-5199 | Reserved for vertical messages |
6000-6199 | Reserved for custom messages |
7800-7999 | Supervisor messages |
8890-8899 | Localization messages for Argentina |
8900-8909 | Localization messages for the USA |
8910-8919 | Localization messages for England |
8920-8929 | Localization messages for Spain |
8930-8939 | Localization messages for Portugal |
8940-8949 | Localization messages for Italy |
8950-8959 | Localization messages for Germany |
8960-8969 | Localization message for Switzerland |
9000-9149 | Adonix engine and client messages |
9300-9322 | Portal |
9700-9899 | Web |
9900-9909 | Adonix console |
9910-9912 | Crystal Report runtime |
9913 | Outlook synchronization |
9914-9949 | --- Reserved for Supervisor |
9950-9960 | FLASH components |
9961-9965 | Designer Process Components |
9966-9999 | --- Reserved for Supervisor |
10000-10029 | Supervisor: fusion client tests |
10030-10035 | --- Reserved for Syracuse |
10036-10037 | --- Reserved for Eclipse |
The various local menu ranges in the application are the following:
Number ranges | Number range content |
100-200 | Miscellaneous |
201-300 | Common data |
301-400 | Manufacturing |
401-500 | Sales |
501-600 | Purchase |
601-700 | Financials |
701-800 | Stock management |
801-899 | Fixed Assets |
950-999 | Customer Relation |
2000-2280 | Ext. Common data |
2301-2400 | Ext. Manufacturing |
2401-2500 | Ext. Sales |
2501-2600 | Ext. Purchase |
2601-2700 | Ext. Financials |
2701-2800 | Ext. Stock management |
2801-2899 | Time / Cost / Ext. Financials |
2955-3099 | Ext. Customer Relation |
3100-3389 | Ext. Fixed Assets |
3390-3400 | --- not yet assigned --- |
3401-3500 | Warehousing interface |
3501-3600 | Ext. Manufacturing |
3601-3700 | Ext. financials |
3701-3999 | --- not yet assigned --- |
10030-10300 | --- not yet assigned --- |
10301-11999 | HRM |
| 11500-11549 UK legislation |
| 11550-11599 Portuguese legislation |
| 11600-11649 Moroccan legislation |
12000-29999 | --- not yet assigned --- |
The various message ranges in the application are the following:
Number ranges | Number range content |
170-199 | Standard messages |
7700-7709 | Accounting messages |
7710-7719 | Common data messages |
7720-7729 | Manufacturing messages |
7730-7739 | Sales messages |
7740-7749 | Purchase messages |
7750-7759 | Stock messages |
7760-7769 | CRM messages |
7770-7789 | Fixed Assets messages |
9150 | ILOG Messages |
9151-9160 | Weighing machine messages |
The following table displays the ranges available for Sage X3 Warehousing:
Number ranges | Number range content |
301-310 | Sage X3 Warehousing messages |
311-400 | Sage X3 Warehousing local menus |
401-410 | Sage X3 Warehousing messages |
411-500 | Sage X3 Warehousing local menus |