+1-757-461-3022 x124

Library

Primary tabs

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
25 users have voted.

Are employee groups required?

No, employee groups are not required. Only use them if you find they will help you organize your employees into different categories.

Was this Helpful?
up
21 users have voted.

Are tax assignments required?

Yes, tax assignments are required if you want xTuple to automatically calculate taxes for you. If you do not bill customers for taxes, then tax assignments are not required.

Was this Helpful?
up
21 users have voted.

Can one item have multiple item sites?

Yes, items can be located in multiple sites. For example, in a manufacturing environment, you might require an item to be located in a factory, a quality shop, and a storage warehouse. Distribution companies locate items in multiple warehouses, allowing them to transfer inventory between sites as the need arises. Keep in mind, though, you must be running a commercial edition of xTuple to have access to multiple sites. You can read more about the different xTuple editions on our comparison page.

Was this Helpful?
up
21 users have voted.

Are incident severities configurable?

Yes, you can define your severities in any way you wish to meet the needs of your organization. And there is no limit to the number of severities you can create.

Was this Helpful?
up
20 users have voted.

Can I create simple invoices?

Yes, if you don't want or need to use sales orders or shipping, you can create simple invoices and get them out to your customers quickly. Just enter an invoice and fill out your line items. You can even update your inventory when the invoice is posted, if you need to.

Was this Helpful?
up
20 users have voted.

When are expense categories used?

Expense categories are used to automate the accounting for non-inventory transactions. The following transaction types use expense categories: non-inventory purchase order line items; miscellaneous vouchers; miscellaneous payables checks; and expense transactions.

Was this Helpful?
up
20 users have voted.

Where can I find the PostgreSQL documentation?

 For more information, please see the PostgreSQL Documentation.

Was this Helpful?
up
20 users have voted.

Why do items require units?

Items require units for two primary reasons. First, units are needed to fully describe item quantities. For example, it is not enough to say, "We have 25 sodas in stock." You would expect instead to hear, "We have 25 cases of soda in stock." Second, units make it possible for the system to convert items from one unit to another. If you stock items in one unit and sell them in a different unit, then the conversion is only possible if units are assigned in the first place.

Was this Helpful?
up
20 users have voted.

Are sales categories required?

Yes, if you sell miscellaneous (i.e., non-inventory) products and services, then you will need to use sales categories. Miscellaneous items inherit their accounting assignments from sales categories.

Was this Helpful?
up
19 users have voted.

What if my key has expired?

Attention: xTuple license keys expire and will cause the software to cease to function. The system provides ample warnings to avoid this. Please make arrangements prior to expiration to renew your key.

If your key has already expired, and you cannot log into the Desktop client

  1. Download the xTuple Updater application for your platform
    1. Windows
    2. MacOS
    3. Linux
  2. Download the license updater package ("regupdater.gz")
  3. Run the Updater application and log into your xTuple database
  4. In the top menu, go to File > Open and select "regupdater.gz"
  5. Click "Start Update" so the Updater can apply the new license
  6. Close the Updater application
  7. Open the xTuple Desktop client and log into your database to confirm the update
Was this Helpful?
up
19 users have voted.

Why do some privileges appear greyed-out?

If a user privilege is greyed-out, this means the privilege belongs to a user account role. Bold-colored checkboxes indicate a privilege is assigned individually to the user. It's possible for users to have a combination of privileges—both individual privileges and privileges inherited from user account roles.

Hint: If you manually select a greyed-out privilege and make it bold, that privilege will remain with the user even if the underlying user account role is removed from their user account.

Was this Helpful?
up
19 users have voted.

Are employee and user the same thing?

Employee and user are not necessarily the same thing. An employee is a person who works for your company. A user is a person who has an account allowing them to access your xTuple database. There are scenarios where database users would not also be employees. For example, you may give user access to people who are not your employees (e.g., IT consultants). Conversely, there are also scenarios where employees wouldn't need user accounts. For example, you may have employees whose job doesn't require them to use a computer—and so there would be no need for them to have a user account.

Was this Helpful?
up
18 users have voted.

Are the advanced characteristic options required?

