For more information, please see PostgreSQL Documentation.
For more information, please see PostgreSQL Documentation.
The employee search screen allows you to filter employees by department. You can also write custom reports to include department and other employee information.
Yes, the configuration of extensions (e.g., modules, like CRM) needs to be performed on each database used by your company. This flexibility allows you to configure different databases for different purposes. For example, let's say you want to pilot new features in a sandbox database. You would want to enable those new features in the sandbox for testing purposes. However, you wouldn't want to turn those features on in your production database until after you have piloted them.
If you are interested in getting involved with xTuple user interface translation, please review the following articles: Starting a new translation project and Getting and Using xTuple Translation Files. Translators will also find useful the Translation Glossary, which provides explanations of unfamiliar words/terms found in the user interface.
The names given to freight classes are user-defined in xTuple. This means you can set up freight classes however you want to. Some examples of freight classes could include bulk, break bulk, container, air, etc. You could also model your freight classes after the National Motor Freight Classification (NMFC).
Work order explosion is the process whereby work order material (and routing) requirements are created for a work order. These requirements are pulled from the bill of materials and routing for the manufactured item. If you choose to automatically explode work orders, these requirements will be created when work orders are created. Otherwise, work orders will have to be exploded manually.
There is no limit to the length of item numbers.
To learn more about how translation files work, please see the article "Getting and Using xTuple Translation Files."
OAuth is a protocol (or framework) that supports authorization workflows. OAuth is not an API or a service: it is an open standard for authorization that any developer can implement. It gives you a way to ensure that a specific user has permissions to do something.
This protocol allows third-party applications to grant limited access to an HTTP service, either on behalf of a resource owner or by allowing the third-party application to obtain access on its own behalf. Access is requested by a client, which can be a website or a mobile application, for example.
xTuple uses OAuth2 (or OAuth 2.0), the second version of the OAuth protocol. OAuth2 simplifies the previous version and facilitates interoperability between different applications. OAuth1 adn OAuth2 specifications are completely different from one another, and cannot be used together: there is no backwards compatibility between them.
The OAuth2 protocol is constantly evolving and acclaimed by Internet giants such as Google and Facebook.
Freight classes are only required if you are using pricing schedules to automatically calculate freight charges during sales order entry. Pricing schedules include freight classes as one factor in their pricing matrix. Using this matrix, it's possible to define pricing schedules by freight class.
That error typically indicates there is either an incorrect mail server configuration or a network problem of some kind. Check the mail server options in the xTuple Connect menu. Also check your mail server and network routing to make sure all is in order.
Employee groups are used to assign employees to various categories for reporting and other purposes. Since employee groups are user-defined, you can set them up any way you wish. For example, employee groups might be created for geographic regions (U.S., Europe, Asia, etc.) or commuting preferences (car, bike, public transportation, or telecommute).
The topic of project accounting is covered in some detail in the manual Managing Projects with xTuple. The book can be read online for free or purchased for download through the xTuple MarketPlace.
Freight classes are one part of the matrix making up freight pricing schedules. Other parts of the matrix include shipping zones, sites, ship vias, and weight. Freight classes are linked to items on the item master—where other important information (such as item weight) is also stored. It is this link to item records which gives freight classes their greatest impact on pricing schedules. You can learn more about freight classes and pricing by reading the freight pricing specification.
Yes, you can clock into a shift without first clocking into a work order. That's how you document you've started your shift in cases where work orders aren't immediately available to clock into. When work orders become available, you can clock into them later in your shift.
If you want to the ability to track production labor costs on an operation-by-operation basis, then you need to turn on routings. Routings provide the most granular method for tracking labor costs. If granular tracking of labor costs related to production is not a concern, then you can keep routings disabled.
XSLT stands for Extensible Stylesheet Language Transformations, which is a part of the XSL family defined by the World Wide Web Consortium (W3C). To learn more, please see our article describing a simple XSLT example.
The extension uuid-ossp is distributed with most newer versions of PostgreSQL. To confirm your PostgreSQL installation includes the extension, check for the uuid-ossp files in the following directory: install_directory\PostgreSQL\9.x\share\extension\.
Assuming the extension is installed, simply run the following SQL statement against your target database:
create extension if not exists "uuid-ossp";
You should add the entension to each database you use. Also add it to the template1 database, so that any future databases you create from template1 will inherit the extension.
begin /* Only create the schema if it hasn't been created already */
where schema_name = 'xt';
get diagnostics count = row_count;
if (count > 0) then
query = 'create schema xt;';
query = 'grant all on schema xt to group xtrole;';
end; $$ language 'plpgsql';
-- dummy function avoids forward reference bug with some plv8 versions
CREATE OR REPLACE FUNCTION xt.js_init(debug BOOLEAN DEFAULT false, initialize BOOLEAN DEFAULT false) RETURNS VOID AS $$ BEGIN RETURN; END; $$ LANGUAGE plpgsql;
CREATE EXTENSION IF NOT EXISTS plv8;
When adding a file, you have the option to specify that you want the file to be saved in the database. Saving a file in the database makes the file easily accessible to other users of the database. If you prefer not to save files in the database, your other options are to store them locally on your machine or on a network drive.
Hint: Keep in mind that storing large files in your database will increase the size of your database and will require you to monitor your hard drive consumption.
Employees can be linked to the departments they work for. There's no limit to the number of departments you can define. However, each employee can only be linked to one department at at time.
The test mode is used for setting up and configuring credit card processing at your site. When in test mode, you can verify your configuration is correct and that all your credit card transactions are flowing smoothly.
Warning: Make sure you de-select this option when you are ready to move into production mode. Most credit card transactions will appear to succeed whether running in test mode or live mode—but there will be no actual charges made if in test mode.
Extensions are features—usually groups of features—which extend the core xTuple functionality. Common examples of extensions include modules (e.g., CRM) and packages (e.g., Time & Expense). Extensions must be administratively linked to individual databases before database users can access them. Some extensions are commercial and must be purchased, whereas others are free and available on demand.
xTuple stores a minimum of the 5 most recent backups plus one backup each week for a minimum of 1 year. Because of network related problems the most recent backups may not always be consecutive by day.
The credit taxes option should be enabled if you want to ensure tax payments are credited when processing early payment discounts. This option is selected by default. If not selected, taxes will not be credited when early payment discounts are processed.