+1-757-461-3022 x124

Library

Primary tabs

Why is my customer on credit hold?

Customers can go on credit hold in one of two ways: 1) They can be manually placed on hold or 2) they can go on credit hold because their accounts receivable (A/R) balance has exceeded their pre-defined credit limit. A customer's credit limit is set on the customer master. When customers are on credit hold, certain activities—such as shipping sales orders—will be prevented. Customers come off credit hold when their A/R balance falls below their credit limit. You also can take a customer off credit hold manually.

Was this Helpful?
up
329 users have voted.

Can I transfer inventory between sites?

Yes, you can transfer inventory between sites using either transfer orders or an inter-site transfer transaction. For bulk operations, the transfer order is by far the best method for transferring inventory from one site to another. Both transfer orders and multiple sites are features of xTuple commercial editions. You can read more about the different xTuple editions on our comparison page.

Was this Helpful?
up
328 users have voted.

In tax code setup, what is a group sequence?

The group sequence is used to control the order in which tax codes are applied. For example, let's say you have two tax classes (A and B), as well as two tax codes (CODE1 and CODE2). Tax class A is linked to CODE1 and tax class B is linked to CODE2. When both tax codes appear on the same tax assignment, their rates will be applied in sequential order. The sequence is defined by the linked tax classes. The lowest sequence number (i.e., 1) is applied first, followed by the next in descending order.

Was this Helpful?
up
327 users have voted.

What are tax authorities?

Tax authorities are any entities legally-authorized to collect taxes—for example, city, county, state, or federal government agencies.

Was this Helpful?
up
327 users have voted.

Do contact records need to include an honorific?

No, there is no requirement to include honorifics when entering a contact record. Honorifics are an optional feature which you can use or not use depending on your preference.

Was this Helpful?
up
322 users have voted.

Which content types come standard with the xTupleCommerce website?

The following content types are included with the base xTupleCommerce system:

  • Article
  • FAQ (Frequently Asked Questions)
  • Form
  • Page
  • Promo
  • Testimonial
Was this Helpful?
up
322 users have voted.

What are tax types?

Tax types provide a system for classifying goods and services into taxable categories. For example, tax types are used to indicate whether a sold item is taxable or not. To mark a sold item as taxable, first create a tax type called taxable—then make the link between that tax type and any of your item records which need to have tax charged against them. Once your taxable items have been identified, you can create tax assignments to specify appropriate tax rates for specific tax zones. You can create as many different tax types as needed to handle both simple and complex tax scenarios.

Was this Helpful?
up
315 users have voted.

My item is not showing up on the website. Why not?

Check to make sure that the item is selected to be viewable on the website. This setting can be found on the Attributes tab of the Item master.

Was this Helpful?
up
312 users have voted.

Can I replace the report on a Display class screen?

Yes!

mywindow.setReportName("myNewReport");
Was this Helpful?
up
311 users have voted.

Can incidents be linked to each other?

Yes, you can attach an incident to another incident. The documents panel within the incident is used for this. You can also attach other xTuple objects, such as accounts, contacts, files and items to your incident. For example, if an incident is created for a broken toy, you can attach a previous incident—if it is related. You might also attach a picture of the broken toy, the person you need to contact about it, and the item number of the toy.

Was this Helpful?
up
309 users have voted.

Why does the tax code have a g/l account?

Tax codes require a general ledger (g/l) account to specify how taxes should be recorded in the general ledger when invoices or credit memos are posted. This is a liability account. The account will be credited when Invoices are posted and debited when credit memos are posted.

Was this Helpful?
up
307 users have voted.

How are item groups used?

Item groups provide a unique category used for reporting in xTuple. The constraint management system—and several related reports—recognize item groups for planning purposes. It is also possible to create custom reports to gather information about item groups.

Was this Helpful?
up
299 users have voted.

How are reference items related to expense categories?

Reference items are non-inventory items (such as services you sell) which you want to be able to include on invoices for your customers. They can also be billed as line items on projects, if you specify a default expense category in the product definition for the reference item.

Was this Helpful?
up
299 users have voted.

Can I replace the query on a Display class screen?

Yes!

mywindow.setMetaSQLQuery("group", "query");
Was this Helpful?
up
298 users have voted.

Why are some extensions missing?

If your list of extensions to be configured is missing extensions, it's likely those extensions have yet to be associated with your database. Please contact your system administrator for assistance.

Was this Helpful?
up
297 users have voted.

I applied cash to the wrong invoice. Can I undo that and start over?

Yes, beginning with xTuple ERP version 3.3.0 we added the ability to reverse (i.e., void) Cash Receipts from the Cash Receipts report screen, found under Accounting > Accounts Receivable > Reports > Cash Receipts. When you reverse a Cash Receipt, you also undo any applications made originally when the cash was applied.

