+1-757-461-3022 x124

Library

Primary tabs

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
519 users have voted, including you.

Can I manage my item images in the xTupleCommerce website?

Your xTupleCommerce site has the capability of hosting images, PDFs, documents and other media. Once your site is live you can associate these files with Items and Item Groups in the ERP. For instance, you can associate product images with Items in the ERP. Or you can associate Marketing PDFs with Items in the ERP. These images and PDFs will be displayed with the products on the xTupleCommerce site.

If your site is still in the development or testing phases (aka, you are still going to a stage.domain.xtuple.net URL to view your site), we encourage you to use a service such as Cloudinary to host your images and determine URLs.

However, if your xTupleCommerce website has gone live, you can begin using the site to host files and create the URLs needed for the document in the ERP. 

Uploading the files to your xTupleCommerce site :

  1. Go to your xTupleCommerce website and login as a manager or editor. 
  2. Navigate Admin > Content > Files.
  3. Click ADD FILE
  4. Select and upload the image. Typically files must be less than 8MB. 
  5. Click NEXT
  6. Leave the radio button selected for public local files and click NEXT.
  7. Update and fill in the fields for name and file name. The name will show up in the URL path of the image. 
  8. Click SAVE. 
  9. Highlight the path of the image-most recently added files are on the top of the list-and copy.

Associate files with Items or Item Groups in the ERP

  1. Login to your ERP.
  2. Open an Item or Item Group
  3. Go to the documents tab
  4. Click Attach
  5. Choose Web Site from the drop down
  6. Give the file a name in the Name field
  7. Paste the URL into the URL Field
  8. The URL should include your website domain followed by the path that you copied.  
    Example: https://www.yourwebsite.com/files/public/content/media/image.jpg
  9. Click Save 
  10. Save and close the Item and Item Group

Check your work

Navigate to the Item or Item Group where the file should appear on the website

The file should appear. If the file does not appear, you may need to flush the cache on the website.

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

What are item characteristics?

Item characteristics are used to create additional layers of information about items. For example, let's say you sell toy trucks. You might use item characteristics to define the various options available on your toy trucks—such as paint color or decal kit. Taking the color example, your toy truck characteristics might include "Red," "Green," "Blue," and "Yellow." Item characteristics are useful for reporting purposes. They also play a key role in the assemble-to-order configuration system.

Was this Helpful?
up
518 users have voted.

How do I import data into xTuple?

There are two methods for importing data into the database of xTuple ERP.

  • CSVimp
    First, xTuple offers a free application called CSVimp that is designed to migrate Comma Separated Value (CSV) files into the database for the xTuple Applications (The same tool works for PostBooks®, Standard and Manufacturing Editions). You can download CSVimp from our SourceForge project site. And detailed instructions for using CSVimp are available in our documents section.
  • xTuple API
    The second method is to use the API. The goal of the xTuple Application Programmer Interface (API) is to make migrating data directly into the database much safer and easier than it is going directly into the regular table structure. Our appoach is to allow users to create, access, and update xTuple documents using a special database schema that closely mirrors the graphical user interface (GUI). You can read more about using the API to import data into xTuple ERP in the docs section.
Was this Helpful?
up
517 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
517 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
516 users have voted.

What are due days?

Due days refers to the number of days after the document date (i.e., invoice date, voucher date) when payment is considered overdue. For example, if the invoice date is May 10 and the due days = 10, then payment would be due 10 days later, on May 20. For proximo terms, the due days refers to the day of the month when payment is due—that is, due days = 10 means due on the 10th day of the month.

Was this Helpful?
up
514 users have voted.

What are some examples of sale types?

Because sale types are user-defined, you can set them up any way you want to. Some examples of sale types might include in-networkout-of-networkretailwholesale, etc. Depending on how granular you want your revenue reporting to be, you can link your sale types to different revenue accounts using the sales account assignment interface.

Was this Helpful?
up
513 users have voted.

How do I link a project to a customer?

Projects can be linked to customers using the relationships link on the customer screen. Simply locate the CRM account for the customer and then save the project once you've entered the information. When you link projects and customers you gain the ability to specify special billing rates for customers by project. You can also report on projects by customer.

Was this Helpful?
up
512 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
512 users have voted, including you.

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
509 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
506 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
504 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
501 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
499 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
499 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
498 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
497 users have voted, including you.

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

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

What is the default location?

The default location is the location within an item site where you want your inventory to be put or taken from by default. Having default locations can simplify the process of handling inventory when multiple location control is being used. For example, users can transfer inventory into/out of an item site using a default location button—without having to pick a location from a list of available locations. Default locations are not required but they do help reduce complexity.

Was this Helpful?
up
495 users have voted, including you.

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