Compatibility Matrix

 

Overview

When you upgrade from one version of xTuple ERP to another, it is required that you upgrade the core xTuple software. For PostBooks users, this means the core PostBooks database must be upgraded. For commercial edition users, this means the core commercial database must be upgraded. Performing an upgrade to the core software is a prerequisite for moving from one version of xTuple ERP to the next.

It is not always necessary, however, to upgrade the extension packages or other applications which operate with xTuple. That's where this compatibility matrix comes in. This matrix is designed to help ensure your extension packages and other applications are compatible with the xTuple ERP version you are currently running—or upgrading to. The following packages and applications are covered by this document:

If you are a third-party application developer and would like to have your application information added to this compatibility matrix, we invite you to help us keep this matrix up-to-date.

Manufacturing Package

The manufacturing package (xtmfg) is a commercial extension to the core commercial software. When added to a core commercial database, the manufacturing package upgrades the database to the Manufacturing Edition. During version upgrades, it is not always necessary to upgrade the manufacturing edition package.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x 4.1.x 4.0.x 3.8.x 3.7.4
MFG 4.4.x x            
  4.3.x   x          
  4.2.x     x        
  4.1.x       x      
  4.0.x         x    
  3.8.x           x  
  3.7.4             x

 

xTuple Connect

xTuple Connect is a commercial application which operates with all xTuple ERP Editions. The xTuple Connect application consists of two parts: a GUI client and an extension package (xtbatch). The xTuple Connect GUI client version will always be the same as the xTuple Connect extension package version.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x 4.1.x 4.0.x 4.0.0 3.8.x 3.7.4
xTuple   Connect 3.7.2 x x x          

 

3.7.1       x x      
  3.7.0         x      
  3.7.0 RC           x    
  3.6.2           x x x
  3.6.1             x* x

* Connect 3.6.1 cannot be installed for the first time on xTuple ERP 3.8.x. Upgrading your existing xTuple Connect to 3.6.1 is supported.

 

xTuple Supported PostgreSQL Versions

xTuple ERP versions prior to 3.0 are not supported on PostgreSQL 8.3.x. Also, as of xTuple ERP 3.8.x, versions of PostgreSQL prior to 8.4.x are not supported. If you are running xTuple 2.3.2 or older, you should not be running on PostgreSQL 8.3 or newer.

ALSO NOTE: Users who load backup files (e.g., empty.backup, quickstart.backup, and demo.backup) should be advised that as of xTuple 3.2.2 those backup files are being dumped from a PostgreSQL 8.3 database. That means the backups must also be loaded on PostgreSQL 8.3 (or higher) to avoid backward incompatibility problems.

xTuple version PostgreSQL Version
4.4.x 9.1 - 9.3
4.1.x - 4.3.x 8.4 - 9.1
4.0.x 8.4 - 9.1
3.8.x 8.4 - 9.1
3.7.4 8.3 - 8.4

 

Mobile Web Client

Over the course of the 4.x product releases, xTuple will make the entirety of its award-winning accounting, CRM and ERP available in the Mobile Web client.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x

4.1.x

Mobile Tag 4.4.x x      
  1.7.x - 1.8.x   x    
  1.5.x - 1.6.x     x  
 

1.4.4 - 1.4.5

      x

 

Wholesale Distribution

xWD is a collection of core enhancements and extension packages designed to extend xTuple ERP to serve the Wholesale Distribution community.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x
xWD 2.2.0 x x x
  2.1.0   x x

 

Time and Expense

The Time and Expense package (xttelite) is a free extension package which operates with all xTuple ERP Editions.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x 4.1.x 4.0.x 3.8.x 3.7.4
T&E 2.2.0 x x x        
  2.1.0       x x    
  2.0.6       x x    
  2.0.5           x  
  2.0.x             x

 

Project Accounting

The Project Accounting package (xtprjaccnt) is a commercial package which can be added to any edition of xTuple ERP.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x 4.1.x 4.0.x 3.8.x 3.7.4
Project Accounting 1.2.0 x x x        
  1.1.2       x x    
  1.1.1           x  
  1.1.0             x

 

Enhanced Commissions

