[QODBC-Desktop] QODBC: Accessing Vendor Additional Contact Fields (Work Phone, Mobile, Website)

Problem Description:

Users need to access additional contact information for vendors - specifically Work Phone, Mobile, and Website fields - via QODBC. These fields are not directly visible in the Vendor table by default until the appropriate hotfix is applied.

Affected products: QODBC Desktop
Expected outcome: Additional contact fields on the Vendor table are accessible through AdditionalContactRef columns, and can also be exported in QXL after installing the latest version.

Symptoms:

• WorkPhone1, MobilePhone1, and Website1 columns do not appear in the Vendor table schema.
• The Vendor Address Info Work Phone, Mobile, Website, and Other 1 fields are not found in either Vendor or VendorContacts tables.
• QXL does not export newly added vendor contact fields even after installing a beta hotfix.

Cause:

QuickBooks Desktop stores additional contact information for vendors in an AdditionalContactRef repeating structure, similar to how customer contact fields are stored. Prior to the hotfix (B01745 / B01752), QODBC did not expose these fields in the Vendor table. The QODBC team added them starting with those beta builds.

Environment:

Resolution:

Step 1: Install the latest version of QODBC Desktop

1. Download the latest full version of QODBC. Go to the official QODBC download page: https://qodbc.com/download/
2. Run the installer and bypass the CDKEY prompt during installation. When prompted for a CDKey, skip/pause/bypass that step - do NOT enter your CDKEY yet. Complete the installation as-is.
3. Reboot the machine.
4. After reboot, activate from the QODBC Setup Screen. Open the QODBC Setup Screen (Start → All Programs → QODBC Driver for QuickBooks → Configure 32-Bit QODBC Driver) → About tab → enter your CDKEY to activate.

Sp_optimizefullsync All

Use the QODBC Support Wizard to run this command. See How to use QODBC Support Wizard for details.

Step 2: Use AdditionalContactRef Fields on the Vendor Table

The hotfix adds AdditionalContactRef1 and AdditionalContactRef2 columns to the Vendor table. Each contact entry has two parts:

• AdditionalContactRefContactName - the label (e.g., "Work Phone", "Mobile", "Website")
• AdditionalContactRefContactValue - the actual value (phone number, URL, etc.)

Read vendor additional contact data:

SELECT Name, AdditionalContactRef1ContactName, AdditionalContactRef1ContactValue, AdditionalContactRef2ContactName, AdditionalContactRef2ContactValue FROM Vendor

Update a vendor's Work Phone:

UPDATE Vendor SET AdditionalContactRef1ContactName = 'Work Phone', AdditionalContactRef1ContactValue = '555-0100' WHERE Name = 'Vendor Name'

Update Work Phone and Website in one statement:

UPDATE Vendor SET AdditionalContactRef1ContactName = 'Mobile', AdditionalContactRef1ContactValue = '555-0101', AdditionalContactRef2ContactName = 'Website', AdditionalContactRef2ContactValue = 'https://example.com' WHERE Name = 'Vendor Name'

Step 3: Install the latest version of QXL Desktop

1. Download the latest version of QXL Desktop:
   Installer: QXLSetup.exe
   Readme: readme.rtf
2. Close all applications that use QXL or QuickBooks.
3. Uninstall the current version of QXL.
4. Install the latest version of QXL Desktop.
   Do not deactivate your existing CDKEY/License during this process.
5. Restart Windows.
6. Verify the version change: Open QXL, click the Settings/Options icon, and navigate to the About window to confirm the new version number is displayed.

Additional Notes:

• Beta version usage: The QODBC team confirmed that using the beta version (B01752) in production is acceptable, with a stable build expected within 30–45 days.
• sp_optimizefullsync returns no records: This is the expected result - it indicates successful sync. The optimizer file is created in %appdata%\QODBC Driver for QuickBooks, not returned as a result set.
• Multiple contact entries: Use AdditionalContactRef1, AdditionalContactRef2, etc. for additional contact entries on the same vendor record.

Related Articles:

QODBC Customer Contact Field (Mobile, Fax) Update via QODBC QODBC Optimizer - How to Enable, Rebuild, and Troubleshoot Performance Understanding QODBC Data Access Limitations

Keywords: