+1-757-461-3022 x124

Library

Primary tabs

How long can my item numbers be?

There is no limit to the length of item numbers.

Was this Helpful?
up
495 users have voted.

Where can I find the PostgreSQL documentation?

For more information, please see PostgreSQL Documentation.

Was this Helpful?
up
493 users have voted.

Do you have any freight class examples?

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 bulkbreak bulkcontainerair, etc. You could also model your freight classes after the National Motor Freight Classification (NMFC).

Was this Helpful?
up
484 users have voted.

How do I become a translator for xTuple?

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.

Was this Helpful?
up
482 users have voted.

Are departments required?

No, departments are not required. You don't need to define departments—and associating them with employees is optional.

Was this Helpful?
up
477 users have voted.

Where can I find reporting by department?

The employee search screen allows you to filter employees by department. You can also write custom reports to include department and other employee information.

Was this Helpful?
up
475 users have voted.

How do translation files work?

To learn more about how translation files work, please see the article "Getting and Using xTuple Translation Files."

Was this Helpful?
up
470 users have voted.

Are freight classes required?

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.

Was this Helpful?
up
467 users have voted.

What is OAuth?

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.

More on OAuth 2.0 Standards available at Internet Engineering Task Force (IETF).

Was this Helpful?
up
467 users have voted.

How does explosion work?

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.

Was this Helpful?
up
465 users have voted, including you.

What does "Error on socket 0" mean?

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.

Was this Helpful?
up
459 users have voted.

How can I learn more about project accounting?

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.

Was this Helpful?
up
444 users have voted.

Can I clock into a shift without clocking into a work order first?

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.

Was this Helpful?
up
440 users have voted.

How are employee groups used?

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).

Was this Helpful?
up
437 users have voted.

How do freight classes impact freight pricing?

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.

Was this Helpful?
up
434 users have voted.

Should I enable routings?

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.

Was this Helpful?
up
430 users have voted.

How do I fix 'ERROR: function “xt.js_init” does not exist' when upgrading to xTuple ERP v4.x?

This is a problem with certain combinations of xTuple ERP upgrade packages and plv8. The solution is to run the following SQL script before upgrading:

-- xtuple/lib/orm/source/create_xt_schema.sql
do $$
declare
count integer;
query text;
begin
/* Only create the schema if it hasn't been created already */
perform *
from information_schema.schemata
where schema_name = 'xt';

get diagnostics count = row_count;

if (count > 0) then
return;
end
if;

query =
'create schema xt;';
execute query;

query =
'grant all on schema xt to group xtrole;';
execute query;
end; $$ language
'plpgsql';

-- xtuple/lib/orm/source/create_plv8.sql
-- 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;
Was this Helpful?
up
411 users have voted.

How do I install uuid-ossp?

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.

Was this Helpful?
up
410 users have voted.

What is XSLT?

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.

Was this Helpful?
up
408 users have voted.

Are files stored in the database?

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.

Was this Helpful?
up
386 users have voted.

How are departments used?

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.

Was this Helpful?
up
386 users have voted.

What are extensions?

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.

Was this Helpful?
up
380 users have voted.

What is credit card test mode used for?

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.

Was this Helpful?
up
380 users have voted.

How long does xTuple store my backups?

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.

Was this Helpful?
up
356 users have voted.

Why can't I log into the community site?

We recently upgraded our forum software, in an ongoing effort to improve our community site. During this transition, you may experience problems with your login on either xTuple.org or on our new forum site. Because these are currently separate sites, it's possible your password on one or the other may get out of sync —though your user name should be the same in both places. If one (or the other) of your passwords gets out of sync, simply request a new password. In this way, you can synchronize your passwords manually. In the near future, we plan to implement a single-sign on solution, which will solve this issue going-forward.

To learn more about our forums, please see our webmaster's recent blog post on the subject.

Was this Helpful?
up
350 users have voted.