+1-757-461-3022 x124

Library

Primary tabs

Are freight classes required?

Freight classes are only required if you are using pricing schedules to automatically calculate freight charges during sales order entry. Pricing schedules include freight classes as one factor in their pricing matrix. Using this matrix, it's possible to define pricing schedules by freight class.

Was this Helpful?
up
42 users have voted.

How are shifts used?

Shifts are used to track employees' weekly hours, including break periods and overtime hours. Shifts get assigned to employees on the employee master record. When employees clock into a shift—or to work orders during their shift—the rules of the shift are applied. The rules of a shift include pre-defined start/end times, break times, labor rate, etc.

Was this Helpful?
up
42 users have voted.

How does xTupleCommerce secure credit card transactions?

Both the xTupleCommerce system and the ERP both integrate with a secure credit card payment gateway. The following graphic provides a high-level illustration of how the process works:

 

 

  1. xTupleCommerce sends the submitted credit card information and requested amount to the Credit Card (CC) Gateway to check for a pre-authorization (preauth).
  2. The CC Gateway confirms that the requested amount is available on the credit card and provides a token for the preauth.
  3. xTupleCommerce sends the preauth token to the ERP along with the sales order.
  4. The ERP sends the token to the CC Gateway asking to confirm the preauth for the exact amount of the sales order.
  5. The CC Gateway confirms that the preauth is still valid
  6. The ERP sends confirmation of the order to the CC Gateway and requests that they charge the credit card with the exact amount.


When storing a credit card on file, xTupleCommerce uses the CC Gateway tokens that represent the credit card information and customer data. In addition, the "Blowfish Security" algorithm for encrypting sensitive information is used in the PostgreSQL database, on the ERP side. This ensures that the customer information is never passed or stored as plain text, but rather as an encrypted string of letters and numbers that serve as a key to unlock that information. Without a direct connection to the CC Gateway system through the API integration, the keys are worthless, thus preventing attackers from obtaining the sensitive information.

Was this Helpful?
up
42 users have voted.

What is a characteristic role?

Characteristic roles define where characteristics can be used. For example, if you want a characteristic to be associated with contact records, you would select the contact role. Item characteristics would require the item role. And so on. Individual characteristics may be associated with multiple roles. The same characteristic might apply to contacts and addresses and opportunities. If you are having trouble finding a characteristic to associate, it's likely the characteristic role isn't defined properly.

Was this Helpful?
up
42 users have voted.

What is the xTuple REST API?

To answer that question, first we have to answer a few other questions.

What is an Interface?

An Interface is where two things interact. An object's interface is what it presents to the outside world or other objects as the way to interact with it. We incounter interfaces everywhere in the world. A door handle is an interface. You car's stearing wheel is an interface. Writing on a piece of paper with a pen is using an interface. A keyboard, mouse and screen are interfaces to computers.

What is an API?

An API by definition is an Application Programming Interface. Most of the computer applicaitons you work with every day present a User Interface where you can click, type and/or touch things to interact with the application. That interface is for users, people, to interact with the applicaiton. People are not the only things that need to use applications. Other applications may need to use a feature of a different application. Other computers or systems may need to use that feature. An example of this is sending an email. The email client on your phone or computer doesn't actually send emails to other people, it uses an email servers API to send emails.

To make sending emails easy, email servers have defined a standard and implemented and API that conforms to that standard. That allows all kinds of other applications to be able to consistently send email no matter what or where the server is. The email server has an API that any client applications can use. Client applications can be programmed to use that API so they can send emails using that email server.

What is REST?

REST stands for REpresentational State Transfer, which doesn't really tell the average user anything about what REST is. To understand REST, the best analogy is your computer's browser. When you visit a website, you are acessing a web server's API. That API implements a standard called HTTP. REST leverages the HTTP standard to present an API for some application.

So what is the xTuple REST API?

xTuple has build a web server that presents a REST API that client applications can use to interact with the xTuple ERP system. This allows client applications to get data like Products, Customers, Contacts, Addresses, etc. Those client applications can be built to do all kinds of different things with this data. One example of that is the xTupleCommece system. It is a client of the xTuple REST API. xTupleCommerce uses the xTuple REST API to present an eCommerce website to consumers. See the xTuple REST API wiki to learn more about how to use it.

Was this Helpful?
up
42 users have voted.

As a translator, which xTuple version should I work on?

Generally you should work on translating the most current version of the software. xTuple regularly releases updates to our products, identified by version numbers. Each version may contain new sections or changes to old sections. Generally, translators should translate the most recent version of the product, but if your installation uses an older version of the product you may want to work on translating that version.