The Enhanced Commissions package (xtcommission) is a commercial package which can be added to any edition of xTuple ERP.

xTuple ERP Version
    4.4.x 4.3.x 4.2.x 4.1.x 4.0.x 3.8.x
Enhanced Commissions 1.6 x x x      
  1.5       x    
  1.2         x x
  1.1           x
  1.0           x

 

QuickStart Wizard

The QuickStart Wizard package (xtsetup) is a commercial extension package which operates with all xTuple ERP Editions. For the QuickStart Wizard to work, you must have the Desktop package (xtdesktop) installed.

xTuple ERP Version
    4.0.x- 4.4.x 3.8.x 3.7.4
QSW 3.8.0 x x x
  3.7.0 x x x
  3.6.0     x

 

Updater

The Updater is a free application used for upgrading databases and loading extension packages. The Updater may be used with all xTuple ERP Editions.

xTuple ERP Version
    4.0.x- 4.4.x 3.8.x 3.7.4
Updater 2.2.5 x x x
 

2.2.0-4

    x

 

Desktop

The Desktop package (xtdesktop) is a free extension package which operates with all xTuple ERP Editions.

xTuple ERP Version
    4.2.x - 4.4.x 4.0.x - 4.1.x 3.8.x
Desktop 3.8.3 x    
  3.8.2   x  
  3.8.1   x  
  3.8.0   x  
  3.7.2   x  
  3.7.1     x

 

Third-Party Applications

The following table includes a list of third-party applications and the xTuple ERP versions they are compatible with. You can download third-party applications from the  xChange. Also look for additional information about the applications on the third-party documentation page.

xTuple ERP Version
    3.6.x 3.5.x 3.4.0 3.3.x 3.2.2
Contact Merge 3.3.0     x x  
Executive Summary Dashboard 1.0     x x x
YellowDog Wireless 3.2     x x x

 

Fixed Asset Management

The Fixed Asset Management packages are a series of packages available for all xTuple Editions.  The following table indicates the xTuple and PostgreSQL database versions the packages have been tested on.

Package Package Version xTuple Version PostgreSQL Version
    3.6.x 3.8.x     8.4    8.4 - 9.1
Fixed Asset (free extension package) 1.0.x X   X  
  1.1 X X X X
Fixed Asset Depreciation 1.0.x X   X  
  1.1 X X X X
Fixed Asset Maintenance 1.0.x X   X  
  1.1 X X X X

 

 
busquier's picture
Offline
Joined: 12/30/2005
.qm files included in compatibility matrix

Hello, Sirs.

I am using xTuple Postbooks Edition V.3.3.0. I have not updated to newer versions because in the translation portal the only .qm file available for spanish is for this older 3.3.0. It would be good to include the available translation files in this compatibility matrix.

Kind regards,

Federico Busquier
Valencia, Spain

 
ptyler's picture
Offline
Joined: 12/10/2008
.QM files

Hi, Federico:

The 3.5.0 .qm files are available on the translation portal now. We upgraded all the projects last week. Meanwhile, older .qm files are generally compatible with newer xTuple versions. But, to your point, using the .qm version to match your xTuple version is always a good idea.

Regards,
Pierce

 
Benzev's picture
Offline
Joined: 05/08/2011
Quickstart wizard

I have purchased a Quickstart wizard for version 3.6 .. Will this wizard work for version 3.7.0 which i have just installed?

Thanks

Ben

 
rshapiro's picture
Offline
Joined: 07/24/2009
Upgrading Enterprise

Does the Enterprise edition upgrade gz file include the upgrade of xtbatch/xtconnect, xtprjacct, xtdesktop, and te packages? I am preparing to upgrade from 3.6.0 to 3.7.0.

Thanks, Rebecca

 
ptyler's picture
Offline
Joined: 12/10/2008
Enterprise upgrade

Hi, Rebecca:

I've converted this question to a support ticket. Let's take up the conversation there.

Best,
Pierce

 
fblauer's picture
Offline
Joined: 01/11/2007
xt desktop package

How about the xtdesktop? Will the latest 3.7.1 work with 3.7.x and 3.8.x of the xtcore?

 
julesstp's picture
Offline
Joined: 09/15/2009
Thank you!

