+1-757-461-3022 x124

Library

Primary tabs

How do I import data into xTuple?

There are two methods for importing data into the database of xTuple ERP.

  • CSVimp
    First, xTuple offers a free application called CSVimp that is designed to migrate Comma Separated Value (CSV) files into the database for the xTuple Applications (The same tool works for PostBooks®, Standard and Manufacturing Editions). You can download CSVimp from our SourceForge project site. And detailed instructions for using CSVimp are available in our documents section.
  • xTuple API
    The second method is to use the API. The goal of the xTuple Application Programmer Interface (API) is to make migrating data directly into the database much safer and easier than it is going directly into the regular table structure. Our appoach is to allow users to create, access, and update xTuple documents using a special database schema that closely mirrors the graphical user interface (GUI). You can read more about using the API to import data into xTuple ERP in the docs section.
Was this Helpful?
up
616 users have voted.

What API keys and fields are required to use FedEx with xTupleCommerce?

If you want to include FedEx in the list of shipping options for your xTupleCommerce customers, you'll need to acquire API keys from FedEx, for both your production and development environments. Once you have the information and have added the keys to the ERP, the keys will need to be added to the xTupleCommerce website.

Here is an outline of the fields you need for both the production and development keys: 

Production Keys

  • Account Username
  • Account Password
  • Authentication Key
  • Meter Number
  • Account Number
  • Production API Password
  • Production URL

Development Keys

  • Account Username
  • Account Password
  • Test Key
  • Test Key Password
  • Test Account Number
  • Test Meter Number
  • Test URL
Was this Helpful?
up
616 users have voted.

What are item characteristics?

Item characteristics are used to create additional layers of information about items. For example, let's say you sell toy trucks. You might use item characteristics to define the various options available on your toy trucks—such as paint color or decal kit. Taking the color example, your toy truck characteristics might include "Red," "Green," "Blue," and "Yellow." Item characteristics are useful for reporting purposes. They also play a key role in the assemble-to-order configuration system.

Was this Helpful?
up
614 users have voted.

Can I add PDFs to an item and have them show up on my xTupleCommerce website?

Yes, you can add documents, such as PDFs, to individual items in the same way that you would add images linked to items. Like item images, the PDFs need to be stored on a separate web server, with a unique URL for each PDF. However, the ERP should contain cross references to these PDFs, via their URL.

To enter URLs for PDFs in the ERP, go to the item master for the item in question and follow these steps:

  1. Select the documents tab
  2. Choose the ATTACH button
  3. Next to the "related to" option, choose the "website" option from the list
  4. Enter the URL for the PDF
  5. Specify a name to identify it

The PDF will show up on the product page as a link for the user to view and download.

Was this Helpful?
up
613 users have voted.

I updated information in the ERP, but it’s not showing up on my xTupleCommerce website. What could be happening?

Some information may not show up on the xTupleCommerce website immediately. Instead, it stays in the cache. Think of the cache as a net that holds on to some of the changes.

To manually flush the cache (release the net of changes), log in to your xTupleCommerce website. Then navigate to Admin > Icon > Flush all Cache and select to flush all the cache.

Note-If after flushing the cache the formatting of the site looks like it has changed, refresh the page and it should go back to normal. 

 

Was this Helpful?
up
613 users have voted.

What is the default location?

The default location is the location within an item site where you want your inventory to be put or taken from by default. Having default locations can simplify the process of handling inventory when multiple location control is being used. For example, users can transfer inventory into/out of an item site using a default location button—without having to pick a location from a list of available locations. Default locations are not required but they do help reduce complexity.

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

What are planner codes?

Planner codes provide a mechanism for categorizing items for planning purposes. For example, let's say you want to develop separate plans for raw materials versus finished goods. To do so, you would first create separate planner codes: one for materials and one for finished goods. You would then link the materials planner code to the item sites for your materials—and the finished goods planner code to the item sites for your finished goods. From that point on, you can run the planning systems and planning reports by individual planner codes to see the detail separately for each.

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

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
589 users have voted, including you.

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

How are site types used?

Site types are used to categorize sites. For example, you might have distribution sites or shipping sites or storage sites. Having the ability to categorize sites is primarily a feature designed for multi-site environments.

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

How is the start date of a work order determined?

The start date of a work order is determined based on the due date minus the lead time. The lead time for an item is found on the item site record. For example, if the due date is February 15 and the item site lead time is five days, the start date for the work order would be February 10.

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

My xTupleCommerce account is temporarily blocked due to 5 failed attempts to login. How can I get into my xTupleCommerce website?

Unfortunately, you will have to wait until the system clears your IP Address for access. We do not have access to manually do this. The system may take an hour, 4 hours, or even 8 hours to clear your IP Address as there is no standard amount of time for it to cycle through. This is one of the main reasons we encourage our users to change their password to something easy for them to remember.

Was this Helpful?
up
563 users have voted.

Where are reason codes used?

The following document types can have reason codes associated with them: receivable credit memos, receivable debit memos, and return authorizations.

Was this Helpful?
up
559 users have voted.

How do I retrieve API keys from UPS?

If you would like to include UPS in the list of shipping options for your xTupleCommerce customers, you'll need to acquire API keys from UPS. Once you have the information and have added the keys to the ERP, the keys will need to be added to the xTupleCommerce website.

Here are the instructions on how to retrieve the API keys from UPS:

  1. Go to - UPS login 
  2. Log in with your account information
  3. Click SUPPORT in the main menu
  4. In the browse by topic section, click UPS Developer Kit 
  5. Inside the access and administration, click Manage Access Keys 
  6. Click Request New Access Key 
  7. Follow the instructions
  8. Capture the keys
  9. Deliver the keys to xTuple - follow the instructions for Sharing API Keys from the bottom of this article

Note: Most systems delete old keys when new ones are created. Your keys could be used across multiple systems so it’s a very good idea to create these keys once and save the information in a safe place for future use. 

Was this Helpful?
up
547 users have voted.

What kinds of planning systems does xTuple offer?

xTuple offers four primary planning systems: material requirements planning (MRP); distribution resource planning (DRP); master production scheduling (MPS); and lean/constraint management. You must be running a commercial edition of xTuple to have access to these planning systems. For more information on which planning systems are available in which editions, please see the xTuple comparison page.

Was this Helpful?
up
544 users have voted.

How long can my item numbers be?

There is no limit to the length of item numbers.

Was this Helpful?
up
539 users have voted.

Do site types have an impact on the function of sites?

Site types have no impact on the function of sites. A site type designation is informational only. Site types are different from the basic site classification—namely whether a site is an inventory site or a transit site, both of which do impact how a site functions.

Was this Helpful?
up
538 users have voted.

Why does the ship zone change on my sales order?

If you are using ship-to addresses, that would explain why the ship zone changed on your sales order. Each ship-to address has its own ship zone. When you change ship-to addresses, the ship zone on the sales order may also change. By default, the ship zone at the ship-to address level will be used.

Was this Helpful?
up
537 users have voted.