+1-757-461-3022 x124

Library

Primary tabs

How do I drill down into inventory history?

The advanced search panel gives you the most control when trying to locate specific records or groups of records in inventory history. Click on the advanced search button in the main menu to open the advanced search panel. Using advanced search, you can specify multiple different parameters—making it possible to drill down and reach the specific records you are looking for.

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

My product is not showing up in the right group on the xTupleCommerce website. Where do I fix this?

The product catalog is managed in the xTuple ERP database. You’ll want to check the product catalog to make sure the product is in the right group.

Navigate to the item in the xTuple ERP database. Then, under attributes, look at the table on the bottom of the window. The group name will identify which group(s) the item is associated with in the catalog. 

If the item should be showing in a different group, navigate to the item groups via Products > Item > Groups. Then select the group you want to edit and make any needed change. 

Was this Helpful?
up
140 users have voted.

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

Why don't my non-inventory receipts show up on the Uninvoiced Receipts|Returns report?

Because non-Inventory Items, by defintion, do not have Item Sites, you cannot view receiving information for them on an individual Site basis. That's why you have to select the "All Sites" option on this report to see your non-Inventory activity.

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

Do I need to assign priorities?

No, you are not required to set a priority when creating an incident. Priorities are optional. If you don't want or need to assign priorities to incidents then you can simply ignore them.

Was this Helpful?
up
138 users have voted.

When do I use tax classes?

Tax classes are needed for managing complex tax scenarios—for example, tiered, nested, or cumulative taxes. With tax classes, you can manipulate the sequence in which tax codes are applied. By applying multiple tax codes in the correct order, you can build support for even the most complicated tax requirements.

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

Why doesn't xTuple work on my PowerPC Mac?

As of version 3.6.0, xTuple no longer supports the PowerPC Mac platform. Only the Intel Mac platform is supported. Prior versions of xTuple did support PowerPC Macs, but beginning with version 3.6.0 xTuple no longer supports PowerPC Macs.

Was this Helpful?
up
138 users have voted.

Can I change a customer's customer type?

Yes, you can change the customer type a customer is assigned to. To do this, open the customer record for editing and select a different customer type. Once you save the change, the customer will be associated with the new customer type.

Was this Helpful?
up
137 users have voted.

How is the vendor unit ratio used?

The unit ratio specifies the ratio between inventory and vendor units of measure (UOM). For example, if you stock an item in single units, but a vendor sells you the item in cases of 12, then you would enter "12" as the vendor unit ratio (i.e., 12:1). If the ratio is 1:1, then enter "1" as the unit ratio. Having a defined vendor unit ratio allows you to purchase inventory in the vendor's UOM. However, on receipt that inventory will be converted automatically to your inventory UOM.

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

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

What are some examples of sale types?

Because sale types are user-defined, you can set them up any way you want to. Some examples of sale types might include in-networkout-of-networkretailwholesale, etc. Depending on how granular you want your revenue reporting to be, you can link your sale types to different revenue accounts using the sales account assignment interface.

Was this Helpful?
up
135 users have voted.

Where are priorities used?

Priorities are used by incidents. The priority assigned to an incident helps determine the relative importance of the incident. Sample priorities might include "Very Low," "Low," "Normal," "High" and "Very High."

Was this Helpful?
up
135 users have voted.

Can time and expenses be charged to customers?

Yes, time and expense information entered on worksheets can be billed directly to your customers. Billing rates can be entered on an ad hoc basis—or you can set up pre-defined rates for your customers at the project task level.

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

How do I get started with sales analysis?

To get started analyzing your sales performance, follow these steps:

  1. Select a cube
  2. Select a dimension (e.g., customer)
  3. Select a dimension level (e.g., customer name) or drag the level to columns or rows
  4. Select a measure (e.g., amount, booking) or drag the measure to columns or row

You should now see a table of measures organized by the dimension you chose. You can continue selecting dimensions and measures to analyze your data in other ways.

Was this Helpful?
up
134 users have voted.

How do I start a new language translation?

If you are interested in starting a new language translation, please see the article "Starting a new translation project."

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

What if an employee changes shifts?

If an employee is going to be changing shifts, a manager or other administrator needs to assign the new shift to the employee's master record. If the new shift isn't assigned to the employee, the rules of the old shift will continue to apply to the employee.

Was this Helpful?
up
134 users have voted.