+1-757-461-3022 x124

Library

Primary tabs

What is a site?

Sites are locations where inventory is physically produced or stored. Item sites, site locations, and work centers all belong to sites. Examples of sites would include (but not be limited to) production facilities, shipping warehouses, storage warehouses, and quality control centers.

Was this Helpful?
up
564 users have voted.

Do I need reason codes?

No, reason codes are optional. They add a layer of information which can be useful for reporting purposes. However, they are not required. You do not have to use reason codes if you prefer not to.

Was this Helpful?
up
554 users have voted.

What's the difference between inventory and transit sites?

Assuming you are operating in a multi-site environment, the majority of your sites will be inventory sites. An inventory site is a site where inventory is physically produced or stored. Transit sites, on the other hand, are a type of temporary site used by transfer orders to hold inventory when it is in-transit between two sites. A transit site could be a truck, a shipping container, or a ship. If you are not using transfer orders, then you will not have access to transit sites.

Was this Helpful?
up
553 users have voted.

Are item groups required?

No, unlike class codes or product categories, item groups are not required. Only use them if you need an alternate way to categorize your items not already offered by the other grouping methods.

Was this Helpful?
up
546 users have voted.

What is multiple location control?

Multiple location control (MLC) is an item site setting which adds granular control over how inventory is managed. With MLC enabled, you can create multiple locations within a single item site. This makes it possible for you to move inventory from location to location—all within the item site. MLC adds transactional overhead but can be useful if detailed tracking of inventory is required. MLC should not be confused with multi-site, which allows for inventory to be moved between multiple sites (e.g., warehouses, stores, etc.).

Was this Helpful?
up
542 users have voted.

Why do item sites require a cost category?

The link between cost categories and item sites establishes the basic foundation for item accounting. Whenever items are sold, purchased, manufactured, etc., the accounts defined at the cost category level determine how these item transactions are accounted for. The general ledger activity and financial reports related to inventory movement tie directly back to cost category assignments.

Was this Helpful?
up
539 users have voted.

What is an item?

Items are the products or services related to your business. In an inventory business, for example, items would be the products you buy or make or sell. The items in a service business would be the services you provide to your customers. All items must be associated with a class code. The class code is a useful mechanism for grouping similar items together. In addition, items may be sold--or not. If they are sold, items must have a product category assigned to them. Product categories make it possible to group sold items for reporting and also accounting purposes.

Was this Helpful?
up
536 users have voted.

I use partial quantities on my bills of materials (BOMs), so why are my costs so inflated?

If this is happening to you, check your Item masters for the Items in question. Make sure the "Fractional" option is selected for any Items which you plan to use in partial quantities. If that flag is not selected, then the costs for the Item will be rounded up to the next whole number. This upward rounding would explain your inflated costs.

Was this Helpful?
up
535 users have voted.

How do I add an item group to the product catalog for my xTupleCommerce site?

You are able to add new item groups in the xTuple ERP database via Products > Items > Groups > New. From there, fill out the appropriate fields, add any parent groups or member items, and save.

If you want the item group to have an image on the xTupleCommerce site, you are able to attach documents. Reminder: documents must be in the form of a URL.

Was this Helpful?
up
534 users have voted.

How do I enter my opening balances in the General Ledger?

We recommend entering G/L Chart of Account opening balances using one of two possible methods described in the document Entering Opening Balances.

Was this Helpful?
up
530 users have voted.

How does explosion work?

Work order explosion is the process whereby work order material (and routing) requirements are created for a work order. These requirements are pulled from the bill of materials and routing for the manufactured item. If you choose to automatically explode work orders, these requirements will be created when work orders are created. Otherwise, work orders will have to be exploded manually.

Was this Helpful?
up
514 users have voted.

What are characteristic types?

Characteristic types control the behavior of characteristics—and also their fomatting. The following characteristic types are supported: text, list, and date. The text type is a free-form text string. Text type characteristics have access to the input mask and validator options. The list type should be used to present a list of possible values. The date type supports date strings. The formatting of date type characteristics conforms to the user's locale.

Was this Helpful?
up
514 users have voted.

If I don't manage inventory do I need cost categories—or item sites?

The short answer is, no. If managing inventory is not part of your business, then you don't need cost categories—or by extension, item sites. It is possible, of course, to have a mixed environment. Many service businesses will handle some inventory. And inventory-focused businesses will have some number on non-inventory parts. xTuple supports all these scenarios.

Was this Helpful?
up
510 users have voted.

How is the xTupleCommerce product catalog structured in the xTuple ERP database?

The product catalog is a collection of categories which items may be grouped into. Think of it as being like the physical catalog department stores might use. The following terms are used:

  • Parent group: The parent group is typically a very generalized group of items. For example, if you had a shoe store, the parent groups might be men’s shoes, women’s shoes, kids’ shoes, etc.
  • Item groups: Item groups are more specific groups within the parent group. If the parent group is women’s shoes, the item groups may consist of sandals, sneakers, pumps, boots, etc.
  • Member items: Member items are the individual items within the item group. If we selected the sneakers item group, the member item would be the exact red sneaker that a customer may add to their cart for purchase. 
