+1-757-461-3022 x124

Library

Primary tabs

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

Can I change the customer on a sales order?

No, once you link a customer to a sales order that relationship cannot be broken. If you enter a customer number in error, your best option is to delete the sales order and start over.

Was this Helpful?
up
40 users have voted.

Can my customers update their My Account info on the xTupleCommerce site?

Absolutely. When a user logs in to the xTupleCommerce site, they are redirected to their My Account page.  If they are already logged in and have started navigating to other content, they can click the My Account link at the top of the window.

Once they are on their My Account page, they can select the Edit tab to update their primary contact information.

If they want to manage their Shipping Addresses, they can select the Shipping Addresses tab within their My Account page. From there, they can add a new shipping address or update an existing shipping address. 

Note: Customers are not able to update their billing address in their My Account page. That will need to be done in the ERP.

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

How can we post transactions between two different companies?

If you are making journal entries across different companies, you are now forced to keep each company in balance and make your entries happen with standard inter-company accounting procedures. For each company you would create matching Due To/From accounts on the balance sheet. There are lots of ways to set this up but here is a quick example:

Lets assume you are only using the company segment and the account number

Company 01 would need an asset account - 01-1501 Due To/From Company 02
Company 02 would need an asset account - 02-1501 Due To/From Company 01

Now instead of one journal entry you make two, one journal entry per company. Say, for example, we posted some G&A expense to company 01 and need to move it to company 02.

Credit 01-6500 $500
Debit 01-1501 $500

Credit 02-1501 $500
Debit 02-6500 $500

If our inter-company (Due to/from) account started at $0 we would now see a $500 balance in the account for company 01 and a ($500) balance for company 02.

The inter-company account(s) must remain in balance at all times, no exceptions. Any entry made to an inter-company account requires that a corresponding entry be made to the other inter-company account immediately. Any individual using inter-company account must know that they are not allowed to leave their desk if the inter-company accounts are out of balance, no exceptions. Inter-company accounts can really get out of control if people are not careful.

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

How do I change the currency of a bank account?

During initial setup, you can change the currency of a bank account as many times as you want. However, once the bank account has been used (i.e., has had transactions posted against it) you can no longer change the bank account's currency.

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

How do I reimburse employees for their expenses?

To reimburse employees for their expenses, it's necessary to define employees as vendors in the system. The link between employees and vendors can be made on the CRM account screen. Once an employee is a vendor, you can create vouchers for their expenses during the worksheet approval process. Reimbursement checks can be written against these vouchers.

Was this Helpful?
up
40 users have voted.

Is there a limit to the number of customer types?

No, there is no limit to the number of customer types you can define. Keep in mind, though, each customer can only belong to one customer type at a time. If you want to track a single customer by more than one category, try using customer groups.

Was this Helpful?
up
40 users have voted.

What are customer types?

Customer types are the primary category used to classify customers. Many sales reports—and also pricing schedules—are tied to customer types. Because of this importance, every customer is required to have a customer type. Example customer types might include, domestic and international or retailwholesale, and manufacturer.

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

What is the difference between incident status and incident resolution?

Status is used by the incident system to track the life cycle of an incident. An incident begins with a new status and then takes on various other statuses as it is being worked on. The final status (which all incidents are moving towards) is closed. Status selections are system-defined and not editable. Resolutions, on the other hand, are user-defined and not required.

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

Do all items need to be organized in the product catalog for the xTupleCommerce website?

Not every item needs to be organized into your product catalog for it to appear on the xTupleCommerce website. Technically, as long as the attribute to be visible on the website is selected on the item master, then the item will appear on the website. However, it will only show up on the products list and also when a user searches for a word that matches the title, subtitle, description, or product details. Because of this, we generally recommend that you organize your items in the product catalog, to make it easier for users to find them.

Was this Helpful?
up
39 users have voted.

Does the size of the file matter?

There is no specific limit to the size of files you can store in the database. You can store everything from small files to extremely large files in the database.

Hint: Keep in mind that storing large files in your database will increase the size of your database and will require you to monitor your hard drive consumption.

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

Do you have any freight class examples?

The names given to freight classes are user-defined in xTuple. This means you can set up freight classes however you want to. Some examples of freight classes could include bulkbreak bulkcontainerair, etc. You could also model your freight classes after the National Motor Freight Classification (NMFC).

Was this Helpful?
up
39 users have voted.

How do I handle provinces?

Provinces are handled the same way as states in all addresses. Some countries have provinces or territories as opposed to states. For example, Québec is a province of Canada. Regardless of the country that you select from the standard country list, the relevant states or provinces will be populated in the state field of the address.

Hint: Use the limit to list setting to keep the default lists of countries, states and provinces from being changed. You can find this setting under the CRM configuration screen.

Was this Helpful?
up
39 users have voted.

How do I link a project to a customer?

Projects can be linked to customers using the relationships link on the customer screen. Simply locate the CRM account for the customer and then save the project once you've entered the information. When you link projects and customers you gain the ability to specify special billing rates for customers by project. You can also report on projects by customer.

Was this Helpful?
up
39 users have voted.

How do I reverse a receivable?

Receivables can be reversed either by application or, in the case of invoices, by voiding. For example, let's say a customer has an open receivables balance of $4500. When that customer sends you a check for $4500, you can apply that cash to the invoice, thus reversing the open balance down to $0. Similarly, credit memos can be applied to invoices (or debit memos) to reduce or reverse a receivable amount. For invoices, you also have the option to void them, which reverses them back to an unposted state.

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