+1-757-461-3022 x124

Library

Primary tabs

Do I need more than one cost category?

You can certainly run your business using only one cost category. That's all you need to set up item sites and track inventory movements in the general ledger. If you want more detailed inventory accounting, though, you should consider implementing multiple cost categories. For example, you might have a cost category for finished goods and a different one for raw materials. In this way you can track particular item types or groups by different accounts—thus leading to more detailed financial reporting.

Was this Helpful?
up
622 users have voted.

How do we boot a user from the database?

In order to forcefully disconnect a user from the database, you have to find the Process ID (pid) for the backend connection of that user. Each user connection to the database spawns a backend process for their connection. Once you know the pid for the process, you can kill the process. On unix the command would be "kill [pid]" while other OSes may have different ways to kill a process. In order to find the pid you can look at the pg_stat_activity table and the column procid should contain the number you need.

Was this Helpful?
up
621 users have voted.

How do I add tasks to a project?

To add tasks to a project, double-click on the project to display the project detail. Navigate to the tasks tab and press new. Fill in the detail for the task. After you've added tasks to a project, you can also view them on the project tasks master list.

Was this Helpful?
up
620 users have voted.

How do I handle Purchase Order Returns (i.e., rejects) in the vouchering process?

If you are having trouble vouchering a Purchase Order because there are Returns logged against it, then you probably left out an important step: Creating a Credit Memo for the Return. To do this, go to the "Uninvoiced Receipts/Returns" report screen and right-click on the Return record. In the right-click menu is the option to create a Credit Memo for the Return. Once the Credit Memo has been created, you should be able to continue processing your Voucher. Later, you can apply the Credit Memo to an open Voucher.

Was this Helpful?
up
620 users have voted.

How do I update the description of my item for xTupleCommerce?

After you’ve located the item master in the xTuple ERP database, navigate to the marketing tab. Make changes to the description content the description field, then save. After you've closed the item record in the ERP, refresh the item's page on the xTupleCommerce site. If the change does not appear automatically, you may need to flush the cache.

Was this Helpful?
up
620 users have voted.

Which file types can I add to the database?

There are no restrictions on the file types you can add to the database. Everything from office documents to image files to CAD drawings and more is supported.

Was this Helpful?
up
618 users have voted.

What is the cut-off day?

The cut-off day is used by proximo terms to indicate the day of the month on or after which the due date will advance to the next month. For example, if the cut-off day = 10, any invoices dated on or after the 10th will automatically be due the following month.

Hint: Put "0" as the cut-off day to indicate the first day of the next month. For example, if the cut-off day = 0 and the due days = 15, then the due date will be on the 15th of the next month.

Was this Helpful?
up
617 users have voted.

How do I reverse a receivable?

Receivables can be reversed either by application or, in the case of invoices, by voiding. For example, let's say a customer has an open receivables balance of $4500. When that customer sends you a check for $4500, you can apply that cash to the invoice, thus reversing the open balance down to $0. Similarly, credit memos can be applied to invoices (or debit memos) to reduce or reverse a receivable amount. For invoices, you also have the option to void them, which reverses them back to an unposted state.

Was this Helpful?
up
616 users have voted.

What are receivable applications?

Receivable applications are records generated when a receivable is either applied or applied to. For example, when a credit memo is applied to an invoice, that's a receivable application. Similarly, receivable applications occur when cash receipts are applied to open invoices.

Was this Helpful?
up
616 users have voted.

Can class codes be used in reporting?

Yes, xTuple ERP gives you the ability to use class codes as a filter in a variety of different views and lists. You can also always create custom reports to capture the data you need by class code.

Was this Helpful?
up
615 users have voted.

How are characteristics used?

Characteristics provide an easy way to add layers of user-defined information which you can later access for reporting purposes. For example, let's say you want to keep track of birthdays for your most important clients. To do this, create a contact characteristic for birthdays. Then, in the value field for each, insert the contact's date of birth. After this information has been entered, you can run a contact report to see all your contacts' birthdays. Characteristics can be used in many other ways, too—to configure items at the point of sale, to characterize details of sales opportunities, and more.

 

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