Can't believe I have never discovered this post until now! Thank you!

 
tjrtech's picture
Offline
Joined: 12/14/2012
Upgrading From xTuple 3.5.4 to xTuple 4.0

If we wanted to upgrade from xTuple 3.5.4 to xTuple 4.0, what would be the process? Here is what have right now.

 

xTuple 3.5.4 Clients running on PostgreSQL 8.4.15 Server

 

Would I need to update the PG server to 9.1? The DB Matrix says it should work, but when I try to run XT 4.0 client gui, it fails against pg 8.4. I am guessing it would need to be updated even though the above compat matrix says otherwise. Thank you very much!

 
tjrtech's picture
Offline
Joined: 12/14/2012
Updater Scripts

I was also looking at using an update script to do the job, but there only seems to be script from the database immediately previous to the one in question (ie. 3.5.3 to 3.5.4) How would I update from one severl generations apart (3.5.4 - 4.0.0 or 4.0.1)? Would I have update one level at a time? That is a lot of work and a lot o chances for error it would seem.

 
jrg345's picture
Offline
Joined: 02/22/2012
Not compatible with new PostgreSQL

Trying use the updater or postbooks with PostgreSQL 9.2 fails. One reason is the name of a column has changed in pg_stat_actvivty; procpid is now pid.

I try to keep my servers up to date. PostgreSQL 9.1 is not even available on Fedora 19.

I know that PostBooks 4.2 just released, is there a version coming that will work with the most recent PostgreSQL?

 
jrogelstad's picture
Offline
Joined: 12/10/2008
4.3 Beta, which is close to

4.3 Beta, which is close to being ready for publishing, will have a fix for the Postgres pid problem. 

 
jrg345's picture
Offline
Joined: 02/22/2012
Thanks.

Thanks.

 
jrg345's picture
Offline
Joined: 02/22/2012
Trying to use the updater  to

Trying to use the updater  to update PostBooks using PostgreSQL 9.2.6 get the error:

A System Error occurred at login2.cpp::373:
ERROR:  column "procpid" does not exist
LINE 1: SELECT pg_try_advisory_lock(datid::integer, procpid)
                                                    ^
QUERY:  SELECT pg_try_advisory_lock(datid::integer, procpid)
     FROM pg_stat_activity
    WHERE(procpid = pg_backend_pid())
CONTEXT:  PL/pgSQL function login(boolean) line 10 at PERFORM
PL/pgSQL function login() line 9 at RETURN
 

How can I upgrade to the newer PostBooks versions using pb42xto430.gz and pb43xto440.gz if the updater will not connect to the database?

 
ned
ned's picture
Offline
Joined: 10/20/2008
What is the current (working)

What is the current (working) version that you have installed (xTuple and PostgreSQL)?

Note that the matrix above clearly states that PostgreSQL 9.2 isn't supported until xTuple 4.4.

 
jrg345's picture
Offline
Joined: 02/22/2012
I have XTuple 4.2 and

I have XTuple 4.2 and PostgreSQL 9.1.7

I just  thought that the updater should be able to update an older xTuple to a newer one.

 

If I understand correctly, I have to update to 4.4 using the xTuple updater to get the database updated, then I can export the xTuple database and import it to PostgreSQL 9.2

 

Will the updater work in the future against PostgreSQL 9.2 after I upgrade to xTuple 4.4? Or will I have to keep a PostgreSQL 9.1 around indefinitely in order for the updater to work?

 
ned
ned's picture
Offline
Joined: 10/20/2008
The Updater application only

The Updater application only updates the xTuple database (think of it as one file) - not the PostgreSQL database server.  So you are correct, use the Updater to upgrade from 4.2 to 4.4, and confirm that everything is working correctly before attempting to upgrade the database server.

Once that's all looking good, then yes, dump the database to a file, and you can then restore that file to a PostgreSQL 9.2 database server.

The Updater application should work fine with PostgreSQL9.2 once you've followed the above steps.

 
jrg345's picture
Offline
Joined: 02/22/2012
Thanks.   Up on PostgreSQL

Thanks.

 

Up on PostgreSQL 9.2 with xTuple 4.4