Was this Helpful?
up
500 users have voted.

Can I report on activity by site type?

Yes, you can write custom reports to capture information about your sites according to their site type.

Was this Helpful?
up
488 users have voted.

How can I learn more about project accounting?

The topic of project accounting 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
483 users have voted.

Can I sort the order of the promo images on my xTupleCommerce website?

Yes, the sort order of promo images is managed on the xTupleCommerce website.  After logging into the xTupleCommerce website, navigate to Admin > Structure > Nodequeues.  You'll see a list of the nodequeues for your site. One of the operations you can perform is View. 

You can reorder the carousel images by moving the image records up or down,  using the arrows on the far left.  Make sure you save when you're done, otherwise the new order will not apply.

Note: In order to add a carousel image, you will need to create it from the promo content type first. 

Was this Helpful?
up
481 users have voted.

Do ship zones support regional pricing?

Yes, regional pricing is supported using ship zones. To create regional pricing, go to the pricing schedule interface—where it's possible to create special pricing for individual (or multiple) ship zones.

Was this Helpful?
up
481 users have voted.

Should I enable routings?

If you want to the ability to track production labor costs on an operation-by-operation basis, then you need to turn on routings. Routings provide the most granular method for tracking labor costs. If granular tracking of labor costs related to production is not a concern, then you can keep routings disabled.

Was this Helpful?
up
474 users have voted.

What are reason codes?

Reason codes provide a means for explaining to customers why they are being given sales credit. They are also useful for reporting purposes, as they help explain more why associated documents were created.

Was this Helpful?
up
474 users have voted.

Can one item have multiple item sites?

Yes, items can be located in multiple sites. For example, in a manufacturing environment, you might require an item to be located in a factory, a quality shop, and a storage warehouse. Distribution companies locate items in multiple warehouses, allowing them to transfer inventory between sites as the need arises. Keep in mind, though, you must be running a commercial edition of xTuple to have access to multiple sites. You can read more about the different xTuple editions on our comparison page.

Was this Helpful?
up
460 users have voted.

Is it possible to have more than one site?

Yes, most commercial editions of xTuple allow unlimited sites. The PostBooks® edition limits users to one site. You can read more about the different xTuple editions on our comparison page.

Was this Helpful?
up
458 users have voted.

What size should my product related images be for them to fit correctly on my xTupleCommerce website?

To ensure that your product-related images appear properly on the xTupleCommerce website, we suggest using the following sizes:

Item Group Image Sizes

  • Item group image - 160px wide x 90px tall

Product Image Sizes

  • Horizontal Product Image - 1000 x whatever is needed
  • Vertical Image - whatever is needed x 1000
  • Maximum Size - 1000 x 1000
  • Minimum Size - 360 x 360

More information about Product Images

The product images are added to the item master in the ERP. The images are automatically resized for the various places they are used which include:

  • All Products Page (thumbnails)
  • Product Details - Main Image
  • Product Details - Thumbnails
  • Product Details - Magnification
  • Suggested Items (thumbnails)

To optimize the user's experience we suggest using large images (maximum of 1000px x 1000px) then letting the system scale them down.

All Products Page - The space that is available for images on the All Products page is 260 x 135. Images that are larger will be sized down to fit in this area and stay in proportion to the original size.

Product Details Page - The space that is available for images is 360 x 360 however, larger images can be used. If the Product image is larger than 360 x 360, when the user rolls over the image with their cursor, a “Magnifying Glass” will zoom into the area that the cursor is over.

Recommended Product Image Size - The best product images are in ratio to 237x125. This size is a perfect fit for the Products page. If you increase this to be a perfect fit for the Product Details page, the size would be 360 x 190. Images in ratio to these sizes will render the best on the website. The ideal Product Image size is 1000 x 528, but we understand not all product images will fit into that space in an optimal fashion.

More image information

To learn more about Image Sizes for xTupleCommerce, see this xTupleU article

Was this Helpful?
up
456 users have voted.

What do the different work order statuses mean?

Open ("O") is the initial state a work order receives when it is first created. Work orders are considered exploded ("E") once material requirements (and routings) have been generated for the order. Released ("R") is the status work orders reach when they have been released to the shop floor. Some actions—such as time clock entry—cannot be performed until a work order is released. Work orders are considered in-process ("I") once material requirements have been issued to the order. Closed ("C") is the final status reached when a work order is closed.

Was this Helpful?
up
451 users have voted.

What is XSLT?

XSLT stands for Extensible Stylesheet Language Transformations, which is a part of the XSL family defined by the World Wide Web Consortium (W3C). To learn more, please see our article describing a simple XSLT example.

Was this Helpful?
up
449 users have voted.