Was this Helpful?
up
41 users have voted.

Can I select multiple costing methods?

Yes, you can enable all of the available costing methods—if that's what your business requires. However, in many cases, one of the costing methods (average or standard) is generally sufficient. When you enable a costing method, that means item sites will be able to use that costing method. Inventory costing is specified at the item site level.

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

How are returns and return authorizations different?

The primary difference between returns and return authorization is their relative complexity. Returns are quick to process and complete. They are designed for simple scenarios. Return authorizations, on the other hand, are far more complex. They support complicated business processes in a way that simple returns do not.

Was this Helpful?
up
41 users have voted.

How do I become a translator for xTuple?

If you are interested in getting involved with xTuple user interface translation, please review the following articles: Starting a new translation project and Getting and Using xTuple Translation Files. Translators will also find useful the Translation Glossary, which provides explanations of unfamiliar words/terms found in the user interface.

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

How long does xTuple store my backups?

xTuple stores a minimum of the 5 most recent backups plus one backup each week for a minimum of 1 year. Because of network related problems the most recent backups may not always be consecutive by day.

Was this Helpful?
up
41 users have voted.

What are extensions?

Extensions are features—usually groups of features—which extend the core xTuple functionality. Common examples of extensions include modules (e.g., CRM) and packages (e.g., Time & Expense). Extensions must be administratively linked to individual databases before database users can access them. Some extensions are commercial and must be purchased, whereas others are free and available on demand.

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

Can quotes be converted to invoices?

Yes, if you have the billing features of xTuple installed, then you can convert quotes to invoices. To convert a quote to an invoice, navigate to the list of quotes. From the list, select the quote you want to convert and then choose the convert option from the menu. All the quote information will automatically transfer to the invoice. To locate the invoice you created from the quote, navigate to the list of invoices. By converting quotes directly to invoices you can bypass the sales order process. This may be desirable for service businesses and others where inventory management, tracking, and shipment is not a core part of the business.

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

How can I make items tax exempt?

The easiest way to make an item tax-exempt is to make sure it is not linked to a tax type. For an item to be taxable, it must have a tax type associated with it. If there's no tax type linked to an item, then tax won't be charged.

Was this Helpful?
up
40 users have voted.

How do I handle Purchase Order Returns (i.e., rejects) in the vouchering process?

If you are having trouble vouchering a Purchase Order because there are Returns logged against it, then you probably left out an important step: Creating a Credit Memo for the Return. To do this, go to the "Uninvoiced Receipts/Returns" report screen and right-click on the Return record. In the right-click menu is the option to create a Credit Memo for the Return. Once the Credit Memo has been created, you should be able to continue processing your Voucher. Later, you can apply the Credit Memo to an open Voucher.

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

I updated information in the ERP, but it’s not showing up on my xTupleCommerce website. What could be happening?

Some information may not show up on the xTupleCommerce website immediately. Instead, it stays in the cache. Think of the cache as a net that holds on to some of the changes.

To manually flush the cache (release the net of changes), log in to your xTupleCommerce website. Then navigate to Admin > Icon > Flush all Cache and select to flush all the cache.

Note-If after flushing the cache the formatting of the site looks like it has changed, refresh the page and it should go back to normal. 

 

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

What are the customer defaults used for?

The customer defaults create a template that is used whenever new customers are created. For example, if you want all your customers to have the same payment terms, specify default terms for your customers—and all newly-created customers will be assigned those terms. You don't need to specify every default to use this feature. To bypass an option, simply turn the option off or specify none.

 

Was this Helpful?
up
40 users have voted.

What does this error mean: "connection to specified xtuple erp server cannot be made"?

We have spoken with various users who encountered this error and discovered something in common with both. Both had prior installs of other Open Source solutions on their computer, prior to installing PostBooks®. In both cases the the other product also installed an instance of PostgreSQL. It appears the two installations of Postgres are conflicting, and preventing the PostBooks® installer from finishing the install. If you are done for the moment evaluating the other Postgres-powered application, try uninstalling it, and then running the PostBooks® installer again

Was this Helpful?
up
40 users have voted.

What is a person's last name?

On the contact screen the contact's last name is also referred to as their surname or family name. On the other hand, the first name refers to their given name. The system only requires you to enter one name—first or last. However, it is common to enter both.

Was this Helpful?
up
40 users have voted.

Why can't I enter a credit card receipt?

When entering credit card receipts, make sure you've selected credit card as your cash receipt funds type. Second, check with your system administrator to verify your site is configured to use credit cards. Some set up may be required.

Was this Helpful?
up
40 users have voted.