+1-757-461-3022 x124

Library

Primary tabs

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

Where are sale types used?

Sale types are used on sales orders to declare the type of sale being made. The sale type might indicate, for example, whether you are selling to a retail customer or a wholesale customer. The sale type you choose can impact how sales revenue is reported. The link between sale types and revenue accounts is made on the sales assignment interface.

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

Why are some users inactive?

There are times when you may want to disable a user account. This may be true, for example, when employees leave your company. Even though you no longer employ the person, you may still need reporting related to them. Making a user inactive also gives you the flexibility to make the user active at a later date. By contrast, when you delete a user from the database, records related to them are lost.

Was this Helpful?
up
42 users have voted.

Can I change the sequence for incident numbers?

Yes, by simply typing a new number in the incident's next number field, you can change the incident number sequence. Keep in mind that incident numbers must be numeric—and you cannot use the number of an incident that already exists.

Was this Helpful?
up
41 users have voted.

Does the sale type impact pricing?

No, there is no correlation between sale types and pricing. The sale type is used to declare how sales revenue will be accounted for in the general ledger.

Was this Helpful?
up
41 users have voted.

Do I need to assign priorities?

No, you are not required to set a priority when creating an incident. Priorities are optional. If you don't want or need to assign priorities to incidents then you can simply ignore them.

Was this Helpful?
up
41 users have voted.

Do I need to configure each database separately?

Yes, the configuration of extensions (e.g., modules, like CRM) needs to be performed on each database used by your company. This flexibility allows you to configure different databases for different purposes. For example, let's say you want to pilot new features in a sandbox database. You would want to enable those new features in the sandbox for testing purposes. However, you wouldn't want to turn those features on in your production database until after you have piloted them.

Was this Helpful?
up
41 users have voted.

Do I need to create a contact before I create a prospect?

You can create the contact associated with a prospect before, during, or after the point when you create the prospect. It's up to you. If you create the contact first, simply search for the contact when you are creating the prospect record—and this will associate the contact. Conversely, to create a contact while entering the prospect, simply choose to create one in the contact field.

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

What address do I enter in the billing configuration?

The address you should enter in the billing configuration is your remit-to address. This address is used in multiple reports, including invoices.

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

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

What is CRM?

In xTuple, CRM stands for Corporate/Customer Relationship Management. xTuple CRM includes features such as a universal address book, incident management, opportunity management, to-do lists, project management, and more. What makes xTuple CRM especially unique is that it is fully-integrated with xTuple ERP. This means you can organize and manage your CRM data all within the context of a complete business management solution.

Was this Helpful?
up
41 users have voted.

What is the cut-off day?

The cut-off day is used by proximo terms to indicate the day of the month on or after which the due date will advance to the next month. For example, if the cut-off day = 10, any invoices dated on or after the 10th will automatically be due the following month.

Hint: Put "0" as the cut-off day to indicate the first day of the next month. For example, if the cut-off day = 0 and the due days = 15, then the due date will be on the 15th of the next month.

Was this Helpful?
up
41 users have voted.

Where would I use the default country?

When you implemented xTuple, you identified a country to use as the default when entering new addresses. This saves you the step of entering the country manually. You can override the default country when entering or editing addresses.

xTuple ERP is a multi-currency international system so you can do business with organizations and individuals globally.

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

Can I change a customer's customer type?

Yes, you can change the customer type a customer is assigned to. To do this, open the customer record for editing and select a different customer type. Once you save the change, the customer will be associated with the new customer type.

Was this Helpful?
up
40 users have voted.

Can time and expenses be charged to customers?

Yes, time and expense information entered on worksheets can be billed directly to your customers. Billing rates can be entered on an ad hoc basis—or you can set up pre-defined rates for your customers at the project task level.

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 does the tax credit for discounts work?

The credit taxes option should be enabled if you want to ensure tax payments are credited when processing early payment discounts. This option is selected by default. If not selected, taxes will not be credited when early payment discounts are processed.

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