Advanced system features (all)

Advanced data structure

The data structure of X-Cross makes full use of the advanced features of the modern databases:

Transactions
Referential integrity
Stored procedures
Triggers
Views

for the best possible operating speed and reliability of the data structure.

Multilevel objects

The extremely advanced CrossModel data modeler allows X-Cross to use multilevel data structures that dramatically improve the speed and the usability of the software.

Furthermore, this proprietary database tachnology is the base of the exclusive Total Client Internet technology.

One of the most challenging situations, in a multi-user environment, is how to keep track of what has been modified or deleted. X-Cross offers a very advanced and extremely functional technology to solve this problem.

Tree tables

Many tables used in X-Cross don’t simply have a flat structure, but a hierarchical one, where every element of the table can be connected to a parent one in a node-subnode structure, in which every branch can have a different number of levels.

Record locking

X-Cross offers an advanced and fully functional record locking. The lock of the record is not on the single table, but for all the complex object (e.g an invoice, and order, ect.) that can be composed of multiple tables.

Obsolete records

In many parts of an ERP there can be records that cannot be used any more, but still must remain in the database because thay have been used in old transaction. For example, a VAT code that doesn’t exist any more, a stock item that is not being produced or sold any more, and so on.

In X-Cross, every record of every table can be marked as “obsolete”, and in this way these records still exist, but they cannot be used any more.

Edit search keys

In X-Cross, the relational connections between tables (e.g the connection between and invoice and the client) uses the ID column of the tables, that is a number automatically generated when a new record is inserted.

Thanks to this structure, the search keys that are used to retrieve the records of the table (e.g. the stock item code, the clients catagories codes, the account code, etc.) can be modified at any time, without any consequence on the data structure.

Three tier database access

In a classic client-server program, the client has direct access to the database, and this causes relevant inconveniences:

Reduction of data security
Slow reading of many records, especially in wireless connections
Increase of network traffic

In the X-Cross three tier data server all these inconveniences are eliminated, with a faster and more secure data structure.

Furthermore, this data structure can offer an improved connection stability with respect to the client-server model.

Read, insert, edit and delete rights

Each user can be connected to a class of table limits, that will grant the rights, for each table, to read, insert, edit, delet, read and modify obsolete records, and modify the search key.

Access profiles

Access profiles determine the sections of the program that the user can access, the menus that are available, tha fields that are invisible or disabled, and other options. Thanks to the access profiles, these parameters don’t have to be set for every single user.

Advanced and flexible search engine

In an ERP, the capability to find and retrieve the desired data is of paramount importance. In X-Cross, the search criteria are extremely sophisticated and complete, allowing the user to retrieve all the data that could be needed.

Read, insert and edit data in a single window

In X-Cross, complex objects can be read, inserted and edited in a single window and with a single database transaction.

Read, insert and modify records in parent tables

In an ERP, in many cases there are connections to parent tables, e.g. stock items are connected to invoice lines, accounts to an accounting transaction, etc. X-Cross, thanks to CrossModel, allows the user to read the full data of the connected table in its main window, to modify the value and to insert a new record in the parent table while editing or inserting data in the child one.

Update mulltiple records

In X-Cross the user can update tha value of a field on multiple records at the same time without knowing the database structure, simply selecting the field to update in the single record window.

Insert a copy of any object

In every section of X-Cross, the user can insert a copy of the object that is shown in that section. If the object is a multi level one that includes lists of subtables (e.g an accounting transaction, an invoice, and order, etc.), the duplicate can include the subtables.

Export data from lists to a spreadsheet

In X-Cross, all the lists that are visible on the screen can be exported to a spreadsheet, and the format of export can be customized.

Create reports from lists

In X-Cross, all the lists that are visible on the screen can be printed, and the report layout can be customized.

Windows and fields size

In X-Cross, all the windows can be resized, and they will be reopened in the same position and with the same size. In addition to that, single fields inside the window can be resized, and they will mantain the modified size when the window is closed and reopened.