The advanced characteristics options—available only to text type characteristics—are not required. You may use text type characteristics without using the advanced options. The two advanced options are input mask and validator. An input mask creates a template to guide users as they enter values for a characteristic. It is a form of light data validation. For example, if you specify the input mask 00/00/0000, then users will be presented with the following template when they are entering values for the characteristic : "__/__/____". In this case, users will simply have to fill in the blanks between the separators. A validator is used to strictly enforce the format of data users can enter in a field. If you specify a validator for a characteristic, then users will have to conform to the format when entering values for the characteristic. Values which do not conform will not be accepted.

Was this Helpful?
up
18 users have voted.

Can an item have more than one item source?

Yes, since you might purchase an item from multiple different vendors, it's possible to have multiple item sources for a single item. Use the vendor ranking option to sort your item sources from best to worst. The vendor ranking comes into play when you release planned purchase orders. At the time of release you will be asked to select an item source. The item sources having the highest vendor ranking will appear at the top of the list.

Was this Helpful?
up
18 users have voted.

In the tax system, how is the calculation basis used?

The calculation basis is used to determine how taxes should be applied. Choose the base price option to have taxes calculated off the base price of sold items. For those requiring more complex tax scenarios (i.e., nested taxes or "tax on tax"), the calculation basis can be linked to any other tax code which uses the same tax class. When another tax code is chosen as the calculation basis, taxes will be calculated against the derived amount from the referenced tax code.

Was this Helpful?
up
18 users have voted.

Is it possible to change the name of a default country?

Yes, if you want a different country name for your default country, you can switch off the limit to list setting. Be sure to turn this setting off with caution, since manually entered countries will not be kept up-to-date in the same way that standard countries are. In addition, pre-defined states and provinces will not be available to countries with a custom naming convention.

Was this Helpful?
up
18 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
18 users have voted.

Why do item sites require a planner code?

Planner codes are required on item sites for reporting purposes—and also to support the advanced planning and forecasting capabilities found in commercial editions of xTuple. For example, with planner codes you can create different reports and schedules for raw materials and finished goods.

Was this Helpful?
up
18 users have voted.

Are opportunity sources required?

Yes, an opportunity source is required when creating an opportunity. That means you must have opportunity sources defined before you can successfully save an opportunity.

Was this Helpful?
up
17 users have voted.

Are shifts required?

No, shifts are not required. If your company doesn't use shifts, then you do not need to add them—or assign them to employees.

Was this Helpful?
up
17 users have voted.

Can employees belong to more than one employee group?

Yes, there is no limit to the number of employee groups an employee can belong to.

Was this Helpful?
up
17 users have voted.

Are incident categories required?

Yes, every incident must be assigned to a category. Because incident categories are the highest-level grouping mechanism available to incidents, they are required.

Was this Helpful?
up
16 users have voted.

Are transit sites required?

Yes, transit sites are required for all transfer orders. Transit sites keep track of your inventory while it is in transit (i.e., in a truck, on a container ship, etc.). Transfer order items are shipped from the shipping site to the transit site and then are received at the receiving site from the transit site. You can configure transfer orders to be automatically received—or you can require a manual receipt transaction.

Was this Helpful?
up
16 users have voted.

What IP address should I put in my pg_hba.conf file?

That's called CIDR notation. Here's a handly calculator for figuring out an appropriate value: http://www.subnet-calculator.com/cidr.php.

You need to know a little about the network you're setting the server up on and a bit about subnetting. A client may need to allow various networks to connect - they may have several subnets, etc - each network from where you want to allow connections from needs to have an entry in the pg_hba.conf, or at least a rule that fits. 0.0.0.0 is a catch-all - any address will match with that rule.

But, suppose you have a remote office, with a fixed IP on their router - all traffic from inside the office goes out with the same WAN IP of that router, say the WAN IP is 129.42.60.216 - that's a single address from a single device. So, on your postgres server where they are connecting to you would create a pg_hba.conf entry similar to:

host all all 129.42.60.216/32 md5 /32
is the same as
255.255.255.255 ( 1 address) /24
is the same as
255.255.255.0 (254 addresses)

Also, keep in mind that the pg_hba.conf file is read top to bottom. As soon as Postgres finds a rule that allows access, it stops reading rules - so make sure your access rules make sense. You can do all sorts of interesting things with the pg_hba.conf. Read the comments at the top of that file.

Was this Helpful?
up
16 users have voted.