How can I make items tax exempt?

The easiest way to make an item tax-exempt is to make sure it is not linked to a tax type. For an item to be taxable, it must have a tax type associated with it. If there's no tax type linked to an item, then tax won't be charged.

Was this Helpful?
up
614 users have voted.

Can I filter by opportunity type?

Yes, you can see all opportunities belonging to a particular opportunity type, you can see them using the opportunity type filter. All the opportunities linked to that opportunity type will be displayed. To view a different opportunity type, select that type and the results will automatically update.

Was this Helpful?
up
613 users have voted.

What are to dos used for?

Most people use to dos to remind themselves of things that need to get done in the future. When combined all together, your to dos are known as your to do list. Using the advanced search feature, you can sort your to do list by any of of the available criteria: due date, CRM account, assigned to user, etc. In this way you can monitor the to dos that are most important to you. To dos are a useful tool for managers, as well. Managers can use the assignment feature to assign to dos to people on their team—thus creating a work flow management system.

Was this Helpful?
up
612 users have voted.

What's the difference between an item and an item site?

An item is the definition for a product, describing things such as what item type the item belongs to, its unit of measure, whether it's sold, etc. Item sites, on the other hand, define an item's physical location within a site. You need item sites if you want to track inventory. The movements of inventory, planning for inventory, and inventory accounting are all tied to the item site.

Was this Helpful?
up
612 users have voted.

Do I need to create a contact before I create a prospect?

You can create the contact associated with a prospect before, during, or after the point when you create the prospect. It's up to you. If you create the contact first, simply search for the contact when you are creating the prospect record—and this will associate the contact. Conversely, to create a contact while entering the prospect, simply choose to create one in the contact field.

Was this Helpful?
up
611 users have voted.

Where can I find the Qt documentation?

For more information, please see the Qt Product Information.

Was this Helpful?
up
611 users have voted.

What are project tasks?

Project tasks are used for budgeting and tracking time and expenses associated with particular project activities. When combined, project tasks present the total time and expenses for a project. The Project Accounting package adds expanded accounting functionality for tracking time and expenses related to project tasks.

Was this Helpful?
up
610 users have voted.

What is a terms code?

The terms code is the primary identifier used to describe billing and payables terms as they appear throughout the application—in drop-down lists, etc. For example, if one of your terms is net 30, then you might use the code NET30 to identify it. Similarly, if your terms are 2% discount in 10 days, net 30, then your code might be 2-10N30.

Was this Helpful?
up
610 users have voted.

Where would I use the default country?

When you implemented xTuple, you identified a country to use as the default when entering new addresses. This saves you the step of entering the country manually. You can override the default country when entering or editing addresses.

xTuple ERP is a multi-currency international system so you can do business with organizations and individuals globally.

Was this Helpful?
up
610 users have voted.

Can I create quotes for prospects?

Yes, you can create quotes for prospects. However, before the quote can be converted (to an order or invoice) the prospect must also be converted. Orders and invoices must be associated with a customer. Converting prospects to customers is an easy process.

Was this Helpful?
up
609 users have voted.

Do I need to assign an incident severity?

No, severities are optional. They are not required when entering incidents. You can enter incidents without assigning a severity.

Was this Helpful?
up
609 users have voted.

Do I need to configure each database separately?

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.

Was this Helpful?
up
609 users have voted.

How do I filter results?

When analyzing your data you can filter the results in several ways. For dimensions, select the dimension name in the rows or columns—then select the available members to show. You can also filter results by dragging dimensions to the filter section, and from there selecting the available members to show.

Was this Helpful?
up
609 users have voted.

Is there a report which shows shipment tracking numbers?

Yes, there are several reports which provide historical tracking number information. Look under Inventory > Shipping > Reports > Shipments. All of the reports in this section include a tracking number column. If you entered a tracking number for an order when you shipped it, then that information will be shown in all of these reports.

Was this Helpful?
up
609 users have voted.