+1-757-461-3022 x124

Library

Primary tabs

How do I update an item image for xTupleCommerce?

To update an item image, go to the item master in the xTuple ERP database. Once there, navigate to the documents tab and DETACH the old image you no longer wish to use. Then, this is very important, SAVE. This will close the item window. Next, reopen the item window and ATTACH the new image. That should do it.  

Note: If you do not save the item after detaching, the xTupleCommerce site will not recognize that there was a change and, therefore, the image will not show up properly.

Was this Helpful?
up
516 users have voted.

What does require standard cost mean?

If you configure purchasing to require standard costs, every item you receive into inventory through purchasing will be required to have a standard cost. This feature will be desirable in companies where standard costing is the norm. However, companies using the average (or other) costing method should not set this flag, since it will prevent you from receiving average-cost items into inventory.

Was this Helpful?
up
512 users have voted.

How do I retrieve API keys from within Authorize.net?

    Neither the xTupleCommerce system nor the ERP stores plain text credit card information in the database. Both systems integrate with Authorize.net via the Authorize.net API. To retrieve API keys from Authorize.net, follow these steps:

    1. Go to Authorize.net 
    2. Log into your account as an admin
    3. Click ACCOUNT in the main menu
    4. In the Security Settings area click on API LOGIN ID and TRANSACTION KEY
    5. Enter the answer to your account’s Secret Question
    6. Click SUBMIT
    7. Capture the keys
    8. Deliver the keys to xTuple - follow the instructions for Sharing API Keys from the bottom of this article

    Note: Every time you create an API key the old key expires within 24 hours. Your keys may be used in various locations (website, ERP, etc). Please save the keys in a secure location (LastPass.com, 1Password, etc) so you don’t have to recreate keys in the future.

    Was this Helpful?
    up
    505 users have voted.

    Can employees belong to more than one employee group?

    Yes, there is no limit to the number of employee groups an employee can belong to.

    Was this Helpful?
    up
    496 users have voted.

    On an item, what is the difference between inventory units and price units?

    Inventory units of measure (i.e., UOM's) are the measure by which items are maintained in inventory. Price units, on the other hand, are the measure for items when they are sold. A single item may have different inventory and price units. Having two different units would apply if you sell items in different units than you stock them in. For example, if you are a beer distributor, you might stock beer in pallets but sell beer in cases. In this example, your inventory unit would be PALLET and your price unit would be CASE.

    Was this Helpful?
    up
    494 users have voted.

    Why do items require units?

    Items require units for two primary reasons. First, units are needed to fully describe item quantities. For example, it is not enough to say, "We have 25 sodas in stock." You would expect instead to hear, "We have 25 cases of soda in stock." Second, units make it possible for the system to convert items from one unit to another. If you stock items in one unit and sell them in a different unit, then the conversion is only possible if units are assigned in the first place.

    Was this Helpful?
    up
    489 users have voted.

    Do you have any product category examples?

    Let's say you sell home products. Your product categories might include furniture, bedding, bathroom products and appliances. By contrast, if you sell only one type of product, like toys, you could categorize by the material the toys are made of (i.e., wood, metal, plastic, etc.). Services you sell also need product categories. Sample service categories might include consulting, repairs, and cleaning.

    Hint: Consider using the characteristics feature available on items to allow more detailed, custom reporting on the products you sell.

    Was this Helpful?
    up
    487 users have voted.

    How do I change my xTupleCommerce password?

    If you’ve forgotten your password, you can click the tab to request a new password on the login page.

    If you know your password but want to change it, you can login to the xTupleCommerce website, go to people on the admin bar, find your username, and select EDIT on the far right. From there, you can change and save your password.

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

    Why do item sites require a planner code?

    Planner codes are required on item sites for reporting purposes—and also to support the advanced planning and forecasting capabilities found in commercial editions of xTuple. For example, with planner codes you can create different reports and schedules for raw materials and finished goods.

    Was this Helpful?
    up
    476 users have voted.

    Do returns update inventory?

    Yes, returns will automatically return stock to inventory, assuming the return line item has the update inventory flag selected. If that flag is not selected, your inventory will not be updated.

    Was this Helpful?
    up
    474 users have voted.

    What is the earliest available date?

    The earliest date is derived from the item source lead time. The earliest available date is determined by adding the item source lead time to the current date. If you don't configure purchasing to use the earliest date, the due date field will be left blank when entering purchase order line items—requiring users to enter the date manually.

    Note: The earliest date configuration applies only to manually-entered purchase orders. This option does not impact the scheduling of purchase orders generated by the MRP planning system.

    Was this Helpful?
    up
    472 users have voted.

    Why can't I receive my purchase order?

    If you are trying to receive a purchase order but it doesn't appear in the list of orders to be received, there's a good chance the purchase order has not been released yet. Purchase orders must be open/released before they can be received. To release a purchase order, change its status from unreleased to open.

    Was this Helpful?
    up
    462 users have voted.

    Are shifts required?

    No, shifts are not required. If your company doesn't use shifts, then you do not need to add them—or assign them to employees.

    Was this Helpful?
    up
    461 users have voted.

    Can I create simple invoices?

    Yes, if you don't want or need to use sales orders or shipping, you can create simple invoices and get them out to your customers quickly. Just enter an invoice and fill out your line items. You can even update your inventory when the invoice is posted, if you need to.

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

    Can an item belong to multiple groups in the product catalog?

    Yes, items may belong to multiple groups within the product catalog. There are two ways you can add an item to groups.

    If you’re working at the item group level, go to Products > Item > Groups, select the item group and EDIT. From there, you can add items. Even if the item is in another group, it can still be added to other groups.

    If you’re working at the item level, go to the item’s attributes tab and attach groups from there.

    Note-The item group will need to be created before you can add an item to the item group.

    Was this Helpful?
    up
    444 users have voted.

    Are employee and user the same thing?

    Employee and user are not necessarily the same thing. An employee is a person who works for your company. A user is a person who has an account allowing them to access your xTuple database. There are scenarios where database users would not also be employees. For example, you may give user access to people who are not your employees (e.g., IT consultants). Conversely, there are also scenarios where employees wouldn't need user accounts. For example, you may have employees whose job doesn't require them to use a computer—and so there would be no need for them to have a user account.

    Was this Helpful?
    up
    440 users have voted.

    Do I need xTuple Connect in order to send emails?

    xTuple Connect is required when you send email notifications using the xTuple Desktop. 

    Was this Helpful?
    up
    413 users have voted.

    What IP address should I put in my pg_hba.conf file?

    That's called CIDR notation. Here's a handly calculator for figuring out an appropriate value: http://www.subnet-calculator.com/cidr.php.

    You need to know a little about the network you're setting the server up on and a bit about subnetting. A client may need to allow various networks to connect - they may have several subnets, etc - each network from where you want to allow connections from needs to have an entry in the pg_hba.conf, or at least a rule that fits. 0.0.0.0 is a catch-all - any address will match with that rule.

    But, suppose you have a remote office, with a fixed IP on their router - all traffic from inside the office goes out with the same WAN IP of that router, say the WAN IP is 129.42.60.216 - that's a single address from a single device. So, on your postgres server where they are connecting to you would create a pg_hba.conf entry similar to:

    host all all 129.42.60.216/32 md5 /32
    is the same as
    255.255.255.255 ( 1 address) /24
    is the same as
    255.255.255.0 (254 addresses)

    Also, keep in mind that the pg_hba.conf file is read top to bottom. As soon as Postgres finds a rule that allows access, it stops reading rules - so make sure your access rules make sense. You can do all sorts of interesting things with the pg_hba.conf. Read the comments at the top of that file.

    Was this Helpful?
    up
    413 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
    408 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
    404 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
    399 users have voted.