+1-757-461-3022 x124

Library

Primary tabs

What is a terms code?

The terms code is the primary identifier used to describe billing and payables terms as they appear throughout the application—in drop-down lists, etc. For example, if one of your terms is net 30, then you might use the code NET30 to identify it. Similarly, if your terms are 2% discount in 10 days, net 30, then your code might be 2-10N30.

Was this Helpful?
up
36 users have voted.

What type of security is used on xTupleCommerce and the ERP?

Our systems, both xTupleCommerce and the xTuple REST API, require an SSL (Secure Sockets Layer) certificate to function. SSL is a standard security technology for creating and encrypted connection between a server and a client (for example, between a user's browser and the webserver). It allows sensitive information to be transferred in a secure fashion. Without an SSL the data would be sent between the server and client in plain text, which is not secure. In plain text an attacker could intercept the plain text data and have access to sensitive information.

Neither the xTupleCommerce system or the ERP stores plain text credit card information in the database. Both systems integrate with Authorize.net via their API. The same SSL technology is used to encrypt and send information to and from Authorize.net and we rely on Authorize.net to store credit card information in a secure fashion.

When storing a credit card on file we use Authorize.net tokens that represent the credit card information and customer data. On the ERP Postgres database we use the Blowfish Security algorithm for encrypting sensitive information. This ensures that the customer information is never passed or stored as plain text, but rather a encrypted string of letters and numbers that serve as a key to unlock that information. Without a direct connection to the Authorize.net system through the API integration, the keys are worthless which prevent attackers from obtaining the sensitive information.

Additional Resources

Authorize.net - how credit card processing works

Authorize.net - storing customer data

SSL information

Authorize.net API Reference Guide

Understanding PCI Compliance

Postgres Blowfish Security Algorithm

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

Why can't I view financial information for any date range?

Under the guidelines established by generally accepted accounting principles (GAAP), financial data —and by extension, financial reports—are organized according to accounting periods. Accounting periods create a pre-defined and repeatable structure for financial reporting. The accounting cycle itself depends on accounting periods to facilitate the (typically) monthly and also annual auditing and closing of the books. Accounting periods are usually defined as monthly, quarterly, and yearly time frames. Financial reports follow the structure of the accounting periods—and so you have monthly, quarterly, and annual reports. Ad hoc reporting outside the boundaries of the defined accounting periods is not generally supported.

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

Does xTuple support split commissions?

Yes, xTuple does support split commissions—as well as tiered commissions—with its Enhanced Commissions package. This commercial package is included as part of the xTuple Enterprise Edition. The package may also purchased separately as an add-on extension to other xTuple editions.

Was this Helpful?
up
35 users have voted.

Do invoices flow from sales orders?

If you are using sales orders to capture customer orders, then invoices do flow from sales orders. The typical progression goes as follows: sales order -> shipping -> billing/invoicing. You can also enter invoices without first having a sales order. This is more common in service businesses, where inventory is not a major focus.

Was this Helpful?
up
35 users have voted.

How do I add contacts to an account?

You can add contacts to an account in either of two ways: 1) Start on the account screen and attach existing or create new contacts from there or 2) start on the contact screen and link to an account from that direction.

Keep in mind that individual contacts may only be associated with one account at a time. However, accounts may have unlimited contacts attached to them.

Accounts feature primary and secondary contacts. These can be the two contacts you work with most often. However, you can add as many additional contacts as you like to the account. 

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

What are receivable applications?

Receivable applications are records generated when a receivable is either applied or applied to. For example, when a credit memo is applied to an invoice, that's a receivable application. Similarly, receivable applications occur when cash receipts are applied to open invoices.

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

Who should use expense categories?

Expense categories will be used largely by service-oriented businesses who do not handle much (if any) inventory. They are also useful for any business when non-inventory, expense transactions are required.

Was this Helpful?
up
35 users have voted.

Why would you add multiple tax codes to a tax assignment?

You would add multiple tax codes to accommodate complex tax scenarios. Example scenarios might include tiered, nested, or cumulative taxes. The behavior of each tax code can be controlled using tax classes, whose group sequence value helps sort the order in which tax codes are applied.

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

Can I change the list of countries?

Yes you can add and delete countries. You can also make changes to existing countries' settings. Use this with caution though, because a non-standard country will not have the available states and provinces by default.

Hint: Use the limit to list setting in off mode to prevent changes to the list of countries.

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

How do I start a new language translation?

If you are interested in starting a new language translation, please see the article "Starting a new translation project."

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

How do translation files work?

To learn more about how translation files work, please see the article "Getting and Using xTuple Translation Files."

Was this Helpful?
up
34 users have voted.