+1-757-461-3022 x124

Library

Primary tabs

How do I update an item image for xTupleCommerce?

To update an item image, go to the item master in the xTuple ERP database. Once there, navigate to the documents tab and DETACH the old image you no longer wish to use. Then, this is very important, SAVE. This will close the item window. Next, reopen the item window and ATTACH the new image. That should do it.  

Note: If you do not save the item after detaching, the xTupleCommerce site will not recognize that there was a change and, therefore, the image will not show up properly.

Was this Helpful?
up
858 users have voted.

How are returns and return authorizations different?

The primary difference between returns and return authorization is their relative complexity. Returns are quick to process and complete. They are designed for simple scenarios. Return authorizations, on the other hand, are far more complex. They support complicated business processes in a way that simple returns do not.

Was this Helpful?
up
854 users have voted.

How do I change my xTupleCommerce password?

If you’ve forgotten your password, you can click the tab to request a new password on the login page.

If you know your password but want to change it, you can login to the xTupleCommerce website, go to people on the admin bar, find your username, and select EDIT on the far right. From there, you can change and save your password.

Was this Helpful?
up
808 users have voted.

Do you have any product category examples?

Let's say you sell home products. Your product categories might include furniture, bedding, bathroom products and appliances. By contrast, if you sell only one type of product, like toys, you could categorize by the material the toys are made of (i.e., wood, metal, plastic, etc.). Services you sell also need product categories. Sample service categories might include consulting, repairs, and cleaning.

Hint: Consider using the characteristics feature available on items to allow more detailed, custom reporting on the products you sell.

Was this Helpful?
up
792 users have voted.

On an item, what is the difference between inventory units and price units?

Inventory units of measure (i.e., UOM's) are the measure by which items are maintained in inventory. Price units, on the other hand, are the measure for items when they are sold. A single item may have different inventory and price units. Having two different units would apply if you sell items in different units than you stock them in. For example, if you are a beer distributor, you might stock beer in pallets but sell beer in cases. In this example, your inventory unit would be PALLET and your price unit would be CASE.

Was this Helpful?
up
779 users have voted.

What does this error mean: "connection to specified xtuple erp server cannot be made"?

We have spoken with various users who encountered this error and discovered something in common with both. Both had prior installs of other Open Source solutions on their computer, prior to installing PostBooks®. In both cases the the other product also installed an instance of PostgreSQL. It appears the two installations of Postgres are conflicting, and preventing the PostBooks® installer from finishing the install. If you are done for the moment evaluating the other Postgres-powered application, try uninstalling it, and then running the PostBooks® installer again

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

Can an item belong to multiple groups in the product catalog?

Yes, items may belong to multiple groups within the product catalog. There are two ways you can add an item to groups.

If you’re working at the item group level, go to Products > Item > Groups, select the item group and EDIT. From there, you can add items. Even if the item is in another group, it can still be added to other groups.

If you’re working at the item level, go to the item’s attributes tab and attach groups from there.

Note-The item group will need to be created before you can add an item to the item group.

Was this Helpful?
up
723 users have voted.

Why are product categories needed?

You need product categories for both reporting and accounting purposes. On the reporting side, it's helpful when analyzing sales activity to have product category data as one of your available options. Running reports by product category allows you to monitor how groups of sold items are performing. It also enables you to evaluate how groups compare to each other. For accounting purposes, the product category is one of the key factors which determines how sales transactions are accounted for.

Was this Helpful?
up
712 users have voted.

How do I configure my system?

Each database used by your organization has various extensions associated with it. These extensions may be modules (e.g., CRM) or other free or commercial add-ons. For each extension there will be configuration options. In most cases, your system administrator will be responsible for configuring your extensions. However, anyone with the appropriate privileges may also configure extensions.

Was this Helpful?
up
710 users have voted.

What are email profiles?

Email profiles are templates used to format the presentation of outgoing email messages. The profiles can be configured to use contact names, email addresses, and other CRM information stored in the database—thereby increasing automation and reducing the opportunity for errors. Using email profiles, you can standardize your communications with your customers and vendors.

Was this Helpful?
up
703 users have voted.

What are projects used for?

Projects are a tool used to plan and track activity related to specific jobs. The are built primarily using project tasks, which serve as a container for time and expenses related to the project. You can link projects to various types of orders (Sales Orders, Work Orders, Purchase Orders, etc.) and in so doing generate order activity reports by project. The Project Accounting add-on package for xTuple offers additional accounting features for building robust financial reports for your projects.

Was this Helpful?
up
703 users have voted.

How can I learn more about job costing?

The topic of job costing 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
700 users have voted.

Do I need xTuple Connect in order to send emails?

xTuple Connect is required when you send email notifications using the xTuple Desktop. 

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

What is a characteristic role?

Characteristic roles define where characteristics can be used. For example, if you want a characteristic to be associated with contact records, you would select the contact role. Item characteristics would require the item role. And so on. Individual characteristics may be associated with multiple roles. The same characteristic might apply to contacts and addresses and opportunities. If you are having trouble finding a characteristic to associate, it's likely the characteristic role isn't defined properly.

Was this Helpful?
up
679 users have voted.

Our xTupleCommerce website is down. What do we do?

If you are hosting your website on your own web server, we suggest you try rebooting your server. If your website is being hosted on the xTuple cloud, please report an incident and we will reboot it for you.

Was this Helpful?
up
667 users have voted.

What is the goal of project accounting?

The Project Accounting add-on package for xTuple is a solution especially designed for professional services companies, non-profit groups who need fund accounting and manufacturers or distributors with advanced project accounting requirements. At the heart of Project Accounting is the concept of the "virtual" General Ledger (G/L) Account. With Project Accounting, virtual G/L Accounts are built dynamically or "on-the-fly" using a combination of existing G/L Account Numbers and the linked Project Name. Transactions flowing from Project-related Sales Orders, Purchase Orders and Work Orders are generally supported by Project Accounting.

Was this Helpful?
up
667 users have voted.

Why can't I ship my transfer order?

If you are trying to ship a transfer order but it doesn't appear in the list of orders to be shipped, there's a good chance the transfer order has not been released yet. Transfer orders must be open/released before they can be shipped. To release a transfer order, change its status from unreleased to open.

Was this Helpful?
up
664 users have voted.

How do shipment numbers get generated?

Shipment numbers are generated as soon as you issue stock to shipping for an order. The shipment number is pulled from the shipping configuration panel. During configuration, you define the initial shipment number—and then every shipment automatically increments the base shipping number by one. For example, if your starting shipment number is 60001, the second will be 60002, the third 60003, etc.

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

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

How do transfer orders differ from inter-site transfers?

Transfer orders are distinct from inter-site transfers in three primary ways. First, transfer orders allow you to move multiple items all at once between sites—instead of just one item at a time. Second, transfer orders always involve an intermediate transit site, for tracking inventory while it is "in transit." And third, there are reports (i.e., paperwork) associated with transfer orders.

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

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