+1-757-461-3022 x124

Library

Primary tabs

Can an item have more than one item source?

Yes, since you might purchase an item from multiple different vendors, it's possible to have multiple item sources for a single item. Use the vendor ranking option to sort your item sources from best to worst. The vendor ranking comes into play when you release planned purchase orders. At the time of release you will be asked to select an item source. The item sources having the highest vendor ranking will appear at the top of the list.

Was this Helpful?
up
588 users have voted.

How are commissions calculated?

At the most basic level, sales commissions are calculated as a percentage of the extended price for sales order line items. Each sales rep has a default commission percentage, which is defined on the sales rep record. However, this percentage can be modified at the customer or ship-to address levels. Individual sales rep commissions can also be impacted if you are using the Enhanced Commissions package.

Was this Helpful?
up
588 users have voted.

How do I issue a tax credit to my customer?

You can use either a Misc. A/R Credit Memo or a Sales Order Credit Memo to issue tax credits to your customers. The following example describes how to do this using the Misc. Credit Memo (although, the steps are very similar for Sales Order Credit Memos):

Example:

  1. You need to credit Customer ABC for $25 tax
  2. Open Misc. Credit Memo screen
  3. Enter $25 in "Amount" field
  4. Open "Tax" link
  5. Create a new Tax Adjustment for $25
  6. Post Credit Memo
  7. View credit in Tax History report
  8. Later: Apply Credit Memo to Customer open item
Was this Helpful?
up
587 users have voted.

Are the advanced characteristic options required?

The advanced characteristics options—available only to text type characteristics—are not required. You may use text type characteristics without using the advanced options. The two advanced options are input mask and validator. An input mask creates a template to guide users as they enter values for a characteristic. It is a form of light data validation. For example, if you specify the input mask 00/00/0000, then users will be presented with the following template when they are entering values for the characteristic : "__/__/____". In this case, users will simply have to fill in the blanks between the separators. A validator is used to strictly enforce the format of data users can enter in a field. If you specify a validator for a characteristic, then users will have to conform to the format when entering values for the characteristic. Values which do not conform will not be accepted.

Was this Helpful?
up
586 users have voted.

What are incidents?

Incidents are typically tickets, cases, issues, requests or bugs. These incidents can be raised internally by staff or externally by customers. They can be about errors in products or services but they can also be used to request help or support for a product or service. If you use the xTuple Web Portal, then you and your customers can create, manage and track incidents on the web.

Was this Helpful?
up
585 users have voted.

Are sales categories required?

Yes, if you sell miscellaneous (i.e., non-inventory) products and services, then you will need to use sales categories. Miscellaneous items inherit their accounting assignments from sales categories.

Was this Helpful?
up
583 users have voted.

What are incident status colors?

Incident status colors make it easier to quickly identify the incidents you are looking for. To assign a color to an incident status, simply type the name of the color (or its hexadecimal equivalent) in the field next to the status name. For example, let's say you want all incidents with the status feedback to be highlighted in red. In the field next to Feedback, you could enter either the word red or #FF0000, the hex code for red. Now whenever you view the incident list you will see your color-coding.

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

Are opportunity sources required?

Yes, an opportunity source is required when creating an opportunity. That means you must have opportunity sources defined before you can successfully save an opportunity.

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

How do I figure out what version of PostgreSQL I'm running?

If you don't remember which version of PostgreSQL you're running, you can always find out with the following SQL statement:

select version();

This is easy to do if you're familiar with pgAdmin. Simply connect to your server with pgAdmin. Select one of your databases. Open the SQL editor tool. Paste in the above command. Then execute the query. Your PostgreSQL version will be displayed in the results window.

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

How are discount days used?

Discount days specify the number of days within which a payment must be made to take advantage of any terms discount. For example, if your terms are 2% discount in 10 days, net 30, then the discount days would = 10—in other words, the discount applies if paid within 10 days.

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

What is the difference between contacts and accounts?

Accounts are entities or individuals you do business with (customers, vendors, partners, prospects, etc.), whereas contacts are the people you interact with. Contacts may be assigned to an account, but they don't have to be. Think of your contact list as being your address book and your account list as being a business directory. By assigning contacts to accounts, you can keep track of the people who work at the accounts.

Was this Helpful?
up
569 users have voted.

How is the vendor unit ratio used?

The unit ratio specifies the ratio between inventory and vendor units of measure (UOM). For example, if you stock an item in single units, but a vendor sells you the item in cases of 12, then you would enter "12" as the vendor unit ratio (i.e., 12:1). If the ratio is 1:1, then enter "1" as the unit ratio. Having a defined vendor unit ratio allows you to purchase inventory in the vendor's UOM. However, on receipt that inventory will be converted automatically to your inventory UOM.

Was this Helpful?
up
566 users have voted.

Where can I find the PostgreSQL documentation?

For more information, please see PostgreSQL Documentation.

Was this Helpful?
up
564 users have voted.

Is there any limit to the number of customer ship-to addresses?

The system supports an unlimited number of ship-to addresses. With ship-to addresses, you can maintain one customer record with multiple different delivery locations. In addition to having its own unique number, each ship-to address also includes contact information for individuals at each address. Specialized pricing by ship-to address is also supported.

Was this Helpful?
up
563 users have voted.

What is a worksheet?

Worksheets are used for tracking employee time and expenses. Because they are linked to projects, worksheets can be used for tracking time and expenses on a project-by-project basis.

Was this Helpful?
up
563 users have voted.

Can I create my own honorifics?

Yes, you can create as many honorifics as you wish. Any honorifics you define will be available for use when creating new or editing existing contact records.

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

When should proximo terms be used?

Proximo terms should be used whenever you expect payment on a certain day of the month (e.g., the first day of the month, the fifteenth day of the month, etc.). Use the due days field to enter the day of the month when payment is due. For example, if your due days = 15, then payment would be due on the 15th of the month.

Was this Helpful?
up
562 users have voted.