+1-757-461-3022 x124

Library

Primary tabs

How do I handle deferred revenue?

To handle deferred revenue, enter a cash receipt and specify you want the balance applied as a customer deposit. Doing this will ensure the cash balance is posted to the deferred revenue account, as defined in the receivables account assignments setup.

Was this Helpful?
up
213 users have voted.

How do I install pgcrypto?

If you are going to use credit card processing or if you're getting this message ERROR:  function decrypt(bytea, bytea, unknown) does not exist then you need to install pgcrypto. Pgcrypto is a library used for encrypting sensitive data. The pgcrypto software is a popular add-on package included with the PostgreSQL source code distribution. The pgcrypto module is used by our credit card encryption functionality.  Even if you are not processing credit cards, we still recommend that pgcrypto be installed. 

First, we need to locate the pgcrypto.sql file.  One typical path to this is:

/usr/local/pgsql/share/contrib/pgcrypto.sql

If it isn't there you can always search for the file.  You may need to perform the search as root (be patient, this takes a while):

find / | grep pgcrypto.sql

Or if you're on Windows just use the Windows file search.

Once you've located the file the next step is to install it.  The command to install pgcrypto onto your database is:

psql -U mfgadmin NameOfDB < /wherever/the/file/is/pgcrypto.sql 

Or if you prefer using pgAdmin, connect to the database you want to install pgcrypto and open/execute pgcrypto.sql through the SQL Editor.  It is also a good idea to install pgcrypto.sql on the template1 database.

Was this Helpful?
up
213 users have voted.

What is included in inventory history?

Inventory history records are generated any time quantity in an item site is changed, either up or down. For example, when quantity is received into inventory, an inventory history record is created. The same is true when quantities are issued to shipping or work orders. Any inventory movement is tracked in the inventory history report.

Was this Helpful?
up
213 users have voted.

What are project tasks?

Project tasks are used for budgeting and tracking time and expenses associated with particular project activities. When combined, project tasks present the total time and expenses for a project. The Project Accounting package adds expanded accounting functionality for tracking time and expenses related to project tasks.

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

What's the difference between a context and a source?

When using Qt Linguist for translation work, you will see references to "contexts" and "sources."

  • context is a business object, like the contact screen or the bill of materials screen.

  • source is a specific string of text within a context. For example the “Bill of Materials” context contains 56 sources, including “Print”, “Save”, “Revision Date”, etc.

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

What is landed cost?

Landed cost is the total price of a product once it has arrived at a buyer's door, including the purchase price plus all freight, tariff and any other handling charges. Often times, landed costs need to be added retroactively to a product after it has been received.

Was this Helpful?
up
205 users have voted.

Why should I enable customer deposits?

Enabling customer deposits makes it possible to account for deferred revenue—that is, cash receipts that are not applied to open invoices when they are received. When this option is enabled, two things will happen: 1) a customer deposit option will appear on the cash receipt screen and 2) your receivables account assignments screen will include a deferred revenue account option. This deferred revenue account will be used when customer deposits are posted. If you don't enable customer deposits, unapplied cash receipts will be distributed to a credit memo, which can be applied to an invoice at a later date.

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

My product is not showing up in the right group on the xTupleCommerce website. Where do I fix this?

The product catalog is managed in the xTuple ERP database. You’ll want to check the product catalog to make sure the product is in the right group.

Navigate to the item in the xTuple ERP database. Then, under attributes, look at the table on the bottom of the window. The group name will identify which group(s) the item is associated with in the catalog. 

If the item should be showing in a different group, navigate to the item groups via Products > Item > Groups. Then select the group you want to edit and make any needed change. 

Was this Helpful?
up
204 users have voted.

Do all accounts need parents?

No, the parent account feature is optional. You would only use it for accounts that are sub-accounts. For example, you might have customers TTOYS-SE and TTOYS-NE that are regional branches of Tremendous Toys. In this case, you would link Tremendous Toys as the parent for both TTOYS-SE and TTOYS-NE.

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

Which file types can I add to the database?

There are no restrictions on the file types you can add to the database. Everything from office documents to image files to CAD drawings and more is supported.

Was this Helpful?
up
203 users have voted.

Why don't my non-inventory receipts show up on the Uninvoiced Receipts|Returns report?

Because non-Inventory Items, by defintion, do not have Item Sites, you cannot view receiving information for them on an individual Site basis. That's why you have to select the "All Sites" option on this report to see your non-Inventory activity.

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

When will the next xTuple ERP release come out?

See our Product Roadmap for a general idea of when xTuple ERP will be released next and what the major upcoming features will be.

Our goal is to have two features releases a year (x.y.0), one in June and the other in December, plus a few bug-fix releases. This schedule is not exact. Feature releases will be published when their defining features are complete. Bug-fix releases will be published as needed. Between August 2007 and July 2016 we published a release on average every 8 weeks, not counting betas and release candidates. That included 21 feature and 38 bug-fix releases (on average a little more frequently than 6 months and 3 months, respectively).

Was this Helpful?
up
198 users have voted.

How are customer groups used?

Customer groups are used for reporting purposes. By associating similar customers with the same customer group, you can generate sales reporting and analysis for the entire group.

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

Where can I find the Qt documentation?

For more information, please see the Qt Product Information.

Was this Helpful?
up
195 users have voted.

What if an employee changes shifts?

If an employee is going to be changing shifts, a manager or other administrator needs to assign the new shift to the employee's master record. If the new shift isn't assigned to the employee, the rules of the old shift will continue to apply to the employee.

Was this Helpful?
up
194 users have voted.