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

Can I manage my item images in the xTupleCommerce website?

Your xTupleCommerce site has the capability of hosting images, PDFs, documents and other media. Once your site is live you can associate these files with Items and Item Groups in the ERP. For instance, you can associate product images with Items in the ERP. Or you can associate Marketing PDFs with Items in the ERP. These images and PDFs will be displayed with the products on the xTupleCommerce site.

If your site is still in the development or testing phases (aka, you are still going to a stage.domain.xtuple.net URL to view your site), we encourage you to use a service such as Cloudinary to host your images and determine URLs.

However, if your xTupleCommerce website has gone live, you can begin using the site to host files and create the URLs needed for the document in the ERP. 

Uploading the files to your xTupleCommerce site :

  1. Go to your xTupleCommerce website and login as a manager or editor. 
  2. Navigate Admin > Content > Files.
  3. Click ADD FILE
  4. Select and upload the image. Typically files must be less than 8MB. 
  5. Click NEXT
  6. Leave the radio button selected for public local files and click NEXT.
  7. Update and fill in the fields for name and file name. The name will show up in the URL path of the image. 
  8. Click SAVE. 
  9. Highlight the path of the image-most recently added files are on the top of the list-and copy.

Associate files with Items or Item Groups in the ERP

  1. Login to your ERP.
  2. Open an Item or Item Group
  3. Go to the documents tab
  4. Click Attach
  5. Choose Web Site from the drop down
  6. Give the file a name in the Name field
  7. Paste the URL into the URL Field
  8. The URL should include your website domain followed by the path that you copied.  
    Example: https://www.yourwebsite.com/files/public/content/media/image.jpg
  9. Click Save 
  10. Save and close the Item and Item Group

Check your work

Navigate to the Item or Item Group where the file should appear on the website

The file should appear. If the file does not appear, you may need to flush the cache on the website.

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

Do you have basic project management information?

The topic of project basics 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
675 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
674 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
664 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
655 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
655 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
651 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
650 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
646 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
643 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
642 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
641 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
640 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
636 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
636 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
629 users have voted.

How long can my item numbers be?

There is no limit to the length of item numbers.

Was this Helpful?
up
620 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
618 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
610 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
607 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
597 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
591 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
591 users have voted.