[QXL-Desktop] QXL v24 Upgrade Adds Unwanted Version Tracking Columns to All Exports
Problem Description:
After upgrading QXL to version 24.x, all exports include four additional columns that were not present in earlier versions: QXLExportDateTime, QXLExportMachineName, QXLExportUserName, and QXLVersionNumber. These columns are automatically appended by QODBC to every export, even when they are not requested in the query.
Affected products: QXL Desktop v24.x Expected outcome: Exports contain only the columns specified in the user's query, matching pre-v24 behavior.
Symptoms:
- After upgrading to QXL v24, exported files contain four extra columns: QXLExportDateTime, QXLExportMachineName, QXLExportUserName, and QXLVersionNumber.
- These columns cannot be excluded via the query - they are automatically appended by the driver layer.
- Existing export workflows (e.g., daily invoice exports imported into shipping systems) fail because the unexpected columns cause schema mismatches.
- The issue affects all export types, not just specific table queries.
Cause:
Bug ID: B01743 (tracking L00076).
- When QODBC introduced export version-tracking fields to support audit and compliance requirements, they were added automatically at the driver level for all exports.
- The feature was designed as an opt-in capability (some clients requested these columns), but the implementation defaulted them to "always on" without a user-configurable toggle in the initial release of v24.
- This means the issue is not a configuration error - it is a documented bug in the initial QXL v24 releases.
Environment:
| Product | Version / Detail |
| QXL Desktop |
v24.x (initial releases, prior to QXL Desktop v24.0.0.046) |
| QuickBooks Desktop |
All editions - this is a QXL-side issue, not QB-specific |
Resolution:
- Recommended: Install the fix (v24.0.0.046 or later). This release adds a checkbox option:
- Open QXL → Settings/Options icon → Advanced tab
- Enable the "Do not add version fields" checkbox
- All subsequent exports will no longer include the four version-tracking columns
- Workaround for users unable to install v046: Downgrade to QXL v23.0.0.043. This is the last known version before the version-tracking fields were added.
- Close all applications that use QXL or QuickBooks
- Uninstall current QXL
- Download QXL v23.0.0.043 from: QXL Setup Installer
- Install the previous version
Example Scenarios:
Scenario 1 - Automated daily invoice export to shipping system:
A company exports their daily invoices using a QXL query and imports the resulting file into their shipping platform. After upgrading to QXL v24, the four new columns cause the import to fail due to schema mismatch. They enable "Do not add version fields" in QXL v24 RC or downgrade to v23 to restore the original export format.
Scenario 2 - Reporting pipeline with fixed column expectations:
A business uses QXL to populate a reporting database with fixed column positions. The unexpected columns shift all data, corrupting downstream reports. Enabling the checkbox in the QXL Desktop v046 or downgrading resolves the issue.
Additional Notes:
- The "Do not add version fields" option is available starting with QXL v24.0.0.046. Earlier v24 releases do not have this toggle.
- If you downgrade to v23, you will lose any new features introduced in QXL v24. Evaluate whether those features are important enough to justify keeping the version-tracking columns and enabling the exclusion checkbox instead.
- This is a documented bug (B01743) tracked by QODBC development. The fix was confirmed working after installation of the QXL Desktop v046.
Related Articles:
How to use QXL QXL options and settings
Keywords:
QXL Export Version Columns B01743 Unwanted Columns Schema Mismatch Do Not Add Version Fields Export Format QXL v24 Bug Fix RC Build Downgrade Workaround
Support Tickets: RCU-820-84749
|