After a Cash Receipt has been reversed, it returns to an unposted state. That means you can then make any changes to the unposted document before you post it again.

Keep in mind, this works only for Cash Receipts entered in or after xTuple ERP version 3.3.0. Cash Receipts entered prior to 3.3.0 cannot be voided in this way. Also, any Credit Memos or Customer Deposits created from the unapplied balance when the original Cash Receipt was posted will not be reversed when a Cash Receipt is voided. Instead, a misc. A/R Debit Memo will be created in the amount of the original unapplied balance.

Was this Helpful?
up
296 users have voted.

Can I stop query on start via script?

Yes!

mywindow.setQueryOnStartEnabled(false);
Was this Helpful?
up
295 users have voted.

How can I change my user settings?

Unless you have privileges to maintain user accounts, you'll need to contact your system administrator to change your settings. For example, your system administrator can give you access to new modules, grant extra privileges, and so on. You don't need a system administrator to change your password, though.

Was this Helpful?
up
294 users have voted.

Why do tax authorities require a g/l account?

Tax authorities are linked to a general ledger (g/l) account so xTuple knows which account to credit when payments (i.e., checks) to the tax authority are posted. By assigning a unique g/l account to each tax authority, you can track the financials for each tax authority separately.

Was this Helpful?
up
293 users have voted.

How do I add a menu item to a right-click menu?

This is fairly simple to do in either the core C++ or a JavaScript extension. See the full instructions for adding menu items to a right-click menu here.

Was this Helpful?
up
292 users have voted.

How are incident resolutions used?

Resolution is one of the options used by the incident system to categorize and track incidents. Sample resolutions might include pending, completed, reopened or fixed. When entering an incident, you can assign a resolution to it. This resolution can then be used to sort incidents by similar resolution. For example, you might want to look at all your pending incidents to see which ones need attention.

Hint: You can filter incidents by resolution.

Was this Helpful?
up
291 users have voted.

How do I backup and restore an xTuple database?

Here are the steps needed to backup and restore an entire xTuple database using pg_dumpall:

  1. Create the backup file:

    pg_dumpall -c -U postgres --quote-all-identifiers --disable-triggers -f backup.sql
  2. Edit the backup file, and insert this script after every "\connect" line.

  3. Restore the backup file (ostensibly on a BC/DR hot-spare, though you could also use this when upgrading postgresql versions):

    psql -U postgres -f backup.sql


List of scripts needed:

  • Export script:
#!/bin/bash
BF=/full/path/to/your_backup_file.sql
/full/path/to/your/postgresql/bin/pg_dumpall -c -U postgres --quote-all-identifiers --disable-triggers -f $BF
  • Import script:
#!/bin/bash
BF=/full/path/to/your_backup_file.sql
PLV8=/full/path/to/gils_script.sql
sed -e '/\\connect /r $PLV8' $BF > /tmp/$BF
chown postgres /tmp/$BF
rm $BF
cd /opt/local
/full/path/to/your/postgresql/bin/psql -U postgres -f /tmp/$BF
rm /tmp/$BF
  • "Create XT schema" script:
do $$
declare
  count integer;
  query text;
begin
  perform *
  from information_schema.schemata
  where schema_name = 'xt';
  get diagnostics count = row_count;
  if (count > 0) then
    return;
  end if;
  query = 'create schema xt;';
  execute query;
  query = 'grant all on schema xt to group xtrole;';
  execute query;
end;
$$ language 'plpgsql';
CREATE OR REPLACE FUNCTION xt.js_init(debug BOOLEAN DEFAULT false, initialize BOOLEAN DEFAULT false)
RETURNS VOID AS $$ BEGIN RETURN; END; $$ LANGUAGE plpgsql;
CREATE EXTENSION IF NOT EXISTS plv8;
Was this Helpful?
up
291 users have voted.

How do I stop auto-updating on a Display script?

Here's how:

mywindow.setAutoUpdateEnabled(false);
Was this Helpful?
up
291 users have voted.

What are item groups?

Item groups provide an alternate means for sorting items into categories. The advantage to item groups is that a single item may belong to multiple item groups. This is in contrast to class codes and product categories, in that single items may belong to only one of each of these categories.

Was this Helpful?
up
291 users have voted.

What are the size requirements for logos on xTupleCommerce sites?

The standard Prodiem demo site features a logo which is 309 pixels (width) x 78 pixels (height). We suggest that you scale your logo to match the 78px height. You can use whatever size you want, but keep in mind that whatever you choose will impact the header throughout the website. For a clear logo, you'll need a resolution of at least 72dpi. We also recommend using .PNG or .JPEG files, if posssible.

Was this Helpful?
up
291 users have voted.