<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
<channel>
<title><![CDATA[FLEXquarters.com Limited]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/]]></link>
<description />
<generator><![CDATA[Kayako case v4.66.2]]></generator>
<item>
<title><![CDATA[[QXL-Desktop] - Resolving System.OutOfMemoryException in QXL Desktop After QuickBooks Update]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3211]]></link>
<guid isPermaLink="false"><![CDATA[6b620aedfa4cf153467265629501dd61]]></guid>
<pubDate><![CDATA[Fri, 16 Oct 2026 12:07:58 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[[QXL-Desktop] - Resolving System.OutOfMemoryException in QXL Desktop After QuickBooks Update
Problem Description:
After updating QuickBooks Desktop to a newer version, running QXL Desktop may throw a System.OutOfMemoryException during export operations....]]></description>
<content:encoded><![CDATA[<h2>[QXL-Desktop] - Resolving System.OutOfMemoryException in QXL Desktop After QuickBooks Update</h2>
<h3 id="summary">Problem Description:</h3>
<p>After updating QuickBooks Desktop to a newer version, running QXL Desktop may throw a <strong>System.OutOfMemoryException</strong> during export operations. This is caused by memory management issues in older QXL builds that are not fully compatible with the updated QuickBooks SDK.</p>
<div class="callout warning">
<div class="callout-title">Error</div>
<p style="margin: 0;"><strong>Exception of type "System.OutOfMemoryException" was thrown</strong></p>
</div>
<p><strong>Affected products:</strong> QXL Desktop (versions prior to RC build 24.0.0.046), QuickBooks Desktop (recently updated)<br /> <strong>Expected outcome:</strong> After updating to the latest QXL release candidate and applying the Close Connection setting, export operations complete without memory errors.</p>
<h3 id="symptoms">Symptoms:</h3>
<ul>
<li>An OutOfMemoryException error appears when running an export or report in QXL Desktop.</li>
<li>The issue begins after upgrading QuickBooks Desktop to a newer version.</li>
<li>Previously working exports suddenly fail without any changes to the QXL configuration.</li>
</ul>
<h3 id="cause">Cause:</h3>
<p>A bug in older QXL builds causes excessive memory consumption when communicating with newer versions of the QuickBooks SDK. The issue has been fixed in a later release candidate build.</p>
<h3 id="resolution">Solution:</h3>
<ol class="steps">
<li><strong>Download the latest version of QXL Desktop:</strong><br />Installer: <a href="https://qxl1.com/qxl-for-quickbooks-desktop-downloads/" target="_blank">QXLSetup.exe</a><br />Readme: <a href="https://qxl1.com/download/readme.rtf" target="_blank">readme.rtf</a></li>
<li><strong>Uninstall the current QXL version.</strong><br />Close all applications that use QXL or QuickBooks before uninstalling.</li>
<li><strong>Install the downloaded QXL Desktop installer.</strong><br />Do not deactivate your existing CDKEY/License during this process.</li>
<li><strong>Restart Windows.</strong></li>
<li><strong>Verify the version change:</strong> Open QXL, click the Settings/Options icon, and navigate to the <strong>About</strong> window to confirm the new version number is displayed.</li>
<li><strong>Test your export operation.</strong> The OutOfMemoryException should no longer occur.</li>
</ol>
<h3 id="workaround">Additional Workaround: Close Connection After Export</h3>
<p>If the memory issue persists after updating, set the <strong>Close Connection "After Export"</strong> option to <strong>1</strong>:</p>
<ol class="steps" start="7">
<li>In QXL, open <strong>Settings/Options</strong>.</li>
<li>Find the <strong>"Close Connection After Export"</strong> setting and set it to <strong>1</strong>.</li>
<li>Re-run your export. This forces QXL to close its QuickBooks connection after each export, reducing memory pressure.</li>
</ol>
<h3 id="related-articles">Related Articles:</h3>
<p><a class="related-article" href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2641" target="_blank">How to Download and Install QXL Desktop</a> <a class="related-article" href="#">QXL Desktop Log Files and Troubleshooting</a></p>
<h3 id="keywords">Keywords:</h3>
<div class="keywords-section"><span class="keyword-tag">OutOfMemoryException</span> <span class="keyword-tag">QXL Desktop</span> <span class="keyword-tag">Release Candidate</span> <span class="keyword-tag">Memory Error</span> <span class="keyword-tag">QuickBooks Update</span> <span class="keyword-tag">Close Connection After Export</span> <span class="keyword-tag">Installation Fix</span> <span class="keyword-tag">SDK Compatibility</span></div>
<div class="article-footer">
<p><span class="ticket-id">Support Tickets:</span> FLU-831-93301, EBU-166-27945</p>
</div>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to export QuickBooks Data to OpenOffice using QXL]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3035]]></link>
<guid isPermaLink="false"><![CDATA[03bfc1d4783966c69cc6aef8247e0103]]></guid>
<pubDate><![CDATA[Mon, 04 May 2020 11:53:59 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export QuickBooks Data to OpenOffice using QXL
Problem Description:
How to export QuickBooks Data to OpenOffice using QXL
Solutions:&nbsp;
Download and install OpenOffice on your system.
Start QXL Desktop
&nbsp;
Export the QuickBooks Compan...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;"> How to export QuickBooks Data to OpenOffice using QXL</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Problem Description:</span></h3>
<p>How to export QuickBooks Data to OpenOffice using QXL</p>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Solutions:</span>&nbsp;</h3>
<p>Download and install OpenOffice on your system.</p>
<p>Start QXL Desktop</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/QXL-BeforeStart.png" alt="" /></p>
<p>Export the QuickBooks Company Data</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/QXL-AfterExported.png" alt="" /></p>
<p>Once the export is complete, the output folder showing the list of files will open automatically.</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/QXL-AfterExported.png" alt="" /></p>
<p>The output folder will contain&nbsp;the exported files.</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/Exported files.png" alt="" /></p>
<p>Start your OpenOffice application on your Desktop.</p>
<p>Click on the "Open" option to navigate the exported files' Output folder.</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/Open Office.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/Open Office browsed qxl files.png" alt="" /></p>
<p>Double-click on any file to open it with the OpenOffice application.</p>
<p>Or</p>
<p>Select any file and click on "open" with the OpenOffice application.</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/3035/Exported files Account.png" alt="" /></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Online] Troubleshooting - How to cancel the subscription of QXL Online for QuickBooks Online]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3024]]></link>
<guid isPermaLink="false"><![CDATA[e5522f7ac7cd76f19b396595c9c25b40]]></guid>
<pubDate><![CDATA[Fri, 31 May 2019 13:51:36 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - How to cancel the subscription of QXL&nbsp;Online for QuickBooks Online 
Problem Description:
I want to cancel my QXL Online monthly subscription. How to cancel the subscription to&nbsp;QXL Online for QuickBooks Online?
&nbsp;I recei...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - How to cancel the subscription of QXL&nbsp;Online for QuickBooks Online </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I want to cancel my QXL Online monthly subscription. <br /><br />How to cancel the subscription to&nbsp;QXL Online for QuickBooks Online?</span></p>
<p>&nbsp;I received an email saying a subscription was going to be renewed. I need to cancel this subscription.</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Latest Method:</span></span></p>
<p>Please visit the following link:&nbsp;<a href="https://flexquarters.onfastspring.com/account">https://flexquarters.onfastspring.com/account</a>.</p>
<p><br /><img src="//support.flexquarters.com/esupport/newimages/2787/fastspring-input-email-to-manage-account.png" alt="" border="0" /></p>
<h3>&nbsp;</h3>
<p>&nbsp;</p>
<p>Input the email address associated with your license.</p>
<p>Check your email inbox, and you should receive an email with the subject:</p>
<p>&lt;Your Fullname&gt;, here is a link to manage your orders</p>
<p>From:&nbsp;FastSpring Checkout &lt;mailer@fastspring.com&gt;</p>
<p>&nbsp;</p>
<p><br /><img src="//support.flexquarters.com/esupport/newimages/2787/fastspring-manage-account.png" alt="" border="0" /></p>
<h3>&nbsp;</h3>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Click the link received to manage your account.</p>
<p>The link (URL) should look like&nbsp;https://flexquarters.onfastspring.com/account/somerandomtext.</p>
<p><br /><img src="//support.flexquarters.com/esupport/newimages/3024/screencapture-flexquarters-onfastspring-account.png" alt="" border="0" /></p>
<p>&nbsp;</p>
<p><br /><img src="//support.flexquarters.com/esupport/newimages/2787/fastspring-manage-account-cancel.png" alt="" border="0" /></p>
<h3>&nbsp;</h3>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Latest Method:</span></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You can manage the subscription to QXLOnline using the link you received in your renewal email. </span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">On your monthly&nbsp;<span class="il">subscription</span>&nbsp;renewal receipt, you will see the following, as in this example:<br /><br />Order ID: FLE1X1XXX-1XXX-6XXXXB<br />1&nbsp;QXL Online for QuickBooks Online<br /><a href="https://sites.fastspring.com/flexquarters/order/s/" target="_blank" data-saferedirecturl="https://www.google.com/url?q=https://sites.fastspring.com/flexquarters/order/s/&amp;source=gmail&amp;ust=1559397222198000&amp;usg=AFQjCNFWkGihgSL3Tg--dcBbe2dBlkt-yQ">https://sites.<span class="il">fastspring</span>.com/<wbr />flexquarters/order/s/</a>&nbsp;(your order number). Click on this link on YOUR receipt, and you can cancel the&nbsp;<span class="il">subscription</span>.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><br />Example:<br />https://sites.fastspring.com/flexquarters/order/s/FLE111111-1111-111111<br /><br />Please visit the link &amp; click on <strong>Cancel Subscription</strong> to cancel your QXL Online subscription:<br /><br /> <img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/CancelSub/qxlsubscriptioncancel.png" alt="" border="0" /> </span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-All] How to enable encrypted connection to the database]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3014]]></link>
<guid isPermaLink="false"><![CDATA[77edbe5f897a5dbcde49d31bec1537b8]]></guid>
<pubDate><![CDATA[Thu, 14 Jun 2018 16:34:16 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[[QXL-All] How to enable encrypted connection to the database
SQL Server

Enable Encrypted Connections to the Database Engine
How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
How to Enable Encrypted Conn...]]></description>
<content:encoded><![CDATA[<h2><span id="QXLFAQSQLODBCEncryptHelp" style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">[QXL-All] How to enable encrypted connection to the database</span></h2>
<p>SQL Server</p>
<ul>
<li><a href="https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-2017" target="_blank">Enable Encrypted Connections to the Database Engine</a></li>
<li><a href="https://support.microsoft.com/en-in/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-mi" target="_blank">How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console</a></li>
<li><a href="https://www.accuwebhosting.com/blog/enable-encrypted-connection-to-sql-server/" target="_blank">How to Enable Encrypted Connection to SQL Server</a></li>
</ul>
<p>My SQL</p>
<ul>
<li><a href="https://dev.mysql.com/doc/refman/5.5/en/using-encrypted-connections.html" target="_blank">Configuring MySQL to Use Encrypted Connections (5.5)</a></li>
<li><a href="https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html" target="_blank">Using Encrypted Connections (8.0)</a></li>
<li><a href="https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html" target="_blank">Configuring MySQL to Use Encrypted Connections (8.0)</a></li>
<li><a href="https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/building-with-encrypted-connection-support.html" target="_blank">Building MySQL with Support for Encrypted Connections (5.7)</a></li>
</ul>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to run a Balance Sheet Standard report - with multiple levels]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3013]]></link>
<guid isPermaLink="false"><![CDATA[4110a1994471c595f7583ef1b74ba4cb]]></guid>
<pubDate><![CDATA[Thu, 14 Jun 2018 12:06:20 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[[QXL-Desktop] How to run a Balance Sheet Standard report - with multiple levels 
Problem Description:
I am using QXL &amp; I want to run&nbsp;the Balance Sheet standard report through QXL. I can see the report on the list. But I want to change the repor...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">[QXL-Desktop] How to run a Balance Sheet Standard report - with multiple levels </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to run&nbsp;the Balance Sheet standard report through QXL. I can see the report on the list. But I want to change the report parameter.</p>
<p>How can I add multiple levels similar to the QuickBooks application (UI) report?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can change the report query &amp; parameter from the QXL Report Settings tab.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step1.png" alt="" /></p>
<p>Input following</p>
<p>Output Table Name = BalanceSheetStandard</p>
<p>Report Query/Command =&nbsp;sp_report BalanceSheetStandard show Amount_Title, NestedText1,NestedText2,NestedText3,NestedText4, Amount parameters DateMacro = 'ThisMonthToDate', ReportDetailLevelFilter='All'</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/2018-06-14 17_40_10-QXL Desktop BSS-Add.png" alt="" /></p>
<p>&nbsp;</p>
<p>You can modify the report query&nbsp;using the Report Query/Command box.</p>
<p>You can refer to the&nbsp;<a href="http://qodbc.com/schema.htm">QXL Data Layouts</a> site for details about different report parameters.</p>
<p>Navigate to the above link &amp; click on the region of the QuickBooks edition you are using.</p>
<p>You will be redirected to the QuickBooks region link. Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"BalanceSheetStandard"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the BalanceSheetStandard report.</p>
<p>If you are using a&nbsp;<strong>QuickBooks USA</strong> user, then you can refer to the direct link for <a href="http://doc.qodbc.com/qodbc/usa/ReportParameter.php?tableName=BalanceSheetStandard">PARAMETERS AND VALUES FOR&nbsp;BalanceSheetStandard</a></p>
<p>You can use any of the supported parameters in the report query.</p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/2018-06-14 17_29_51-QXL Desktop 2018 - BSS-Update.png" alt="" /></p>
<p>&nbsp;</p>
<p>The modified report query&nbsp;will be updated on the list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/2018-06-14 17_29_51-QXL Desktop 2018 - BSS-Updated.png" alt="" /></p>
<p>By repeating the above process, you can add different reports with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from the QXL Main Window.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step7.png" alt="" /></p>
<p>Report Exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/2018-06-14 17_59_43-BSS-FileExported.png" alt="" /></p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/Compare-Sample-BalanceSheet-Report-QXL-QB.png" alt="" width="95%" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - Cannot modify the design of the table - It is in a read-only database. Source:odbcjt32.dll]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3012]]></link>
<guid isPermaLink="false"><![CDATA[5a01f0597ac4bdf35c24846734ee9a76]]></guid>
<pubDate><![CDATA[Thu, 31 May 2018 11:29:02 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[Troubleshooting - Cannot modify the table's design - It is in a read-only database. Source:odbcjt32.dll
Problem Description:
I keep getting an error message that states&nbsp;Error Occurred: unable to create table in destination database-customer-access,...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">Troubleshooting - Cannot modify the table's design - It is in a read-only database. Source:odbcjt32.dll</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I keep getting an error message that states&nbsp;<br />Error Occurred: unable to create table in destination database-customer-access, QXL, additionalInfo: tableselection-customer,Table-40, Tables 152<br />I look in the logs, and it states&nbsp;<br /><br />Exception classes:&nbsp;<br />System.Data.Odbc.OdbcException<br />Exception messages:&nbsp;<br />Message: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'QXLCustomer.' It is in a read-only database. Source:odbcjt32.dll</p>
<p>&nbsp;</p>
<p><br />Additional Info: CREATE TABLE "QXLCustomer" (<br />"Name" TEXT(41) NOT NULL,<br />"FullName" TEXT(209),<br />"IsActive" YESNO,<br />"ClassRefListID" TEXT(36),<br />"ClassRefFullName" TEXT(209),<br />"ParentRefListID" TEXT(36),<br />"ParentRefFullName" TEXT(209),<br />"Sublevel" INTEGER,<br />"CompanyName" TEXT(41),<br />"Salutation" TEXT(15),<br />"FirstName" TEXT(25),<br />"MiddleName" TEXT(5),<br />"LastName" TEXT(25),<br />"JobTitle" TEXT(41),<br />"BillAddressAddr1" TEXT(41),<br />"BillAddressAddr2" TEXT(41),<br />"BillAddressAddr3" TEXT(41),<br />"BillAddressAddr4" TEXT(41),<br />"BillAddressAddr5" TEXT(41),<br />"BillAddressCity" TEXT(31),<br />"BillAddressState" TEXT(21),<br />"BillAddressProvince" TEXT(21),<br />"BillAddressCounty" TEXT(21),<br />"BillAddressPostalCode" TEXT(13),<br />"BillAddressCountry" TEXT(31),<br />"BillAddressNote" TEXT(41),<br />"BillAddressBlockAddr1" TEXT(41),<br />"BillAddressBlockAddr2" TEXT(41),<br />"BillAddressBlockAddr3" TEXT(41),<br />"BillAddressBlockAddr4" TEXT(41),<br />"BillAddressBlockAddr5" TEXT(41),<br />"ShipAddressAddr1" TEXT(41),<br />"ShipAddressAddr2" TEXT(41),<br />"ShipAddressAddr3" TEXT(41),<br />"ShipAddressAddr4" TEXT(41),<br />"ShipAddressAddr5" TEXT(41),<br />"ShipAddressCity" TEXT(31),<br />"ShipAddressState" TEXT(21),<br />"ShipAddressProvince" TEXT(21),<br />"ShipAddressCounty" TEXT(21),<br />"ShipAddressPostalCode" TEXT(13),<br />"ShipAddressCountry" TEXT(31),<br />"ShipAddressNote" TEXT(41),<br />"ShipAddressBlockAddr1" TEXT(41),<br />"ShipAddressBlockAddr2" TEXT(41),<br />"ShipAddressBlockAddr3" TEXT(41),<br />"ShipAddressBlockAddr4" TEXT(41),<br />"ShipAddressBlockAddr5" TEXT(41),<br />"Phone" TEXT(21),<br />"AltPhone" TEXT(21),<br />"Fax" TEXT(21),<br />"Email" MEMO,<br />"Cc" MEMO,<br />"Contact" TEXT(41),<br />"AltContact" TEXT(41),<br />"CustomerTypeRefListID" TEXT(36),<br />"CustomerTypeRefFullName" TEXT(159),<br />"TermsRefListID" TEXT(36),<br />"TermsRefFullName" TEXT(31),<br />"SalesRepRefListID" TEXT(36),<br />"SalesRepRefFullName" TEXT(5),<br />"Balance" DOUBLE,<br />"TotalBalance" DOUBLE,<br />"OpenBalance" DOUBLE,<br />"OpenBalanceDate" DATETIME,<br />"SalesTaxCodeRefListID" TEXT(36),<br />"SalesTaxCodeRefFullName" TEXT(3),<br />"TaxCodeRefListID" TEXT(36),<br />"TaxCodeRefFullName" TEXT(3),<br />"ItemSalesTaxRefListID" TEXT(36),<br />"ItemSalesTaxRefFullName" TEXT(31),<br />"SalesTaxCountry" TEXT(31),<br />"ResaleNumber" TEXT(15),<br />"AccountNumber" TEXT(99),<br />"BusinessNumber" TEXT(99),<br />"CreditLimit" DOUBLE,<br />"PreferredPaymentMethodRefListID" TEXT(36),<br />"PreferredPaymentMethodRefFullName" TEXT(31),<br />"CreditCardInfoCreditCardNumber" TEXT(25),<br />"CreditCardInfoExpirationMonth" INTEGER,<br />"CreditCardInfoExpirationYear" INTEGER,<br />"CreditCardInfoNameOnCard" TEXT(41),<br />"CreditCardInfoCreditCardAddress" TEXT(41),<br />"CreditCardInfoCreditCardPostalCode" TEXT(41),<br />"JobStatus" TEXT(10),<br />"JobStartDate" DATETIME,<br />"JobProjectedEndDate" DATETIME,<br />"JobEndDate" DATETIME,<br />"JobDesc" TEXT(99),<br />"JobTypeRefListID" TEXT(36),<br />"JobTypeRefFullName" TEXT(159),<br />"Notes" MEMO,<br />"PreferredDeliveryMethod" TEXT(10),<br />"IsUsingCustomerTaxCode" YESNO,<br />"PriceLevelRefListID" TEXT(36),<br />"PriceLevelRefFullName" TEXT(31),<br />"ExternalGUID" TEXT(40),<br />"TaxRegistrationNumber" TEXT(30),<br />"CurrencyRefListID" TEXT(36),<br />"CurrencyRefFullName" TEXT(64),<br />"CustomFieldAccountNumber" TEXT(30),<br />"CustomFieldCollectionPlanDetails" TEXT(30),<br />"CustomFieldCollectionsPlan" TEXT(30),<br />"CustomFieldDepartment" TEXT(30),<br />"CustomFieldPACTS" TEXT(30),<br />"CustomFieldSupervisionType" TEXT(30),<br />"ListID" TEXT(36) NOT NULL,<br />"TimeCreated" DATETIME,<br />"TimeModified" DATETIME,<br />"EditSequence" TEXT(16) NOT NULL<br />)<br />Exception classes: <br />System.Data.Odbc.OdbcException<br />Exception messages: <br />Message: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'QXLCustomer.' It is in a read-only database. Source:odbcjt32.dll<br />Stack Traces:<br />At System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)<br />At System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean need reader, Object[] method arguments, SQL_API odbcApiMethod)<br />at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean feedreader)<br />at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solutions:</span></span></h3>
<ul>
<li>Please make sure your MS Access database is not read-only.</li>
<li>Please open the MS Access&nbsp;database file and try to remove the table QXLCustomer manually.&nbsp;</li>
<li>Try changing the path of your MS Access file.<br />Move your file from C:\Users\YourName\Documents\QXL\<br />to<br />C:\MyQuickBooks Data\<br />Change the path of your MS Access file in your DSN.</li>
<li>Try changing from an .mdb database to a .accdb&nbsp;</li>
<li>Try changing the DSN from a user DSN to a system&nbsp;DSN</li>
</ul>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to Sybase]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3011]]></link>
<guid isPermaLink="false"><![CDATA[b1f62fa99de9f27a048344d55c5ef7a6]]></guid>
<pubDate><![CDATA[Fri, 11 May 2018 13:32:35 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export to Sybase 
Problem Description:
You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export to Sybase </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. I am using QXL &amp; I want to export QuickBooks Data to Sybase.</p>
<p>How can I export QuickBooks Data to Sybase using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>&nbsp;</p>
<p>First, you need to create a database in Sybase for storing QuickBooks Data. You need to use Interactive SQL &amp; execute the following query to create the database.</p>
<p>create database dbname on default ="1G"</p>
<p>For Example:</p>
<p>create database QXL on default ="1G"</p>
<p>Note: default ="1G" will set the database size to 1GB. You need to create a bigger database if your company file contains more data.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step14.png" alt="" /></p>
<p>The database is created in Sybase.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step15.png" alt="" /></p>
<p>By default, the Sybase database does not allow null values in database fields.</p>
<p>There is a field value that could be null during export. So, we need to change this property. We can modify it by using the following query.</p>
<p>sp_dboption &lt;database_name&gt;,<br />"allow nulls by default," true</p>
<p>For Example:</p>
<p>sp_dboption QXL,<br />"allow nulls by default," true.</p>
<p>Note: You need to execute the above query in the Master database.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step16.png" alt="" /></p>
<p>The query is executed. Now, you are ready to export QuickBooks data to Sybase.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step17.png" alt="" /></p>
<p>After that, you need to create an ODBC DSN for Sybase, which will point to the Sybase Database.</p>
<p>I have already created an ODBC DSN for Sybase below the properties of the DSN. We will test the connection of Sybase DSN by providing Sybase database information &amp; clicking the "Test" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step11.png" alt="" /></p>
<p>Sybase ODBC DSN test connection successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step12.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step13.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "Sybase" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name;Port=PortNo;Database=DBName;User Id=Uid;Pwd=pwd;</p>
<p><strong>For Example:</strong> DSN=QXL_SYBASE;Port=5000;Database=QXL;User Id=sa;Pwd=css@123#;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step8.png" alt="" /></p>
<p>Now the data is ready to export into Sybase. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to Sybase. You can verify it using the query below.</p>
<p>Select * from sysobjects where type="U"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Sybase/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to PostgreSQL]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3010]]></link>
<guid isPermaLink="false"><![CDATA[22722a343513ed45f14905eb07621686]]></guid>
<pubDate><![CDATA[Fri, 11 May 2018 13:20:37 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export to PostgreSQL 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to PostgreSQL.
How can I export QuickBooks Data to PostgreSQL using QXL?
Solution:
You can export QuickBooks Data to PostgreSQL using QXL.
First...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export to PostgreSQL </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to PostgreSQL.</p>
<p>How can I export QuickBooks Data to PostgreSQL using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to PostgreSQL using QXL.</p>
<p>First, you need to create an ODBC DSN for PostgreSQL, which will point to the PostgreSQL Database.</p>
<p>I have already created an ODBC DSN for PostgreSQL below the properties of the DSN. We will test the connection of PostgreSQL DSN by providing PostgreSQL database information &amp; clicking the "Test" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step11.png" alt="" /></p>
<p>PostgreSQL ODBC DSN test connection successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step12.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "PostgreSQL" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=QXL_PostgreSQL</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step8.png" alt="" /></p>
<p>Now the data is ready to export into PostgreSQL. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to PostgreSQL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/PostgreSQL/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to Oracle]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3009]]></link>
<guid isPermaLink="false"><![CDATA[ee16fa83c0f151ef85e617f5aa3867a6]]></guid>
<pubDate><![CDATA[Fri, 11 May 2018 12:59:10 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export to Oracle 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to Oracle.
How can I export QuickBooks Data to Oracle using QXL?
Solution:
You can export QuickBooks Data to Oracle using QXL.
First, you need to cr...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export to Oracle </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to Oracle.</p>
<p>How can I export QuickBooks Data to Oracle using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to Oracle using QXL.</p>
<p>First, you need to create an ODBC DSN for Oracle, which will point to the Oracle Database.</p>
<p>I have already created an ODBC DSN for Oracle below the properties of the DSN. We will test the connection of the Oracle DSN by clicking the "Test Connection" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step11.png" alt="" /></p>
<p>Oracle ODBC DSN test connection successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step12.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step13.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "Oracle Database" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name;User Id=UID;Pwd=Password;</p>
<p><strong>For Example:</strong> DSN=QXL_ORACLE;User Id=scott;Pwd=tiger;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step8.png" alt="" /></p>
<p>Now the data is ready to export into Oracle. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to Oracle.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/Oracle/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to MariaDB]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3008]]></link>
<guid isPermaLink="false"><![CDATA[c02f9de3c2f3040751818aacc7f60b74]]></guid>
<pubDate><![CDATA[Fri, 11 May 2018 12:44:02 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export to MariaDB 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to MariaDB.
How can I export QuickBooks Data to MariaDB using QXL?
Solution:
You can export QuickBooks Data to MariaDB using QXL.
First, you need t...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export to MariaDB </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to MariaDB.</p>
<p>How can I export QuickBooks Data to MariaDB using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to MariaDB using QXL.</p>
<p>First, you need to create an ODBC DSN for MariaDB, which will point to the MariaDB Database.</p>
<p>I have already created an ODBC DSN for MariaDB below the properties of the DSN.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step11.png" alt="" /></p>
<p>We will test the connection of MariaDB DSN by clicking the "Test DSN" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step12.png" alt="" /></p>
<p>MariaDB ODBC DSN test connection successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step13.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "MariaDB" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=QXL_MariaDB</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step8.png" alt="" /></p>
<p>Now the data is ready to export into MariaDB. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to MariaDB.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/MariaDB/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to DB2]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3007]]></link>
<guid isPermaLink="false"><![CDATA[a724b9124acc7b5058ed75a31a9c2919]]></guid>
<pubDate><![CDATA[Fri, 11 May 2018 12:10:25 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export to DB2 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to DB2.
How can I export QuickBooks Data to DB2 using QXL?
Solution:
You can export QuickBooks Data to DB2 using QXL.
First, you need to create an ODBC...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export to DB2 </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to DB2.</p>
<p>How can I export QuickBooks Data to DB2 using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to DB2 using QXL.</p>
<p>First, you need to create an ODBC DSN for DB2, which will point to the DB2 Database.</p>
<p>I have already created an ODBC DSN for DB2 below the properties of the DSN.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step11.png" alt="" /></p>
<p>We will test the connection of DB2 DSN by providing DB2 by clicking the "Connect" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step12.png" alt="" /></p>
<p>DB2 ODBC DSN test connection is successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step13.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "IBM DB2" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=QXL_DB2</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step8.png" alt="" /></p>
<p>Now the data is ready to export into DB2. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to the DB2.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/IBMDB2/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Online] How to run ProfitAndLossByClass report using QXL Online]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3005]]></link>
<guid isPermaLink="false"><![CDATA[3a61ed715ee66c48bacf237fa7bb5289]]></guid>
<pubDate><![CDATA[Thu, 12 Apr 2018 10:17:04 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to run ProfitAndLossByClass report using QXL Online 
Problem Description:
I am using QXL Online &amp; I want to run a Profit and Loss by a Class report through QXL Online. I can't see the report on the list.
How can I run the Profit and Loss by Cl...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to run ProfitAndLossByClass report using QXL Online </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL Online &amp; I want to run a Profit and Loss by a Class report through QXL Online. I can't see the report on the list.</p>
<p>How can I run the Profit and Loss by Class report using QXL Online?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>I'm sorry to inform you that the ProfitAndLossByClass report is unavailable via Intuit API. So It is not available in QODBC Online.</p>
<p>You can use the ProfitAndLossStandard report &amp; add the parameter SummarizeColumnsBy = 'Classes' in the report. So you can fetch the ProfitAndLossByClass report using QXL Online.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL Online options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step1.png" alt="" /></p>
<p>You can choose the ProfitAndLossStandard report from the drop-down list &amp; add the report for export.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step2.png" alt="" /></p>
<p>You can see the default report query in Report Query/Command box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step3.png" alt="" /></p>
<p>You can modify the report query from Report Query/Command box.</p>
<p>You can refer <a href="http://doc.qodbc.com/qodbc/online/index.php" target="_blank">QODBC Table/Report Documentation</a> site for details about different report parameters.</p>
<p>Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"ProfitAndLossStandard"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the ProfitAndLossStandard report.</p>
<p>You can refer direct link for <a href="http://doc.qodbc.com/qodbc/online/ReportParameter.php?tableName=ProfitAndLossStandard" target="_blank">ReportParameter: ProfitAndLossStandard</a></p>
<p>You can use any of the supported parameters in the report query.</p>
<p>&nbsp;</p>
<p>I am changing the report query as below:</p>
<p>For Example: sp_report <span style="color: #990000;">ProfitAndLossStandard</span> RowData, TextLable, Amount_Title, Amount <span style="color: #0000ff;">parameters DateMacro = 'ThisYearToDate', ReportBasis='Cash', SummarizeColumnsBy = 'Classes' </span></p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step4.png" alt="" /></p>
<p>The modified report query &amp; was added to the export list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step5.png" alt="" /></p>
<p>By repeating the above process, You can add a different report with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step6.png" alt="" /></p>
<p>Report exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOPLC/step7.png" alt="" /></p>
<p align="center">Tags: QuickBooks Online, QBO,&nbsp;QXL Online, Profit and Loss, Profit, Loss, Online Report</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to run ProfitAndLossByClass report - with different parameters]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3004]]></link>
<guid isPermaLink="false"><![CDATA[20479c788fb27378c2c99eadcf207e7f]]></guid>
<pubDate><![CDATA[Thu, 12 Apr 2018 10:12:54 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to run ProfitAndLossByClass report - with different parameters 
Problem Description:
I am using QXL &amp; I want to run a Profit and Loss by Class report through QXL. I can see the report in the list. But I want to change the report parameter.
How...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to run ProfitAndLossByClass report - with different parameters </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to run a Profit and Loss by Class report through QXL. I can see the report in the list. But I want to change the report parameter.</p>
<p>How can I change the report parameter &amp; run the updated report?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can change the report parameter from the QXL Report Settings tab.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step1.png" alt="" /></p>
<p>You can choose the ProfitAndLossByClass report from the drop-down list &amp; add the report for export.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLC/step1.png" alt="" /></p>
<p>You can see the default report query in the Report Query/Command box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLC/step2.png" alt="" /></p>
<p>You can modify the report query from the Report Query/Command box.</p>
<p>You can refer to the&nbsp;<a href="http://qodbc.com/schema.htm" target="_blank">QODBC Data Layouts</a> site for details about different report parameters.</p>
<p>Navigate to the above link &amp; click on the region of the QuickBooks edition you are using.</p>
<p>You will be redirected to the QuickBooks region link. Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"ProfitAndLossByClass"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the ProfitAndLossByClass report.</p>
<p>If you are a&nbsp;<strong>QuickBooks USA</strong> user, then you can refer to the direct link for <a href="http://doc.qodbc.com/qodbc/usa/ReportParameter.php?tableName=ProfitAndLossByClass" target="_blank">PARAMETERS AND VALUES FOR: ProfitAndLossByClass</a>.</p>
<p>You can use any of the supported parameters in the report query.</p>
<p>I am changing the report query by adjusting the DateMacro parameter value to 'ThisMonthToDate.'</p>
<p>For Example: sp_report <span style="color: #990000;">ProfitAndLossByClass</span> show Amount_Title, Text, Label, Amount <span style="color: #0000ff;">parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'Class' </span></p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLC/step3.png" alt="" /></p>
<p>The modified report query &amp; was added to the export list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLC/step4.png" alt="" /></p>
<p>By repeating the above process, you can add different reports with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step7.png" alt="" /></p>
<p>Report exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLC/step5.png" alt="" /></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to build shortcuts to export multiple QuickBooks company files using QXL with one click (Video)]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2959]]></link>
<guid isPermaLink="false"><![CDATA[779efbd24d5a7e37ce8dc93e7c04d572]]></guid>
<pubDate><![CDATA[Mon, 16 Oct 2017 14:40:21 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to build shortcuts to export multiple QuickBooks company files using QXL with one click (Video)
Problem Description:
How to build shortcuts to export multiple QuickBooks company files using QXL with one click?
Solution:
Please refer to the steps &...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to build shortcuts to export multiple QuickBooks company files using QXL with one click (Video)</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>How to build shortcuts to export multiple QuickBooks company files using QXL with one click?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>Please refer to the steps &amp; video for building shortcuts to export multiple QuickBooks company files using QXL with one click.</p>
<p><iframe src="https://www.youtube.com/embed/ep_ge_222o4" width="750" height="425" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p>
<p>Requires - QXL v17.0.0.023 or Above. <a href="http://qxl1.com/qxl-for-quickbooks-desktop-downloads/" target="_blank">Click here</a> to download the latest version of QXL Desktop.</p>
<p>&nbsp;</p>
<p>1. Start QuickBooks &amp; load your company file &amp; log in to your company file as an Admin.</p>
<p>2. Start QXL using the QXL shortcut placed on your desktop &amp; click the "Export" button.</p>
<p>3. QuickBooks will prompt for authorizing QXL to connect with QuickBooks. Please accept the certificates.</p>
<p>4. After accepting the certificate, QXL will export your company file data.</p>
<p>5. Close QXL after the export is completed.</p>
<p>6. Create a QXL Parameter file from a default parameter file. When you install QXL, at that time, the sample parameter file is installed in the "C:\Users\Your User Name\Documents\QXL\" folder. Copy the default parameter file &amp; paste it into the same folder &amp; rename the pasted parameter file with your company file name.</p>
<p>7. Open the renamed parameter file &amp; use the "CompanyFilePath" parameter from the file &amp; provide your company file path in the parameter file. In this tutorial, we have used the export mode "Direct." You can change the export mode as per your requirement. You can add/update other parameters in a text file as per your requirement &amp; save the parameter file. You can refer to&nbsp;<a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938" target="_blank">QXL Command line arguments/parameters</a> for more details about QXL Parameters.</p>
<p>8. Make a copy of the QXL shortcut &amp; rename it with your company file name.</p>
<p>9. Copy the file path of your parameter file &amp; add it to your QXL shortcut file. Right-click on the QXL shortcut file, click "Properties," &amp; add the parameter file path in the double quotation marks after QXL.exe in the target box &amp; apply the shortcut changes by clicking the "Apply" &amp; "OK" buttons.</p>
<p>10. Double-click the QXL shortcut to export company file data automatically.</p>
<p>11. Similarly, you can create a QXL shortcut for your other company files.</p>
<p>Also, refer to the following:</p>
<p><a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2939" target="_blank">How to use QXL with the scheduler for multiple company files</a></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to use QXL with the scheduler for multiple company files]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2939]]></link>
<guid isPermaLink="false"><![CDATA[6c990b7aca7bc7058f5e98ea909e924b]]></guid>
<pubDate><![CDATA[Wed, 05 Jul 2017 12:56:34 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to use QXL with the scheduler for multiple company files
Problem Description:
I want to export QuickBooks Data&nbsp;for multiple company files using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will automatically export QuickBoo...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to use QXL with the scheduler for multiple company files</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I want to export QuickBooks Data&nbsp;for multiple company files using QXL.</p>
<p>I want to schedule QXL for exporting QuickBooks Data. So it will automatically export QuickBooks Data for multiple company files on a scheduled time.</p>
<p>But I don't know how I can use QXL with the Scheduler for multiple company files.</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can use the QXL Parameter file for exporting QuickBooks data from multiple company files.</p>
<p>When you install QXL, at that time, the sample parameter file is installed in the "C:\Users\Your User Name\Documents\QXL\" folder.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step1.png" alt="" /></p>
<p>Sample parameter file opened. You can use the "CompanyFilePath" parameter &amp; can provide your company file path in the parameter file.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step2.png" alt="" /></p>
<p>You can copy this file &amp; rename it as "My Company.txt," e.g., "Company A.tx."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step3.png" alt="" /></p>
<p>After copying the parameter file, you can provide your company file path using the "CompanyFilePath" parameter. Also, you can add/update other parameters in a text file as per your requirement. Refer to&nbsp;<a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938">QXL Command line arguments/parameters</a> for more details about QXL Parameters. Similarly, another way you can create a separate parameter file for other company file(s).</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step5.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step6.png" alt="" /></p>
<p>You can use the above Parameter file in your scheduled application to export QuickBooks Data using QXL.</p>
<h4><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Use Scheduler:</span></span></h4>
<p>You can use any desktop-based scheduler (for example, "Z-Cron"). QuickBooks and&nbsp; QuickBooks SDK are desktop-based and not designed to run as a service. QODBC &amp; QXL are also desktop-based applications. Thus, you will need an active desktop session(someone logged into the machine). You may not be able to use the service-based scheduler like "Task Schedule." In this example, we use Z-Cro,n, but you can use any other desktop-based&nbsp;scheduler.</p>
<p>You can download Z-Cron from the link below:</p>
<p><a href="http://www.z-cron.com/download.html">Download Z-Cron</a></p>
<p>After downloading Z-Cron, please install it on your machine.</p>
<p>After Installation, please start Z-Cron and add a task by clicking the "Task" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step8.png" alt="" /></p>
<p>Enter Task Title in the Label box &amp; enable the "Activate Task" option to activate the scheduled task, and choose Program by clicking the ".." button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step9.png" alt="" /></p>
<p>Select QXL.exe from the QXL installation folder; click "OPEN."</p>
<p>QXL Default installation path:</p>
<p>For 32-bit OS: "C:\Program Files\FLEXquarters.com Limited\QXL for QuickBooks"</p>
<p>For 64-bit OS: "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step10.png" alt="" /></p>
<p>After selecting QXL.ex,e insert the parameter file path in the "Parameter:" box.</p>
<p><strong>Note:</strong> You need to provide the ide parameter file path in the quotes below <br />For Example: "C:\Users\Raj\Documents\QXL\Company A.txt"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step11.png" alt="" /></p>
<p>Now navigate to the "Scheduler" tab to schedule the export. In this example, I prepare the export twice daily (i.e., 8:00 AM &amp; 5:00 PM).</p>
<p>Click on the "Every day" button to select all weekdays &amp; click on "Scheduler" to configure scheduled time, select extra time &amp; click on "Save."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step14.png" alt="" /></p>
<p>Now save the scheduled job by clicking on "Save.".</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step15.png" alt="" /></p>
<p>The scheduled task is ready for execution. It will be run on schedule time. The scheduled job is as ved.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step17.png" alt="" /></p>
<p>Now we will create a new task for the anthe the other company file. We can complete a new task by clicking on the "Task" button from Z-Cron.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step30.png" alt="" /></p>
<p>Z-Cron is open to the existing task. To create a new task, click the "Create new CronJob" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step25.png" alt="" /></p>
<p>Enter Task Title in the Label box &amp; enable the "Activate Task" option to activate the scheduled task, and choose Program by clicking the ".." button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step18.png" alt="" /></p>
<p>Select QXL.exe from the QXL installation folder; click "."IN".</p>
<p>QXL Default installation path:</p>
<p>For 32-bit OS: "C:\Program Files\FLEXquarters.com Limited\QXL for QuickBooks"</p>
<p>For 64-bit OS: "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step10.png" alt="" /></p>
<p>After selecting QXL.exe, insert the parameter file path in the "Parameter:" box.</p>
<p><strong>Note:</strong> You need to provide the ide parameter file path in the quotes below <br />For Example: "C:\Users\Raj\Documents\QXL\Company B.txt"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step19.png" alt="" /></p>
<p>Now navigate to the "Scheduler" tab to schedule the export. In this example, I prepare the export twice daily (i.e., 9:00 AM &amp; 6:00 PM).</p>
<p>There should be a time gap between the export schedules of two or more company filThe timelines. The ntimtimtimtimtime gap depends on the export time of your QuickBooks company file data. Note: You can run only instances of QXL this time. So don't schedule to export two more company files simultaneously at the same time.</p>
<p>Click on the "Every day" button to select all weekdays &amp; click on "Scheduler" to configure schedule timing.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step20.png" alt="" /></p>
<p>Select a time &amp; click on "."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step21.png" alt="" /></p>
<p>Now save the scheduled job by clicking on "Save."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step22.png" alt="" /></p>
<p>The scheduled job is safely scheduled used task is ready for execution. It will be run on schedule time.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step24.png" alt="" /></p>
<p>You can create a batch file &amp; can insert ds-commands commands-commands commands for exporting QuickBooks data for multiple company files. So it will export data from various company files one by one.</p>
<p>To create a batch of the file, you need to open "Notepad" &amp; write the below command.</p>
<p>cd "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"</p>
<p>QXL.exe "C:\Users\Raj\Documents\QXL\Company A.txt"</p>
<p>QXL.exe "C:\Users\Raj\Documents\QXL\Company B.txt"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step26.png" alt="" /></p>
<p>Save your file by heading to ", "le," "Save As."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step27.png" alt="" /></p>
<p>Select "All Files (*.*)" as "Save as type:" and enter the name of the file that you'd like &amp; click on. "ve."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step28.png" alt="" /></p>
<p>The batch file is created.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step29.png" alt="" /></p>
<p>You can schedule a batch file using the scheduler. It will be run on schedule time. For scheduling the bafiles file, you can refer to the above steps. Just one step change, the path of the batch file, the rest of the steps are the same as above.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMCSCH/step31.png" alt="" /></p>
<p>&nbsp;</p>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Example of Command line arguments/parameters for QXL Desktop</span></h2>
<p><span style="font-family: Arial, Helvetica, sans-serif;">You can run QXL through the ugh command prompt &amp; can set parameters. </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><br />You can open the command prompt by searching "cmd" in the from-start menu &amp; can open the command prompt by clicking on the&nbsp; "Command Prompt" icon. <br /> </span></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step1.png" alt="" /></p>
<p><br />The Command Prompt has opened. Navigate to the "QXL for QuickBooks" folder by typing the command below. <br />cd C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step2.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step3.png" alt="" /></p>
<p>Execute the command line argument by using the sample below. You can add/remove/chase no par value per your requirement.<br />QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ExportType="XLSX" -ExportIn="True" -CompanyFilePath="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 13.0\sample_product-based business.qbw" -UseOptimizer="False" -CreateTableForExcel="True" -ExcelHeaderColor="808080" -ExcelTableStyles="Dark4" -DefaultODBCConnectionName="0" -TableSelection="1" -TablesToExport="Entity,Company,Class"</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step4.png" alt="" /></p>
<p><br />QXL will start exporting data as per the provided parameters.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step5.png" alt="" /></p>
<p><br />After the exporting data is complete, the QXL application will close automatically.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step6.png" alt="" /></p>
<p><br />You can configure different configurations &amp; can theme them through the ugh "ConfigFile" parameter. You need to provide the path of your QXL config file as below. <br />QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ConfigFile="C:\My Folder\Exported Data\Rock Castle Construction\config.xml"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step10.png" alt="" /></p>
<p><br />QXL will start exporting data as per the provided parameters.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step5.png" alt="" /></p>
<p><br />After the exporting data is completed, the QXL application will close automatically.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step11.png" alt="" /></p>
<p><strong>Note:&nbsp;</strong>The command prompt supports up to 8191 characters as a command line argument. So you cannot use more than 8191 characters as a command-line argument. You can use a parameter file if the command line argument exceeds 8191 characters. Refer to&nbsp;<a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938">QXL Command line arguments/parameters</a>&nbsp;for more details about QXL Parameters.</p>
<p>&nbsp;</p>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Example of Command-line arguments/parameters for QXL Online</span></h2>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><br />You can run QXL through the ugh command prompt &amp; can set parameters. <br />You can open the command prompt by searching "cmd" in the from start menu &amp; can open the command prompt by clicking on the "Command Prompt" icon.</span></p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step1.png" alt="" /></p>
<p><br />The Command Prompt has opened. Navigate to the "QXL for QuickBooks Online" folder by typing the command below. <br />cd C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks Online</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step12.png" alt="" /></p>
<p>Execute the command line argument by using the sample below. You can add/remove/chase no par value per your requirement.<br />QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ExportType="XLSX" -ExportIn="True" -UseOptimizer="True" -OptimizerFilePath="%AppData%\QXL - QuickBooks Online Data Export Made Easy\Optimizer\ABC" -CreateTableForExcel="True" -ExcelHeaderColor="808080" -ExcelTableStyles="Dark4" -DefaultODBCConnectionName="0" -QBODefaultConnectionName="1" -TableSelection="1" -TablesToExport="Customer,Company,Class"</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step13.png" alt="" /></p>
<p>QXL will start exporting data as per the provided parameters.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step15.png" alt="" /></p>
<p><br />After the exporting data is complete, the QXL application will close automatically.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step14.png" alt="" /></p>
<p><br />You can configure different configurations &amp; can theme them through the ugh "ConfigFile" parameter. You need to provide the path of your QXL config file as below. <br />QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ConfigFile="C:\My Folder\Exported Data\Rock Castle Construction\config.xml"</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step16.png" alt="" /></p>
<p><br />QXL will start exporting data as per the provided parameters.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step15.png" alt="" /></p>
<p><br />After the exporting data is completed, the QXL application will close automatically.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step17.png" alt="" /></p>
<p>&nbsp;</p>
<p>Also, refer to&nbsp;<a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938">QXL Command line arguments/parameters.ters</a></p>
<p>T ags: Command line arguments, DOS, parameters</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] QXL shortcut commands and parameters]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938]]></link>
<guid isPermaLink="false"><![CDATA[42853a61b26fef79e2ae788d97356799]]></guid>
<pubDate><![CDATA[Tue, 04 Jul 2017 11:53:29 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[General QXL &nbsp;shortcut commands and parameters&nbsp;
Parameters available in the QXL
 Run = The parameter is used for running QXL in the foreground (i.e., QXL will be visible during execution).
example:&nbsp;QXL.EXE&nbsp;Run
 Silent = The paramete...]]></description>
<content:encoded><![CDATA[<h2><span id="QXLParameters" style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #6633cc;">General QXL &nbsp;shortcut commands and parameters&nbsp;</span></span></h2>
<h3><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #0066cc;">Parameters available in the QXL</span></span></h3>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">Run</span> = The parameter is used for running QXL in the foreground (i.e., QXL will be visible during execution).</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">example:&nbsp;</span>QXL.EXE&nbsp;Run</p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">Silent</span> = The parameter is used for running QXL in the background (i.e., QXL will not be visible during execution).</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">example:&nbsp;QXL.EXE&nbsp;Silent</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">DefaultPath</span> = The parameter is used for setting up the export folder path where the output will be placed.<br /> <strong>Note:</strong>&nbsp;Folder path should not end with the backslash ("\").</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">example:&nbsp;QXL.EXE&nbsp;Silent&nbsp;DefaultPath="C:\My Folder\QXL Output Folder"</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ExportType</span> = The parameter is used to set up the format of exported files to XLSX, XLS, CSV, SQL, or ODBC.</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">example:&nbsp;QXL.EXE&nbsp;Silent&nbsp;DefaultPath="C:\My Folder\QXL Output Folder"&nbsp;ExportType="CSV"</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"> <img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ExportIn</span>&nbsp;= The parameter is used for setting up the exported file in Separate Files or single files - values True/False. </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">UseOptimizer</span> = The parameter is used to enable or disable Optimizer - values True/False.</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">OptimizerFilePath</span> = The parameter is used to change the Optimizer File location. If you want to store the Optimizer file at a different location, then you can provide the file path where the Optimizer file will be created. - e.g., "C:\QXL\Optimizer"<br /> <strong>Note:</strong>&nbsp;Folder path should not end with a backslash ("\") </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">CreateTableForExcel</span> = The parameter is used for creating a table from the sheet (for Excel 2010 or above in [xlsx] format only.) - values True/False </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ExcelHeaderColor</span> = The parameter is used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only.)- values Hex color codes without # - e.g., 808080 <br />Refer to&nbsp;<a href="http://htmlcolorcodes.com" target="_blank">HTML Color Codes</a> for more details about the color code. </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ExcelTableStyles</span> = The parameter is used for formatting Excel cells by choosing predefined styles (for Excel 2010 or above in [xlsx] format only) - values <br />Dark1<br />Dark2<br />..<br />Dark10<br />Light1<br />Light2<br />...<br />Light21<br />Medium1<br />Medium2<br />...<br />Medium28</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">TableSelection</span> = The parameter is used for selecting a table from different options (i.e., ALL/Selected Table/Excluding Selected Table). - Value 0=All, 1=Selected tables specified in TablesToExport, 2=other then the tables specified in TablesToExport </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">TablesToExport</span> = The parameter specifies which table you want to export. values ="Table1,Table2" example -TablesToExport="Vendor,Company,Class" <br /><strong>Note:</strong> You need to use "TableSelection" when you specify a table using the "TablesToExport" parameter. If you don't use "TableSelection," QXL will ignore the "TablesToExport" parameter value &amp; export according to the config file setup.</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">DefaultODBCConnectionName</span>&nbsp;= The parameter is used for defining which ODBC Connection to be used (value is the index of the ODBC connection list) value = 0, 1, or 2 <br />For example, you have created four connections, as shown in the image below. The connection name "SQL" will be used as "Value = 0", in the same way, connection name "MSA" will be used as "Value = 1, &amp; connection name "MYSQL" will be used as "Value = 2".</span></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step8.png" alt="" /></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ConfigFile</span>&nbsp;= The parameter is used for specifying which config file to use. - e.g. "C:\Users\Dewani\config.xml" </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">ReportQueries</span> = The parameter is used to export specific report(s). - <br />e.g. <code>ReportQueries= "&lt;ReportQueries&gt;&lt;ReportQuery0&gt;&lt;Name value="GeneralLedger" /&gt;&lt;Value value="sp_report GeneralLedger show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Blank, TxnType, Date, RefNumber, Name, Memo, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate'" /&gt; &lt;/ReportQuery0&gt;&lt;/ReportQueries&gt;"</code> </span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">CustomQueries</span> = The parameter is used for fetching specific table data through your custom query according to your requirement.<br />e.g. <code>CustomQueries= "&lt;CustomQueries&gt;&lt;CustomQuery0&gt;&lt;Name value="Txn June" /&gt;&lt;Value value="Select * from Transaction where TxnDate &gt;= {d'2017-06-01'} and TxnDate &lt;= {d'2017-06-30'}" /&gt;&lt;/CustomQuery0&gt;&lt;/CustomQueries&gt;"</code> </span></p>
<p><strong>Note:</strong>&nbsp;The value of ReportQueries &amp; CustomQueries should not contain any line feed.</p>
<p>&nbsp;</p>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">SetExportFilesReadOnly</span> = The parameter is used for protecting exported files from unwanted writes. This option will only set exported files to read if you set the value to "True." - values True/False. </span></p>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Additional Parameters for QuickBooks Desktop Edition </span></h2>
<p><span style="font-family: Arial, Helvetica, sans-serif;"> <img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">CompanyFilePath</span>&nbsp;= The parameter is used for setting up the QuickBooks company file path in QXL, OR You can use it. (dot) to indicate the currently open company file. QXL will use the company file specified in the config file if you don't set the company file path. <br />e.g. CompanyFilePath="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 13.0\sample_product-based business.qbw"</span></p>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Additional Parameters for QuickBooks Online Edition </span></h2>
<p><span style="font-family: Arial, Helvetica, sans-serif;"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/bullet1.gif" alt="bullet" width="7" height="7" /> <span style="color: #0000cc;">QBODefaultConnectionName</span> = The parameter is used for defining which QuickBooks Online Company Connection to be used (value is the index of the QuickBooks Online connection list) value = 0, 1, or 2 <br />For Example, If you have created three connections to QuickBooks Online company as in the below image, then the connection name "Sandbox USA" will be used as "Value = 0", Same way connection name "Sandbox CA" will be used as "Value = 1" &amp; connection name "Sandbox IN" will be used as "Value = 2".</span></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step9.png" alt="" /></p>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Export data using QXL Parameters</span></h2>
<p><span style="font-family: Arial, Helvetica, sans-serif;"> There are two ways to export QuickBooks/QuickBooks Online data using QXL Desktop/QXL Online.<br />1. Using Parameter file.<br />2. Provide parameters using command-line arguments.<br /> </span></p>
<h3><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">Example of using a parameters file with QXL</span></h3>
<p>When you install QXL, at that time, the sample parameter file is installed in the "C:\Users\Your User Name\Documents\QXL\" folder.</p>
<p>&nbsp;</p>
<p>QXL Desktop sample parameter file:</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step18.png" alt="" /></p>
<p>QXL Online sample parameter file:</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step23.png" alt="" /></p>
<p>Sample parameter file opened.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step19.png" alt="" /></p>
<p>You can copy this file &amp; rename it as "My Company.txt," e.g., "ABC Company.txt."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step22.png" alt="" /></p>
<p>You can write the parameters in a text file &amp; use a Parameter file with QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step20.png" alt="" /></p>
<p>The first step in the configuration is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step1.png" alt="" /></p>
<p><br />In the General tab, you will find two buttons that will create the export shortcut on your desktop.</p>
<p>1. QXL - Silent Mode, which will export data in silent mode (does not display the QXL Window).</p>
<p>2. QXL - Direct Export Mode will export data in direct mode (display QXL Window).</p>
<p>In this example, I use the first option (i.e., QXL - Silent Mode).</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step25.png" alt="" /></p>
<p>By clicking on the "Create a shortcut on desktop" button, you will get the below pop-up message &amp; clicking "OK" will create the shortcut on the desktop.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step26.png" alt="" /></p>
<p>The shortcut is created on the desktop.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step27.png" alt="" /></p>
<p>Now, we will modify the shortcut by right-clicking on the shortcut &amp; click "Properties."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step28.png" alt="" /></p>
<p>The shortcut property window is open. Navigate to the "ShortCut" tab &amp; add the below text in the "Target" box &amp; save the configuration by clicking "OK."</p>
<p>"C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks\QXL.exe" "C:\Users\Raj\Documents\QXL\ABC Company.txt"</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step29.png" alt="" /></p>
<p>The shortcut is saved on the desktop. You can run it by double-clicking the shortcut.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step30.png" alt="" /></p>
<p>You can use the above shortcut in your scheduled application to export QuickBooks Data using QXL.</p>
<p>QXL will start exporting data as per the provided parameters.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLParam/step5.png" alt="" /></p>
<p><br />After the exporting data is completed, the QXL application will close automatically.</p>
<p><strong>Note:&nbsp;</strong>The shortcut supports up to 260 characters in the "Target" box, in which the QXL path took 76 characters. So you can use the shortcut when the command line arguments are limited to under 260 characters.&nbsp;So please ensure that your parameter file path &amp; QXL path character total do not exceed 260 characters. Please shorten the parameter file path if it exceeds&nbsp;260 characters.</p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">Also Refer: <a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2939" target="_blank">How to use QXL with a scheduler for multiple company files</a>.</span></p>
<p>&nbsp;</p>
<p><span style="font-family: Arial, Helvetica, sans-serif;">Tags:&nbsp;Command line arguments, shortcuts, background, silent, parameters</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to run Balance sheet by class report - with different parameters]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2930]]></link>
<guid isPermaLink="false"><![CDATA[6624b6d8217cf71640993409df58204f]]></guid>
<pubDate><![CDATA[Tue, 06 Jun 2017 10:02:04 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to Balance Sheet by the class report - with different parameters 
Problem Description:
I am using QXL &amp; I want to balance the sheet with a class report through QXL. I can see the information on the list. But I want to change the report paramete...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to Balance Sheet by the class report - with different parameters </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to balance the sheet with a class report through QXL. I can see the information on the list. But I want to change the report parameter.</p>
<p>How can I change the report parameter &amp; run the updated report?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can change the report parameter from the QXL Report Settings tab.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step1.png" alt="" /></p>
<p>You can choose the BalanceSheetByClass report from the drop-down list &amp; add the report for export.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/step2.png" alt="" /></p>
<p>You can see the default report query in the Report Query/Command box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/step3.png" alt="" /></p>
<p>You can modify the report query from the Report Query/Command box.</p>
<p>You can refer to the&nbsp;<a href="http://qodbc.com/schema.htm" target="_blank">QODBC Data Layouts</a> site for details about different report parameters.</p>
<p>Navigate to the above link &amp; click on the region of the QuickBooks edition you are using.</p>
<p>You will be redirected to the QuickBooks region link. Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"BalanceSheetByClass"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the BalanceSheetByClass report.</p>
<p>If you are a&nbsp;<strong>QuickBooks USA</strong> user, then you can refer to the direct link for <a href="http://doc.qodbc.com/qodbc/usa/ReportParameter.php?tableName=BalanceSheetByClass" target="_blank">PARAMETERS AND VALUES FOR: BalanceSheetByClass</a>.</p>
<p>You can use any of the supported parameters in the report query.</p>
<p>I am changing the report query by adding the AccountFilterType parameter &amp; changing the date period by using the DateFrom &amp; DateTo parameters.</p>
<p>For Example: sp_report <span style="color: #990000;">BalanceSheetByClass</span> <span style="color: #0000ff;"> parameters DateFrom = {d'2021-01-15'}, DateTo= {d'2021-06-30'}, AccountFilterType='AccountsReceivable' </span></p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/step4.png" alt="" /></p>
<p>The modified report query &amp; was added to the export list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/step5.png" alt="" /></p>
<p>By repeating the above process, you can add a different report with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from the QXL Main Window.</p>
<p align="center"><img src="https://support.flexquarters.com/esupport/newimages/QXLPLD/step7.png" alt="" /></p>
<p>Report Exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLBS/step6.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] QXL Professional Edition options and settings - SQL]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2929]]></link>
<guid isPermaLink="false"><![CDATA[a36b0dcd1e6384abc0e1867860ad3ee3]]></guid>
<pubDate><![CDATA[Thu, 18 May 2017 06:40:16 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL&nbsp;Professional Edition options and settings -&nbsp;SQL
QXL&nbsp;Professional Edition options and settings / Configuration:
The first step in configuring the application is to click on the settings icon for QXL options details &amp; navigate to th...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">QXL&nbsp;Professional Edition options and settings -&nbsp;SQL</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL&nbsp;Professional Edition options and settings / Configuration:</span></h3>
<p>The first step in configuring the application is to click on the settings icon for QXL options details &amp; navigate to the Pro Edition tab.<br /><br /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPROCONF/step1.png" alt="" /></p>
<p><strong>Pro Edition Tab:</strong></p>
<p>You can export QuickBooks Data into SQL Server &amp; ODBC database using the Pro Edition Table. Please refer to the details for each option.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPROCONF/step2.png" alt="" /></p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">1. SQL / ODBC Connection:-</span></strong> You can see the list of added connections from the drop-down list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPROCONF/step3.png" alt="" /></p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">2. Add New:-</span></strong> You can add a new SQL / ODBC connection by clicking on the "Add New" button.</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">3. Connection Name:-</span></strong> You can insert any value for Connection Name. Using the Connection Name, you can recognize the SQL / ODBC connection that you want to configure.</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">4. Connection String:-</span></strong> You need to insert a valid connection string for connecting to the SQL / ODBC database. <br />Sample SQL Server Connection String Format: <strong>Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;</strong><br />Sample ODBC Connection String Format: <strong>DSN = Data Source Name</strong></p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">5. Connection Type:-</span></strong> You can choose the connection type using this option.<br />If you want to export data to the SQL Server database, select "SQL Server Driver" as a Connection Type.<br />If you want to export data to the ODBC database, select "ODBC Data Source" as a Connection Type.</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">6. TableName Prefix:-</span></strong> You can set the prefix before exporting tables. The default TableName Prefix is "QXL." So all exported table names will have the prefix "QXL" (i.e., QXLAccount, QXLCustomer, QXLInvoice, et.).</p>
<p><strong>Note:</strong> You should use a unique TableName Prefix, which is unavailable in your database. If you use TableName Prefix, which is already available in the destination database, then the destination table data will be replaced.</p>
<p>It would be best if you used a unique TableName Prefix, unavailable in your database. For Example, if you use TableName Prefix "TB" &amp; you already have a table in your database with Prefix "TB," the destination table data will be replaced with source data. To avoid this type of issue. It would be best if we use&nbsp;"QXL" as a prefix.</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">7. Mapping Type:-</span></strong> You can set the ODBC Mapping Type for a different database from the drop-down list. You can select the mapping type:</p>
<ul>
<li>Microsoft Access for MS Access database.</li>
<li>Microsoft SQL Server for SQL Server database.</li>
<li>MySQL Server for MySQL database.</li>
<li>Firebird Database for Firebird database.</li>
<li>Others/Custom Mapping for the rest of the ODBC Database.</li>
</ul>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPROCONF/step4.png" alt="" /></p>
<p><strong>Others/Custom Mapping:-</strong> You can set custom mapping for different data types as per your destination database. If your ODBC database supports a different data type instead of the type mentioned below, then you need to write the data type name in the textbox for the respective data type.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPROCONF/step5.png" alt="" /></p>
<p>&nbsp;</p>
<ul>
<li>Int16: It is a value type.&nbsp;It has&nbsp;a minimum capacity of -32768 and a Maximum capacity of +32767. It is signed and takes 16 bits.</li>
<li>Int32: It is a value type. It has a stored minimum capacity of -2147483648 and a Maximum capacity of +2147483647. It is signed and takes 32 bits.</li>
<li>Int64: It is a value type. It is signed and takes 64 bits. Its stored Minimum capacity is 9,223,372,036,854,775,808, and its Maximum capacity is +9,223,372,036,854,775,807.</li>
<li>Boolean: The Boolean type represents the values true and false. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Although only two values are possible, they are rarely implemented as a single binary digit for efficiency reasons.</li>
<li>Byte: A group of binary digits or bits (usually eight) operated on as a unit.</li>
<li>Decimal: A decimal number, or just decimal, refers to any number written in decimal notation, although it is more commonly used to refer to numbers that have a fractional part separated from the integer part with a decimal separator.</li>
<li>Double: Double-precision numbers store an approximation of an actual number. Double precision floating-point. It will handle most decimals.</li>
<li>DateTime: The DateTime type is used for values that contain both date and time parts.</li>
<li>String: A string is a sequence of characters, either as a literal constant or as a variable.</li>
<li>Memo: A Memo field can help store large amounts of alphanumeric information. The Memo data type allows up to 65,536 alphanumeric characters with options to set several properties, such as rich text formatting. Some typical uses for this data type would be a note, comments, description, or address field.</li>
<li>Keyword Escape Chars: It will be used to escape a character mentioned in the first textbox with a character mentioned in the second textbox.<br />For example, if you want to change <strong>`</strong> with,'&nbsp;then you need to write <strong>`</strong> in the first textbox &amp; <strong>'</strong> in the second textbox.</li>
<li>Field Name Limit: If your database supports a limited table/field name length, then you can set a limit from this textbox. <br />For Example, if you write 20 in the Field Name Limit text box, then all table &amp; field names are created within the 20-character limit.</li>
<li>Boolean Value: You can configure a Boolean value as either 1:0 or True: False.</li>
</ul>
<p>&nbsp;</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">8. Delete:-</span></strong> You can delete unwanted connections by clicking on the "Delete" button.</p>
<p><strong><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">9. Save:-</span></strong> You can save/update connection information by clicking on the "Save" button.</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to configure QXL to export to SQLite]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2928]]></link>
<guid isPermaLink="false"><![CDATA[9087b0efc7c7acd1ef7e153678809c77]]></guid>
<pubDate><![CDATA[Thu, 18 May 2017 06:16:47 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to configure QXL to export to&nbsp;SQLite
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to an ODBC Database.
How can I export QuickBooks Data to an ODBC Database using QXL?
Solution:
You can export QuickBooks Data to...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to configure QXL to export to&nbsp;SQLite</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to an ODBC Database.</p>
<p>How can I export QuickBooks Data to an ODBC Database using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to an ODBC Database using QXL.</p>
<p>In this example, we will show you how to export QuickBooks Data to SQLITE (ODBC Database) using QXL.</p>
<p>First, you need an ODBC connector to connect to the ODBC database.</p>
<p>You need to download &amp; install the ODBC connector on your system.</p>
<p>After installing the ODBC connector, you need to configure the ODBC DSN, which will point to the ODBC Database.</p>
<p>I have already created an ODBC DSN for SQLite. Below is the property of the DSN.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step11.png" alt="" /></p>
<p>We will use this DSN in QXL. We will use this DSN in QXL.</p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "Others/Custom Mapping" as a Mapping Type.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=SQLITE</p>
<p>You can configure data mapping as per your ODBC Database. You can choose different data types as per your ODBC Database.</p>
<p><strong>For&nbsp;</strong><span style="box-sizing: border-box; margin: 0px; padding: 0px;"><strong>example,</strong>&nbsp;if</span>&nbsp;your ODBC database supports smallint instead of Int16, then you need to write smallint in the text box of Int16. In the same way, you can change ODBC Mapping for different datatypes as per your ODBC Database.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step3.png" alt="" /></p>
<p>After changing the ODBC Mapping as per your ODBC Database, click the "Test Connection" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step12.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step8.png" alt="" /></p>
<p>Now the data is ready to export into an ODBC Database. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to the SQLITE (ODBC Database).</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLODBC/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export QuickBooks Data daily for current date filter using QXL.]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2927]]></link>
<guid isPermaLink="false"><![CDATA[2b64c2f19d868305aa8bbc2d72902cc5]]></guid>
<pubDate><![CDATA[Tue, 09 May 2017 09:27:14 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ How to export QuickBooks Data daily for the current date filter using QXL. 
Problem Description:
I am using QXL &amp; I want to create a report that will pull the following items.
Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to Cit...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> How to export QuickBooks Data daily for the current date filter using QXL. </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to create a report that will pull the following items.</p>
<p>Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to City, Ship to State, Ship to Zip, PO#, Item, Qty.</p>
<p>How to export QuickBooks Data daily for the current date filter using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data daily for your desired date using QXL.</p>
<p>The first step is to start QXL. Click the Options/Settings icon.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step1.png" alt="" /></p>
<p>Under the "General" tab, click "Comma Separated Value (CSV)."</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step2.png" alt="" /></p>
<p>To add a desired date filter, you need to create a custom query &amp; add it to the export list.</p>
<p>From the Custom Query Tab, you can write your custom query and fetch data according to your requirements.</p>
<p>You need to write the table name in the Custom Table Name box &amp; write the query in the Custom Query box. After writing the table name &amp; query, click on the "Add or Update" button to add the query.</p>
<p><strong>For Example:</strong></p>
<p>SELECT {fn CURDATE()} as DateRange, RefNumber as InvoiceNumber, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4, ShipAddressAddr5, ShipAddressCity, ShipAddressState, ShipAddressProvince, ShipAddressCounty, ShipAddressPostalCode, ShipAddressCountry, ShipAddressNote, PONumber As PO#, SalesOrderLineItemRefFullName, SalesOrderLineQuantity As QTY FROM SalesOrderLine where {fn CURDATE()} = TxnDate</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step3.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step4.png" alt="" /></p>
<p>If you wish to pull the last 7 days' data, you may use the query below.</p>
<p><strong>For Example:</strong></p>
<p>SELECT {fn CURDATE()} as DateRange, RefNumber as InvoiceNumber, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4, ShipAddressAddr5, ShipAddressCity, ShipAddressState, ShipAddressProvince, ShipAddressCounty, ShipAddressPostalCode, ShipAddressCountry, ShipAddressNote, PONumber As PO#, SalesOrderLineItemRefFullName, SalesOrderLineQuantity As QTY FROM SalesOrderLine where TxnDate &gt;= ({fn CURDATE()}-7) and TxnDate &lt;= ({fn CURDATE()})</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step6.png" alt="" /></p>
<p>Click "Close" to save the configuration, &amp; You should be back to the QXL Main screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step5.png" alt="" /></p>
<p>The data will be exported by clicking on the Export icon from the QXL Main Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step7.png" alt="" /></p>
<p>The data is exported into a CSV file.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLDateFilter/step8.png" alt="" /></p>
<p>Also Refer: <a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2914" target="_blank">How to use QXL with Scheduler</a>.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to SQL Server - using SQL Default Driver]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2921]]></link>
<guid isPermaLink="false"><![CDATA[17d8da815fa21c57af9829fb0a869602]]></guid>
<pubDate><![CDATA[Mon, 24 Apr 2017 11:33:45 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to export to SQL Server - using SQL Default Driver
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to SQL Server.
How can I export QuickBooks Data to SQL Server using QXL?
Solution:
You can export QuickBooks Data to SQL...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to export to SQL Server - using SQL Default Driver</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to SQL Server.</p>
<p>How can I export QuickBooks Data to SQL Server using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to SQL Server using QXL. There are two ways to export QuickBooks Data to SQL Server.</p>
<p>1. Using SQL Server default driver.<br />2. Using SQL Server ODBC Driver</p>
<h4><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Using the SQL Server default driver</span></span></h4>
<p>The first step in adding an SQL Server connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "SQL Server Driver" as a Connection Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample SQL Server Connection String Format:</strong> Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;</p>
<p><strong>For Example:</strong> Server=WIN-O8RQBVCMJFC;Database=Desktop;User Id=sa;Password=sa;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step8.png" alt="" /></p>
<p>Now the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to the SQL Server.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step10.png" alt="" /></p>
<h4><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Using SQL Server ODBC Driver</span></span></h4>
<p>First, you need to create an ODBC DSN for SQL Server, which will point to your Database.</p>
<p>I have already created an ODBC DSN for SQL Server below the properties of the DSN.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step11.png" alt="" /></p>
<p>SQL Server ODBC DSN test connection successful. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step12.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "Microsoft SQL Server" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=QXLSQL</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step13.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step14.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step15.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step16.png" alt="" /></p>
<p>Now the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to the SQL Server.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSQL/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to MySQL]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2920]]></link>
<guid isPermaLink="false"><![CDATA[465636eb4a7ff4b267f3b765d07a02da]]></guid>
<pubDate><![CDATA[Mon, 24 Apr 2017 11:19:58 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to export to MySQL 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to MySQL.
How can I export QuickBooks Data to MySQL using QXL?
Solution:
You can export QuickBooks Data to MySQL using QXL.
First, you need a MySQL OD...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to export to MySQL </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to MySQL.</p>
<p>How can I export QuickBooks Data to MySQL using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to MySQL using QXL.</p>
<p>First, you need a MySQL ODBC connector to connect to the MySQL database.</p>
<p>You need to download &amp; install the MySQL ODBC connector on your system.</p>
<p>Refer: <a href="https://dev.mysql.com/downloads/connector/odbc/" target="_blank">Download Connector/ODBC</a> to download the MySQL ODBC connector.</p>
<p>After installing the MySQL ODBC connector, you need to configure the MySQL ODBC DSN, which will point to the MySQL Database.</p>
<p>Refer: <a href="https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html" target="_blank">Configuring a Connector/ODBC 5. x DSN on Windows</a> to configure MySQL ODBC DSN.</p>
<p>I have already created an ODBC DSN for MySQL. Below is the property of the DSN.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step11.png" alt="" /></p>
<p>MySQL ODBC DSN test connection successful. We will use this DSN in QXL. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step12.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "MySQL Server" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=MYQXLANSI</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step8.png" alt="" /></p>
<p>Now the data is ready to export into MySQL. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to MySQL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMYSQL/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to export to MS Access]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2919]]></link>
<guid isPermaLink="false"><![CDATA[6271faadeedd7626d661856b7a004e27]]></guid>
<pubDate><![CDATA[Mon, 24 Apr 2017 11:10:38 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to export to MS Access 
Problem Description:
I am using QXL &amp; I want to export QuickBooks Data to MS Access.
How can I export QuickBooks Data to MS Access using QXL?
Solution:
You can export QuickBooks Data to MS Access using QXL.
First, you...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to export to MS Access </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to export QuickBooks Data to MS Access.</p>
<p>How can I export QuickBooks Data to MS Access using QXL?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can export QuickBooks Data to MS Access using QXL.</p>
<p>First, you need to create an MS Access database file (.accdb) and save it to your disk drive.</p>
<p>Create a new ODBC DSN for MS Access, which will point to the MS Access Database.</p>
<p>Search for ODBC or&nbsp;navigate to C:\Windows\SysWOW64\ folder and find odbcad32.exe and double click on&nbsp;odbcad32.exe</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/acceess-odbc-search.png" alt="" /></p>
<p style="text-align: left;" align="center">Switch to System DSN</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/access-system-dsn.png" alt="" /></p>
<p style="text-align: left;" align="center">Select Microsoft Access Driver (*.mdb, *.accdb)</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/access-driver-select.png" alt="" /></p>
<p align="center">&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/access-dsn-empty.png" alt="" /></p>
<p style="text-align: left;" align="center">Input the Data Source Name and click "Select."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/access-dsn-name-entry.png" alt="" /></p>
<p style="text-align: left;" align="center">Navigate to the folder containing your MS Access database file.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/access-database-select.png" alt="" /></p>
<p>I have already created an ODBC DSN for MS Access below the properties of the DSN. We will use this DSN in QXL.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step11.png" alt="" /></p>
<p>The first step in adding an ODBC connection is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step1.png" alt="" /></p>
<p>Navigate to "Pro Edition" &amp; click the "Add New" button to add the New Connection.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step2.png" alt="" /></p>
<p>Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type &amp; "Microsoft Access" as a Mapping Type, and click the "Test Connection" button.</p>
<p>You can insert any value for the Connection Name.</p>
<p><strong>Sample ODBC Connection String Format:</strong> DSN = Data Source Name</p>
<p><strong>For Example</strong>&nbsp;DSN=QXLMSA</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step3.png" alt="" /></p>
<p>Test Connection Successful.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step4.png" alt="" /></p>
<p>Click the "Save" button to save connection details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step5.png" alt="" /></p>
<p>Connection information updated.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step6.png" alt="" /></p>
<p>The connection is added to the dropdown list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step7.png" alt="" /></p>
<p>Navigate to the "General" tab &amp; select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format &amp; click "Close."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step8.png" alt="" /></p>
<p>Now the data is ready to export into MS Access. You can export by clicking on the Export icon from the QXL Setup Screen.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step9.png" alt="" /></p>
<p>QuickBooks Data is exported to MS Access.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMSA/step10.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to run Profit and Loss detail report - with different parameters]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2918]]></link>
<guid isPermaLink="false"><![CDATA[f6c9dc70ecfd8f90ba8598aa2401cd1a]]></guid>
<pubDate><![CDATA[Mon, 24 Apr 2017 10:42:09 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to run a Profit and Loss detail report - with different parameters 
Problem Description:
I am using QXL &amp; I want to run a Profit and Loss detail report through QXL. I can see the report on the list. But I want to change the report parameter.
Ho...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to run a Profit and Loss detail report - with different parameters </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to run a Profit and Loss detail report through QXL. I can see the report on the list. But I want to change the report parameter.</p>
<p>How can I change the report parameter &amp; run the updated report?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can change the report parameter from the QXL Report Settings tab.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step1.png" alt="" /></p>
<p>You can choose the ProfitAndLossDetail report from the drop-down list &amp; add the report for export.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step2.png" alt="" /></p>
<p>You can see the default report query in the Report Query/Command box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step3.png" alt="" /></p>
<p>You can modify the report query from the Report Query/Command box.</p>
<p>You can refer to the&nbsp;<a href="http://qodbc.com/schema.htm" target="_blank">QODBC Data Layouts</a> site for details about different report parameters.</p>
<p>Navigate to the above link &amp; click on the region of the QuickBooks edition you are using.</p>
<p>You will be redirected to the QuickBooks region link. Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"ProfitAndLossDetail"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the ProfitAndLossDetail information.</p>
<p>If you are a&nbsp;<strong>QuickBooks USA</strong> user, then you can refer to the direct link for <a href="http://doc.qodbc.com/qodbc/usa/ReportParameter.php?tableName=ProfitAndLossDetail" target="_blank">PARAMETERS AND VALUES FOR: ProfitAndLossDetail</a>.</p>
<p>You can use any of the supported parameters in the report query.</p>
<p>I am changing the report query by adding TxnFilterTypes =' Invoice' parameter &amp; ReportBasis='Accrual' and changing the DateMacro parameter value to 'ThisMonthToDate.'</p>
<p>For Example, sp_report <span style="color: #990000;">ProfitAndLossDetail</span> shows TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, ClearedStatus_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Text, Blank, TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance <span style="color: #0000ff;">parameters DateMacro = 'ThisMonthToDate,' TxnFilterTypes='Invoice,' ReportBasis='Accrual.' </span></p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step4.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step6.png" alt="" /></p>
<p>The modified report query &amp; was added to the export list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step5.png" alt="" /></p>
<p>By repeating the above process, you can add a different report with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from the QXL Main Window.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step7.png" alt="" /></p>
<p>Report exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step8.png" alt="" /></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to run General Detail (General Ledger) report - with parameters]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2917]]></link>
<guid isPermaLink="false"><![CDATA[dfb84a11f431c62436cfb760e30a34fe]]></guid>
<pubDate><![CDATA[Mon, 24 Apr 2017 10:19:38 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to run the General Detail (General Ledger) report - with parameters 
Problem Description:
I am using QXL &amp; I want to run the GeneralLedger report through QXL. I can see the report on the list. But I want to change the report parameter.
How can ...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to run the General Detail (General Ledger) report - with parameters </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I am using QXL &amp; I want to run the GeneralLedger report through QXL. I can see the report on the list. But I want to change the report parameter.</p>
<p>How can I change the report parameter &amp; run the updated report?</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can change the report parameter from the QXL Report Settings tab.</p>
<p>The first step in changing the report parameter is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step1.png" alt="" /></p>
<p>You can choose the GeneralLedger report from the drop-down list &amp; add the report for export.</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLGL/step2.png" alt="" /></p>
<p>You can see the default report query in the Report Query/Command box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLGL/step3.png" alt="" /></p>
<p>You can modify the report query from the Report Query/Command box.</p>
<p>You can refer to the&nbsp;<a href="http://qodbc.com/schema.htm" target="_blank">QODBC Data Layouts</a> site for details about different report parameters.</p>
<p>Navigate to the above link &amp; click on the region of the QuickBooks edition you are using.</p>
<p>You will be redirected to the QuickBooks region link. Click on the <strong>"ALPHABETICAL LISTING OF ALL REPORTS"</strong> under the&nbsp;<strong>"REPORT OVERVIEW"</strong> label.</p>
<p>You will be presented with a list of reports. Search for the&nbsp;<strong>"GeneralLedger"</strong> report &amp; click on <strong>"Parameters"</strong> to get details about all supported parameters for the GeneralLedger report.</p>
<p>If you are a&nbsp;<strong>QuickBooks USA</strong> user, then you can refer to the direct link for <a href="http://doc.qodbc.com/qodbc/usa/ReportParameter.php?tableName=GeneralLedger" target="_blank">PARAMETERS AND VALUES FOR: GeneralLedger</a>.</p>
<p>You can use any of the supported parameters in the report query.</p>
<p>I am changing the report query by adding the AccountFilterType parameter &amp; changing the date period by using the DateFrom &amp; DateTo parameters.</p>
<p>For Example, sp_report <span style="color: #990000;">GeneralLedger</span> shows TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Blank, TxnType, Date, RefNumber, Name, Memo, SplitAccount, Debit, Credit, RunningBalance <span style="color: #0000ff;">parameters DateFrom = {d'2021-01-15'}, DateTo= {d'2021-06-30'}, AccountFilterType='AccountsReceivable.'</span></p>
<p>You need to modify the report query &amp; click the "Add or Update" button to update the report query.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLGL/step4.png" alt="" /></p>
<p>The modified report query &amp; was added to the export list.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLGL/step5.png" alt="" /></p>
<p>By repeating the above process, you can add different reports with different supported parameters per your requirement.</p>
<p>The report will be exported by clicking on the Export icon from the QXL Main Window.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLPLD/step7.png" alt="" /></p>
<p>Report exported.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLGL/step7.png" alt="" /></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to use QXL with Scheduler]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2914]]></link>
<guid isPermaLink="false"><![CDATA[17eb7ecc4c38e4705361cccd903ad8c6]]></guid>
<pubDate><![CDATA[Fri, 14 Apr 2017 09:38:54 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to use QXL with Scheduler 
Problem Description:
I want to export QuickBooks Data using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will automatically ship QuickBooks Data at the scheduled time.
But I don't know how I can use Q...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to use QXL with Scheduler </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I want to export QuickBooks Data using QXL.</p>
<p>I want to schedule QXL for exporting QuickBooks Data. So it will automatically ship QuickBooks Data at the scheduled time.</p>
<p>But I don't know how I can use QXL with the Scheduler.</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>You can configure the QXL export option by creating the shortcut using QXL &amp; can use the shortcut in the scheduler.</p>
<p>The first step in configuring the application is to click on the settings icon for QXL options details.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step1.png" alt="" /></p>
<p>In the General tab, you will find two buttons to create the export shortcut on your desktop.</p>
<p>&nbsp;</p>
<p>1. QXL - Silent Mode, which will export data in silent mode (does not display the QXL Window).</p>
<p>For example, QXL.exe Silent</p>
<p>&nbsp;</p>
<p>2. QXL - Direct Export Mode will export data in direct mode (display QXL Window).</p>
<p>For Example, QXL.exe Run</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step2.png" alt="" /></p>
<p>By clicking on the "Create a shortcut on desktop" button, you will get the below pop-up message &amp; click "OK." It will create the shortcut on the desktop.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step3.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step4.png" alt="" /></p>
<p>The shortcut is created on the desktop.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLSCH/step6.png" alt="" /></p>
<p>You can use the above shortcut in your scheduled application to export QuickBooks Data using QXL.</p>
<h4><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Use Scheduler:</span></span></h4>
<div><strong>Note:</strong> QXL and QODBcanto access data from QuickBooks using the QuickBooks SDK, which is an embedded feature of the QuickBooks Desktop Application</div>
<div>QuickBooks SDK requires an active desktop session ( someone to be logged in ) to the machine because QuickBooks is a desktop-based application.</div>
<div>The QuickBooks application is a desktop-based application, and it is not designed to run under the service account or run as a service.</div>
<p>&nbsp;</p>
<p>You can use any desktop-based scheduler (for example, "QScheduler"). QuickBooks and QuickBooks SDK are desktop-based and not designed to run as a service. QODBC &amp; QXL are also desktop-based applications. Thu,s you will need an active desktop session (someone logged into the machine). You may not be able to use the service-based scheduler like "Task Scheduler." In this example, we are using Z-Cron, but you can use any other desktop-based scheduler.</p>
<h2>&nbsp;</h2>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please refer to the following article for how to install QScheduler&nbsp;- <a href="https://qxl1.com/links/3047" target="_blank">https://qxl1.com/links/3047</a></span></p>
<p>&nbsp;</p>
<p align="center">&nbsp;</p>
<p>QScheduler can be accessed from the Desktop.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/6.png" alt="" width="109" height="100" name="Picture 22" align="center" border="0" /></p>
<p>QScheduler can also be accessed from the Windows Start Menu.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/7.png" alt="" width="344" height="234" name="Picture 1" align="center" border="0" /></p>
<p>When the application starts for the first time, it will contain no tasks.</p>
<p>Click the "Ok" button to continue.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/8.png" alt="" width="674" height="450" name="Picture 4" align="center" border="0" /></p>
<p>To create a new scheduled task, click the "Add" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/9.png" alt="" width="669" height="448" name="Picture 6" align="center" border="0" /></p>
<p>&nbsp;</p>
<p>Input the "Task Name", then click the browse button to select the application/batch file you want to run on a regular interval.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/10.png" alt="" width="690" height="461" name="Picture 7" align="center" border="0" /></p>
<p>In this example, we will use&nbsp;the QXL Application and schedule it to export all the data of the QuickBooks company - "QuickBooks company A".</p>
<p>&nbsp;</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/11.png" alt="" width="643" height="455" name="Picture 8" align="center" border="0" /></p>
<p>To identify the task, I am naming the task &ldquo;QXL CompanyA Hourly Export&rdquo;.</p>
<p>You can add multiple tasks if you wish to export data from various QuickBooks companies.</p>
<p>&nbsp;</p>
<p>After the application is selected, it will automatically populate the working directory.</p>
<p>The &lsquo;Working Directory&rsquo; option is useful if your application or script is looking for a file in the current folder, so you can set the current folder to where the file is.</p>
<p>If you wish to change the &lsquo;Working Directory&rsquo;, you may click the browse button next to the &lsquo;Working Directory&rsquo; input box.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/12.png" alt="" width="713" height="476" name="Picture 9" align="center" border="0" /></p>
<p>You can specify the command-line arguments/parameters required by your application.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/13.png" alt="" width="685" height="458" name="Picture 10" align="center" border="0" /></p>
<p>In this example, I will be using the QXL Parameter file, which contains the settings being passed to the program. For more details about the QXL Parameter file, please refer to <span style="color: #0000ff;"><span style="text-decoration: underline;"><a href="http://qodbc.com/links/2938">http://qodbc.com/links/2938</a>.</span></span></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/14.png" alt="" width="706" height="472" name="Picture 19" align="center" border="0" /></p>
<p>Input the starting time and date to begin the task and the repeat interval.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/15.png" alt="" width="649" height="434" name="Picture 11" align="center" border="0" /></p>
<p>Click Close to save the task and return to the &lsquo;Task List&amp;rsquo.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/16.png" alt="" width="680" height="455" name="Picture 13" align="center" border="0" /></p>
<p>For QScheduler Options/Settings, click the Wrench Icon.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/17.png" alt="" width="704" height="471" name="Picture 20" align="center" border="0" /></p>
<p>Enable Start QScheduler automatically when you sign in to Windows.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/18.png" alt="" width="676" height="452" name="Picture 15" align="center" border="0" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/19.png" alt="" width="697" height="466" name="Picture 16" align="center" border="0" /></p>
<p>Click on the &lsquo;Close&rsquo; button to close the form.</p>
<p>To minimize the QScheduler to the System Tray, click the minimize icon.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/20.png" alt="" width="677" height="452" name="Picture 17" align="center" border="0" /></p>
<p>To maximize QScheduler, click the &lsquo;QScheduler&rsquo; icon from the system tray.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/3047/21.png" alt="" width="368" height="81" name="Picture 18" align="center" border="0" /></p>
<p><br /><br /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found.]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2911]]></link>
<guid isPermaLink="false"><![CDATA[ef67f7c2d86352c2c42e19d20f881f53]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:57:11 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found. 
Problem Description:
I am trying to export data from QXL. I have selected ItemAssembliesCanBuild &amp; other tables from the "Table Setting" tab. After that, I click...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found. </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. I have selected ItemAssembliesCanBuild &amp; other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the following error message after export.</span></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOBJX/step1.png" alt="" /></p>
<p>ERROR [00000] [QODBC] Error: 3120 - Object "X" specified in the request cannot be found.&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">ItemAssembliesCanBuild Query does require ItemInventoryAssemblyRef(ListID or FullName) and TxnDate in the WHERE Clause to perform the query in QuickBooks SDK. </span></p>
<p>You will get this error when you execute a query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate.</p>
<p>So it would be best to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through a custom query.&nbsp;</p>
<p>You need to write the table name in the Custom Table Name box &amp; write the query in the Custom Query box. After writing the table name &amp; query, click on the "Add or Update" button to add the query.</p>
<p>For Example:<br />SELECT * FROM ItemAssembliesCanBuild where ItemInventoryAssemblyRefFullName='assembly item' and TxnDate={d'2018-01-01'}</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOBJX/step2.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOBJX/step3.png" alt="" /></p>
<p>After adding the query, please try to export again. You will not get the error.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 80040409 Error]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2910]]></link>
<guid isPermaLink="false"><![CDATA[dba31bb5c75992690f20c2d3b370ec7c]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:52:15 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 80040409 Error 
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below.
The current version of QuickBooks cannot work with the specified company data f...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 80040409 Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below.</span></p>
<p>The current version of QuickBooks cannot work with the specified company data file.</p>
<p>Error Occurred:[QODBC] QuickBooks Begin Session Failed. Error = 80040409. The current version of QuickBooks cannot work with the specified company data file.</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You may encounter the above error when your QuickBooks company file is updated to a higher version of QuickBooks, and you are trying to use it in an older version of QuickBooks. </span></p>
<p>For Example:</p>
<p>If you try to open the QuickBooks 2017 company file in QuickBooks 2016 or a lower version, you will get the above error.</p>
<p>You can open QuickBooks company files in the same version or a higher version of QuickBooks. However, you can't open QuickBooks company files in older QuickBooks versions.</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error Column not found]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2909]]></link>
<guid isPermaLink="false"><![CDATA[b5b03f06271f8917685d14cea7c6c50a]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:48:37 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error Column not found 
Problem Description:
I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the below error after export.
ERROR [42S00] [QODBC] Column not found...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error Column not found </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the below error after export.</span></p>
<p>ERROR [42S00] [QODBC] Column not found</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">There might be some syntax issues in your query. </span></p>
<p>You will get this error When you use the wrong column name in the query.</p>
<p>Please verify the column name used in your custom query and try again.</p>
<p>Please refer to QODBC <a href="http://qodbc.com/schema.htm" target="_blank">Data Layout (Schema)</a> for more detail about table schema.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL Error Insufficient permission level to perform this action]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2908]]></link>
<guid isPermaLink="false"><![CDATA[73b817090081cef1bca77232f4532c5d]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:46:20 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error: Insufficient permission level to perform this action 
Problem Description:
I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.
[QODBC] Error: 3260 - ...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error: Insufficient permission level to perform this action </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>[QODBC] Error: 3260 - Insufficient permission level to perform this action</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You may encounter the above error if the QuickBooks user does not have permission to access data in QuickBooks. </span></p>
<p>Please try removing "FLEXquarters QODBC " from the Integration Application and try to connect.</p>
<p>Refer to how<a href="http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2482" target="_blank">&nbsp;to remove QODBC Related Certificates from Integrated Application Under QuickBooks</a> for more details.</p>
<p>If a currently logged-in QuickBooks user is restricted from accessing a particular module in the QuickBooks Application (UI), the user will not be able to access the same from QXL.</p>
<p>QXL uses QODBC, and QODBC uses QuickBooks SDK to communicate with QuickBooks. QuickBooks SDK, by default, currently uses the logged-in QuickBooks user access right. Integrated Application user rights will be overridden if any user is logged into the QuickBooks Application (UI).</p>
<p>Refer to&nbsp;<a href="http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2839" target="_blank">User Access Rights within QuickBooks</a> for more details.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error Invalid field definition]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2907]]></link>
<guid isPermaLink="false"><![CDATA[c7558e9d1f956b016d1fdba7ea132378]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:44:09 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error: Invalid field definition 
Problem Description:
I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.
Invalid field definition
Solu...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error: Invalid field definition </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>Invalid field definition</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You may encounter the above error when there is a data type schema mismatch in the ODBC database while creating the new table or inserting the record into the destination database. </span></p>
<p>In this case, you need to raise a support ticket with us under the department "QXL Technical Support."</p>
<p>Please share QXL &amp; SDK logs, Screenshots of the issue, &amp; Screenshots of all the tabs QXL Option/Settings Tabs.</p>
<p>You can find logs from QXL Setting -- &gt; Advanced -- &gt; Messages -- &gt; Review QXL Messages &amp; Review SDK Messages</p>
<p>You may <a href="http://support.flexquarters.com/esupport/index.php?/Tickets/Submit" target="_blank">Click Here to raise a support ticket.</a></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error Invalid table name]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2906]]></link>
<guid isPermaLink="false"><![CDATA[9e82757e9a1c12cb710ad680db11f6f1]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:41:35 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error: Invalid table name 
Problem Description:
I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the following error after export.
ERROR [42S00] [QODBC] Invalid t...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error: Invalid table name </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>ERROR [42S00] [QODBC] Invalid table name</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">There might be some syntax issues in your query. </span></p>
<p>You will get this error when you use the wrong Table name in the query.</p>
<p>Please verify the table name used in your custom query and try again.</p>
<p>Please refer to QODBC <a href="http://qodbc.com/schema.htm" target="_blank">Data Layout (Schema)</a> for more details about the table schema.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error Object reference not set to an instance of an object]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2905]]></link>
<guid isPermaLink="false"><![CDATA[314450613369e0ee72d0da7f6fee773c]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:38:47 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error: Object reference not set to an instance of an object 
Problem Description:
I am trying to export data from QXL. After that, I clicked on the QXL export button I got the following error after export.
Object reference not se...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error: Object reference not set to an instance of an object </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>Object reference not set to an instance of an object</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please update QXL to the latest version. </span></p>
<p>You can download QXL's latest version by <a href="http://qxl1.com/downloads/" target="_blank">clicking here</a>.</p>
<p>If you still face the issue, please raise a support ticket with us under the department "QXL Technical Support."</p>
<p>Please share QXL &amp; SDK logs, Screenshots of the issue, &amp; Screenshots of all the tabs QXL Option/Settings Tabs. You can find logs from QXL Setting -- &gt; Advanced -- &gt; Messages -- &gt; Review QXL Messages &amp; Review SDK Messages</p>
<p>You may&nbsp;<a href="http://support.flexquarters.com/esupport/index.php?/Tickets/Submit" target="_blank">Click Here to raise a support ticket.</a></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error System.OutOfMemoryException]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2903]]></link>
<guid isPermaLink="false"><![CDATA[3c333aadfc3ee8ecb8d77ee31197d96a]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:12:39 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error System.OutOfMemoryException 
Problem Description:
I am trying to export data from QXL. I have selected Transaction &amp; other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the fol...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error System.OutOfMemoryException </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. I have selected Transaction &amp; other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the following error message after export.</span></p>
<p>System.OutOfMemoryException</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You will get the above error if your table contains extensive data. </span></p>
<p>As your table contains many records, you need to put limits on your query &amp; export data.</p>
<p>So it would be best if you executed the query through a custom query.</p>
<p>You need to write the table name in the Custom Table Name box &amp; write the query in the Custom Query box. After writing the table name &amp; query, click on the "Add or Update" button to add the query.</p>
<p>For Example:<br />select * from Transaction where TxnDate &gt;= {d '2016-10-01'} AND TxnDate &lt;= {d '2016-11-01'}</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMEM/step1.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLMEM/step2.png" alt="" /></p>
<p>In the same way, you can add the query for the different date periods.</p>
<p>After adding the query, please try to export again.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error when attempting to update the value]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2902]]></link>
<guid isPermaLink="false"><![CDATA[379a7ba015d8bf1c70b8add2c287c6fa]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:07:24 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error when attempting to update the value 
Problem Description:
I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.
Error when attempting to update the valu...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error when attempting to update the value </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>Error when attempting to update the value</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;"> Please update QXL to the latest version.</span></p>
<p>You can download the latest version by <a href="http://qxl1.com/downloads/" target="_blank">clicking here</a>.</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">If you are still facing the issue, your company file might have some data issues. <br /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please raise a support ticket with us under the department "QXL Technical Support."&nbsp;</span></p>
<p>Please share QXL logs, a Screenshot of the issue, &amp; Screenshot of all the tabs of QXL Option/Settings Tabs. You can find logs from QXL Setting -- &gt; Advanced -- &gt; Messages -- &gt; Review QODBC Messages</p>
<p>You can <a href="http://support.flexquarters.com/esupport/index.php?/Tickets/Submit" target="_blank">Click Here to raise a support ticket.</a></p>
<p>If possible, please share your company file with us</p>
<p>Refer: <a href="http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2833/83/qodbc-all-troubleshooting---how-to-zip-and-upload-the-company-file" target="_blank">How to zip and upload the company file</a></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - QXL Error Syntax error in CREATE TABLE statement]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2901]]></link>
<guid isPermaLink="false"><![CDATA[a57e8915461b83adefb011530b711704]]></guid>
<pubDate><![CDATA[Thu, 06 Apr 2017 12:01:03 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Error: Syntax error in CREATE TABLE statement 
Problem Description:
I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.
Syntax error in ...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Error: Syntax error in CREATE TABLE statement </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.</span></p>
<p>Syntax error in CREATE TABLE statement</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">There might be a syntax error when creating the ODBC database table at export time. </span></p>
<p>In this case, you need to raise a support ticket with "QXL Technical Support."</p>
<p>Please share QXL logs &amp; raise a support ticket. You can find logs from QXL Setting -- &gt; Advanced -- &gt; Messages -- &gt; Review QODBC Messages</p>
<p>You can <a href="http://support.flexquarters.com/esupport/index.php?/Tickets/Submit" target="_blank">Click Here to raise a support ticket.</a></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Online] How to connect/reconnect QXL Online]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2879]]></link>
<guid isPermaLink="false"><![CDATA[ec8b57b0be908301f5748fb04b0714c7]]></guid>
<pubDate><![CDATA[Thu, 22 Dec 2016 07:53:47 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL Online is no longer&nbsp;connected to QuickBooks Online. Your user token is no longer&nbsp;valid. 
How to join/reconnect to QXL Online
Refer: How to download and install QXL Online
&nbsp;
After installation, you may notice the following icons on t...]]></description>
<content:encoded><![CDATA[<h2 style="text-align: center;"><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;"><span style="color: #ff0000;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-family: arial,sans-serif; font-size: 12.8px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; display: inline ! important; float: none; background-color: #ffffff;"><span style="font-family: Arial,Helvetica,sans-serif;"><strong>QXL Online is no longer&nbsp;connected to QuickBooks Online. Your user token is no longer&nbsp;valid.</strong> </span></span></span></span></span></h2>
<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">How to join/reconnect to QXL Online</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Refer: <a href="http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2887">How to download and install QXL Online</a></span></h3>
<p>&nbsp;</p>
<p>After installation, you may notice the following icons on the desktop.<br /><br /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step23.png" alt="" /></p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">The first use of QXL Online</span></h4>
<p>First, ensure you have access to the QuickBooks Online company file with Administrator privileges to authorize QXL Online to connect to your QuickBooks Online Company file.&nbsp;</p>
<p>In case you are using&nbsp;QuickBooks Online Accountant (a ProAdvisor), you need to be logged in to "Your Books" (the option in the left menu bar for accountants) or the client's books.</p>
<p>To authorize QXL Online to connect to your QuickBooks Online Company file, click the Red/Green toggle button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step8.png" alt="" /></p>
<p>QXL Online connection wizard should appear. Enter a Connection name to identify which account this represents, then click "Connect to QuickBooks."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step9.png" alt="" /></p>
<p>QXL Online will have a QuickBooks Online authorization page on your default browser. Click "OK" to authorize QXL Online at QuickBooks Online.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step10.png" alt="" /></p>
<p>Click on "Connect to QuickBooks" to begin the authorization process. (For QXL-Online v18.0.0.025 or lower). For&nbsp;QXL-Online v18.0.0.026 and above, this step will be skipped, and you will be prompted&nbsp;with QuickBooks credentials.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step11.png" alt="" /></p>
<p>By clicking "Authorize QXL Online to Connect to your QuickBooks Online," you open the authorization screen. You need to authorize your company file to work with QXL Online.<br />You need to enable a pop-up from your browser.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step12.png" alt="" /></p>
<p>Enter your QuickBooks User ID &amp; Password, then click "Sign In."</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step13.png" alt="" /></p>
<p>&nbsp;</p>
<p><strong>For QuickBooks Online Simple Start/Essentials/Plus Account</strong></p>
<p>Select the company file you want to use with QXL Online if you have multiple company files.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step14.png" alt="" /></p>
<p><strong>For ProAdvisor Account</strong></p>
<p>Select "Company/Firm" from the list. Click "Add app to the firm."</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLOL/QXL-Proadvisor.png" alt="" width="802" height="660" /></p>
<p>&nbsp;</p>
<p>After selecting the company, please click the "Next" button.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step15.png" alt="" /></p>
<p style="text-align: left;" align="center">Please click the "Connect" or "Authorize" button. It will allow "QXL for QuickBooks Online" to access your QuickBooks Online company data file.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step16.png" alt="" /></p>
<p>After successful authorization, it will return to the QXL Online page with a connected status. You can close this window.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step17.png" alt="" /></p>
<p>QXL Online is successfully connected to your QuickBooks Online company. Click "OK" &amp; "Close" to complete the configuration.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step18.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step19.png" alt="" /></p>
<p>Switch back to QXL Online and click Export Data.</p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step20.png" alt="" /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step21.png" alt="" /></p>
<p>After the export is completed. The exported data folder will open. Exported data is placed at the following location by default:<br /><br /></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOL/step22.png" alt="" /></p>
<p>C:\Users\User Name\Documents\QXL\Company FileName Folder <br /><br /></p>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Online Features:</span></h3>
<p>1. Export QuickBooks Online Data to Excel format.<br /><br />2. Export QuickBooks Online Data to CSV format.<br /><br />3. Export QuickBooks Online Data to SQL Server.<br /><br />4. Choose export file(s) location.<br /><br />5. Export to Separate files or a single file.<br /><br />6. Export all tables, selected tables, or excluded tables.<br /><br />7. Custom Query Export.<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Also, Refer:</span><br /> <a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2837">QXL Online options and settings</a></p>
<div id="commentparent">
<div id="commentsformcontainer"><form action="http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Comments/Submit/2418/" enctype="multipart/form-data" method="post" name="CommentsForm"></form></div>
</div>
<table class="gstl_50 gssb_c" style="width: 206px; display: none; top: 170px; left: 257px; position: absolute;" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td class="gssb_f">&nbsp;</td>
<td class="gssb_e" style="width: 100%;">&nbsp;</td>
</tr>
</tbody>
</table>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Online] QXL Online options and settings]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2837]]></link>
<guid isPermaLink="false"><![CDATA[353de26971b93af88da102641069b440]]></guid>
<pubDate><![CDATA[Fri, 14 Oct 2016 14:22:25 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL Online options and settings
QXL Online options and settings/Configuration:
The first step in configuring the application is to click on the settings icon for QXL Online options details.
&nbsp;
Connections Tab:You can add and manage connections fro...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">QXL Online options and settings</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Online options and settings/Configuration:</span></h3>
<p>The first step in configuring the application is to click on the settings icon for QXL Online options details.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step1.png" alt="" /></p>
<p><strong>Connections Tab:</strong><br /><br />You can add and manage connections from the Connections Tab to different QuickBooks Online company files. You can add a new link by clicking on the "Add New" button. You can change the connection from the drop-down list if you have multiple references to the QuickBooks Online company file. The selected connection will be used for exporting data.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step2.png" alt="" /></p>
<p><strong>General Tab:</strong><br /><br />From the General Tab, you can change the following:<br /><br />1. Output Folder: - You can change the path of the output folder by clicking the "Browse" button.<br /><br />2. Format: You can format the exported file to XLSX, XLS, CSV, or SQL Server / ODBC Data Source.<br /><br />3. SQL / ODBC Connection String: - You can set the SQL / ODBC Connection String.<br /><br /> <strong>Note:</strong> QXL Online Professional&nbsp;Edition license requires exporting data into SQL Server / ODBC Data Source.<br /><br />4. Export In: - You can change the export option to Separate File or Single File.<br /><br />5. Output file(s) read-only: - You can protect exported file for unwanted write. This option will set exported files to read-only if you select "Yes."</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step3.png" alt="" /></p>
<p><strong>Advanced Tab:</strong><br /><br />From the Advanced Tab, you can change Optimizer &amp; Messages settings as follows:<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step4.png" alt="" /></p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Online Optimizer Setup:</span></h4>
<p><strong>What is an Optimizer file?</strong></p>
<p>When you access any table, QXL Online will gather data from QuickBooks Online and store it in an Optimizer file. When you turn on the Optimizer, QXL Online will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries. Next time you query the same table, QXL Online will request differential records that are added, modified, and deleted from QuickBooks Online and will sync them to the Optimizer file. This way, QXL Online will only have to get the differential records instead of the entire data set from QuickBooks Online. As a result, you will notice a performance gain compared to working without an optimizer.</p>
<p>Initial data optimization has been benchmarked at up to a 30% reduction in load time. The first time you access a given QuickBooks Online table, QXL Online, by default, optimizes&nbsp;access to that data, so the next time you need data from that table, it will be much faster.&nbsp;</p>
<p><strong>The optimizer</strong> brings some data to a local cache to increase query retrieval performance. Check to activate the optimizer.</p>
<p><strong>Optimizer Database Folder</strong> specifies where the local data store will be saved on disk. The default location %AppData%\QXL - QuickBooks Online Data Export Data Made Easy\Optimizer is under your Windows login account name under your Documents and Settings folder. The data will be stored in a file in this folder with a name similar to the company file name with a .opt extension. If you keep that data somewhere other than the default, click the browse button and select the destination folder. You can change the path of the Optimizer folder by clicking the "Browse" button. With very large company files, we suggest running synchronization after hours.<br /><br /><strong>Reset Optimizer File(s)</strong>: This button is used to rebuild the optimized data from scratch. It is useful when starting a new company if you do not want to synchronize the tables as you first encounter them and ensure that your data is 100% current.</p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Online Messages:</span></h4>
<p>Messages allow you to review message logs from QXL Online regarding errors and issues communicating with QuickBooks Online and clear these messages.<br /><br /><strong>Display Driver Status Panel,</strong> when selected, shows exactly what QXL Online is doing when accessing the QuickBooks Online data and provides a good assessment of speed using optimized and non-optimized data.</p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Export Options:</span></h4>
<p><strong>Create a table from the sheet</strong> option will create the table from the spreadsheet (for Excel 2010 or above in [xlsx] format only)</p>
<p><strong>Table Styles</strong> option is used for formatting Excel cells by choosing predefined styles (for Excel 2010 or above in [xlsx] format only). You can select a predefined style using the drop-down.</p>
<p><strong>Header Color</strong> option used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only).&nbsp;You can change the header color using the "Click to change header color" button.</p>
<p>&nbsp;</p>
<p><strong>Table Settings Tab:</strong><br /><br />From the Table Settings Tab, you can change table options as follows:<br /><br />1. ALL tables: - This option will export all tables to the output folder. <br /><br />2. Selected Table: - This option will export selected tables to the output folder. <br /><br />3. Excluding Selected Table: This option will export all tables to the output folder we have not selected. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step5.png" alt="" /></p>
<p>In the Selected Table option, you can select the table by double-clicking on the table name. You can select all tables by clicking "All." You can clear the selection by clicking "None." You can invert table selection by clicking "Invert."</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step6.png" alt="" /></p>
<p><strong>Custom Query Tab:</strong><br /><br />From the Custom Query Tab, you can write your custom query and fetch data according to your requirements.<br /><br />You need to write the table name in the Custom Table Name box &amp; write the query in the Custom Query box. After writing the table name &amp; query, click on the "Add or Update" button to add the question. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step7.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step8.png" alt="" /></p>
<p>You can update existing queries by double-clicking on the table name &amp; modify the query Custom Query box. After changing the query, click on the "Add or Update" button to update the query.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step9.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step10.png" alt="" /></p>
<p>You can remove the existing query by double-clicking on the table name &amp; click on the "Remove Selected" button to delete the query.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step11.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step12.png" alt="" /></p>
<p><strong>Report Setting Tab:</strong><br /><br />This tab allows you to add default reports to export. You can also add a custom report with different parameters. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step13.png" alt="" /></p>
<p>You can choose the default report from the drop-down list &amp; add the report for export.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step14.png" alt="" /></p>
<p>Select any report from the drop-down list &amp; click on the "Add or Update" button to add the report for export.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step15.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step16.png" alt="" /></p>
<p>If you want to add a Custom report using different parameters, you can add it&nbsp;by writing a report query &amp; output report name. <br /><br />You need to write the report name in the Output Table Name box &amp; write the query in the Report Query/Command box. After writing the report name &amp; question, click on the "Add or Update" button to add the report query. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step17.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step18.png" alt="" /></p>
<p>You can remove the existing report by double-clicking on the report name &amp; click on the "Remove Selected" button to delete the report.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step19.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step20.png" alt="" /></p>
<p>You can modify the existing report by double-clicking on the report name. Report name &amp; query/command will be shown in the Output Table Name box &amp; Report Query/Command box. You need to modify the report &amp; "Add or Update" button to update the report query. <br /><br />You can save all the above configurations by clicking the "Close" button &amp; you can discard changes by clicking the "X" button.<br /><br /> <strong>Activate/Deactivate Tab:</strong><br /><br />You can activate / Deactivate QXL by clicking on the "Activate / Deactivate" button.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step21.png" alt="" /></p>
<p><strong>Activation:</strong><br /><br />Activate is the online option for entering the CD Key issued to you upon purchasing the product to fully start QXL from the evaluation version to the entire Standard Edition purchased. Suppose you do not have internet access to activate the product from the machine you intend to use. In that case, you can use the manual option to generate an activation code from a machine with internet access.<br /><br />Enter CD Key &amp; click on "Activate."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step22.png" alt="" /></p>
<p><strong>Manual Activation:</strong><br /><br />Enter the CD Key &amp; click on "Manual."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step23.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step24.png" alt="" /></p>
<p><strong>Deactivation:</strong><br /><br />Deactivate is the online method of deactivating a currently registered version of QXL to transfer the product to another machine. If internet access is unavailable from the registered device, you can use the manual option to generate a deactivation code from a device with internet access. Using the latest version of QODBC, credit for deactivation CDKEY is received instantly. In some cases, this process will take 24 to 48 hours before your CD Key account is credited with the deactivated license, and you can reactivate the license on a different machine.<br /><br />Enter CD Key &amp; click on "Deactivate.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step25.png" alt="" /></p>
<p><strong>Manual Deactivation:</strong><br /><br />Enter the CD Key &amp; click on "Manual."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step26.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step27.png" alt="" /></p>
<p><strong>Pro Edition Tab:</strong> <br /> <br />You can export QuickBooks Online Data into SQL Server &amp; ODBC database using the Pro Edition Tab. Please refer to the link below for more details.</p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2921" target="_blank">How to export to SQL Server - using SQL Default Driver &amp; ODBC</a></p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2920" target="_blank">How to export to MySQL</a></p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2919" target="_blank">How to export to MS Access</a></p>
<p align="center"><img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step29.png" alt="" /></p>
<p><strong>Note:</strong> <br />A QXL Online Professional&nbsp;Edition license is required to use this feature.</p>
<p><strong>About Tab:</strong><br />The&nbsp;<br />About screen shows the QXL Online version currently installed, whether it is an evaluation copy or a fully registered copy. The first letter in the serial number denotes the license type installed, and the 2nd &amp; 3rd digits are the QXL Online primary version number. (The serial number may be required for upgrades, rebate offers, technical installation support, or the Help Desk system.)<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLOLSetup/step28.png" alt="" /></p>
<p>Also, Refer: <br /><a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938" target="_blank">QXL Command line arguments/parameters</a><br /><a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2939" target="_blank">How to use QXL with scheduler for multiple company files</a></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Online] QXL for QuickBooks Online - Known Issue(s)/Limitation(s)]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2834]]></link>
<guid isPermaLink="false"><![CDATA[9752d873fa71c19dc602bf2a0696f9b5]]></guid>
<pubDate><![CDATA[Thu, 13 Oct 2016 11:44:18 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL for QuickBooks Online - Known Issue(s)/Limitation(s)
Problem Description:
I am trying to export data from QuickBooks Online using QXL Online. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"><strong>QXL for QuickBooks Online - Known Issue(s)/Limitation(s)</strong></span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QuickBooks Online using QXL Online. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in QXL Online. <br /><br />After reviewing the Output folder, I noticed some of the tables are not exported &amp; found the following error in the error logs from the export table folder:<br /><br />ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: ValidationException was thrown. At Intuit.Ipp.QueryFilter.QueryService`1<br /><br />ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: The Response Stream was null or empty.<br /><br />ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: No connection could be made because the target machine actively refused<br /><br />ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: An existing connection was forcibly closed by the remote host<br /><br />GatewayTimeout error<br /></span></p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">The above-mentioned error is returned randomly from the Intuit API. Sometimes, the Intuit API does not provide the proper response to data requests &amp; may throw the above error. <br /><br />When you receive such an error, you need to retry &amp; export a particular table.</span></p>
<h3>&nbsp;</h3>
<p>&nbsp;</p>
<p>Tags: QuickBooks Online, QBO, QXL Online, API</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[  [QXL-Online] QXL Online Limited Use Software License &amp; QXL Online Limited Warranties and Limitation Of Liability]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2831]]></link>
<guid isPermaLink="false"><![CDATA[4ea6a546c19499318091a9df40a13181]]></guid>
<pubDate><![CDATA[Fri, 16 Sep 2016 07:47:25 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL Online&nbsp;Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing ...]]></description>
<content:encoded><![CDATA[<p><strong>QXL Online&nbsp;Limited Use Software License</strong></p>
<p>LICENSE:</p>
<p>LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) utilizing a single operating system and (ii) make archival copies of the Program for backup purposes only for use with the same computer.</p>
<p>The serial number issued to you for this product indicates the highest version of QuickBooks Pro, Premier, or Enterprise with which the product can be used. If your registration code contains the year "10" at positions 2 and 3 of the serial number, it is registered to only work with QuickBooks 2010 and lower versions. If the registration code is set to "14," it will work with QuickBooks 2014 and lower versions.</p>
<p>You agree to affix a label to the archival copies that contains the copyright notice printed on the original disk or tape from which the document is made. LICENSER retains all rights to the Program not expressly granted in this agreement.<br />OWNERSHIP OF PROGRAMS AND COPIES: This license is not a sale of the original Program or any copies thereof. LICENSER retains the ownership of the program and all copies of the Program, regardless of the form in which the copies may exist. The Program and accompanying manual(s) ("Documentation") are copyrighted works of authorship and may contain valuable trade secrets and confidential information proprietary to LICENSER. The Program and the Documentation may not be copied, modified, or transferred without the express written permission of the LICENSER. You agree to exercise reasonable efforts to protect LICENSER'S proprietary interest in the Program and Documentation and maintain them in strict confidence.</p>
<p>USER RESTRICTIONS: You may physically transfer the Program from one computer to another, provided that it is operated only on one computer. You may not electronically transfer such a Program. You may not translate, modify, adapt, disassemble, decompile, or reverse engineer the Program. Versions of this product not designated as &ldquo;Web Version&rdquo; may not be used in a web service, time-sharing, or service bureau operation. You may not create derivative works based on such Program, Documentation, or any portions thereof.</p>
<p>TRANSFER: The Program is provided for use in your internal commercial business operations and must remain upon premises owned or leased by you. You may not rent, lease, sublicense, sell, assign, pledge, transfer, or otherwise dispose of the Program or the Documentation, on a temporary or permanent basis, without the prior written consent of LICENSER.</p>
<p>TERMINATION: This license is effective until terminated. This license will terminate automatically without notice from the LICENSER if you fail to comply with any license provision. Upon termination, you must cease all program use and return it, any copies thereof, including any archival documents, and the Documentation to LICENSER.</p>
<p>GENERAL: This license shall be governed and construed by the laws of the State of Nevada. If a provision of this agreement shall be held unenforceable, it shall be deemed severable from the remaining provisions. It shall in no way affect the validity or enforceability of the contract. The headings and captions used in this agreement are for convenience only and are not to be considered in construing or interpreting this agreement.<br /><br /><strong>QXL Online Limited Warranties and Limitation Of Liability</strong></p>
<p>LIMITED WARRANTY: LICENSER grants you as the original user of the Program a limited warranty that (i) the media on which the Program is distributed and the Documentation will be free of material defects for NINETY (90) DAYS, and (ii) the Program will perform substantially as described in the Documentation for NINETY (90) DAYS. These limited warranties commence on the day you obtain the Program and extend only to you, the original customer. Statements or representations which add to, expand, or modify these warranties are unauthorized by LICENSER and should not be relied upon by you. These limited warranties give you specific legal rights, and you may have other rights which vary from state to state.</p>
<p>DISCLAIMER: EXCEPT AS SPECIFIED ABOVE, THE LICENSER MAKES NO WARRANTIES OR REPRESENTATIONS, EXPRESS OR IMPLIED, ORAL OR WRITTEN, REGARDING THE PROGRAM, MEDIA, OR DOCUMENTATION AND HEREBY EXPRESSLY DISCLAIMS ALL OTHER EXPRESS AND IMPLIED WARRANTIES, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. LICENSER DOES NOT WARRANT THE PROGRAM WILL MEET YOUR REQUIREMENTS, OR THAT ITS OPERATION WILL BE UNINTERRUPTED OR ERROR-FREE.</p>
<p>EXCLUSIVE REMEDY: Your sole and exclusive remedy in the event of a breach of the limited warranty set forth above is limited to either repair or replacement of the Program or the Documentation by LICENSER or refund of your money, at the Licenser's sole discretion. To obtain warranty service, however, you must return the nonconforming item, with proof of the date you obtained it, to LICENSER no later than TEN (10) days after the expiration of the applicable limited warranty period. If LICENSER determines that the particular item has been damaged by accident, abuse, misuse, or misapplication,n or has been modified without the written permission of LICENSER, or if any.</p>
<p>The LICENSER label or serial number has been removed or defaced, the limited warranties above do not apply, and you accept full responsibility for the product.</p>
<p>LIMITATION OF LIABILITY: LICENSER AND ALL PARTIES INVOLVED IN THE CREATION OR DELIVERY OF THE PROGRAM OR DOCUMENTATION TO YOU SHALL HAVE NO LIABILITY TO YOU OR ANY THIRD PARTY FOR SPECIAL, INCIDENTAL, INDIRECT, EXEMPLARY, AND CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, LOSS OF PROFITS, GOODWILL OR SAVINGS, DOWNTIME, DAMAGE TO OR REPLACEMENT OF EQUIPMENT AND PROPERTY OR RECOVERY OR REPLACEMENT OF PROGRAMS OR DATA) ARISING FROM CLAIMS BASED IN WARRANTY, CONTRACT, TORT (INCLUDING NEGLIGENCE), STRICT TORT OR OTHERWISE, EVEN IF LICENSER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH CLAIM OF DAMAGE. LICENSER'S LIABILITY FOR DIRECT DAMAGES SHALL NOT EXCEED THE ACTUAL AMOUNT PAID FOR THE PRODUCT.</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to get data from two or more tables into one spreadsheet.]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2808]]></link>
<guid isPermaLink="false"><![CDATA[d0010a6f34908640a4a6da2389772a78]]></guid>
<pubDate><![CDATA[Thu, 28 Jul 2016 17:15:50 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to get data from two or more tables into one spreadsheet.
In this example, we will show you how to get data from two or more tables into a single spreadsheet.
Open QXL. The first step in configuring the application is to click on the settings icon f...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to get data from two or more tables into one spreadsheet.</span></h2>
<p><span style="font-family: Arial,Helvetica,sans-serif;">In this example, we will show you how to get data from two or more tables into a single spreadsheet.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Open QXL. The first step in configuring the application is to click on the settings icon for QXL options details. </span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step1.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Now we change the exported file configuration from the General tab Export In Single File option.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step2.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Now we will configure the table export option from the Table Settings tab.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">We will choose the Selected Table option &amp; select the table which you want to export.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">In this tutorial, I select three tables (i.e., Account, Bill, and BillingRate). After selecting the table, click on close to save the configuration.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step3.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Now we will export data by clicking on the Export data icon.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step4.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">QXL has started exporting tables.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step5.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Export completed.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step6.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">The exported file got opened. All three tables are exported into one spreadsheet. </span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSingleFile/step7.png" alt="" /></span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to change the filters and formatting]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2798]]></link>
<guid isPermaLink="false"><![CDATA[952c3ff98a6acdc36497d839e31aa57c]]></guid>
<pubDate><![CDATA[Fri, 08 Jul 2016 10:02:01 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to change the filters and formatting
Open the QXL Sample spreadsheet.
&nbsp;

&nbsp;
In this example, we will change the filter of the Balance column by clicking on the filter icon on the Balance column.

&nbsp;
We will use a number filter to ...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to change the filters and formatting</span></h2>
<p>Open the QXL Sample spreadsheet.</p>
<p>&nbsp;</p>
<p><img src="//support.flexquarters.com/esupport/newimages/filter/step1.png" alt="" /></p>
<p>&nbsp;</p>
<p>In this example, we will change the filter of the Balance column by clicking on the filter icon on the Balance column.</p>
<p><img src="//support.flexquarters.com/esupport/newimages/filter/step2.png" alt="" /></p>
<p>&nbsp;</p>
<p>We will use a number filter to show records whose balance is greater than or equal to 5000. To do this, we need to click on Number Filter &amp; Greater Than or Equal To.</p>
<p><img src="//support.flexquarters.com/esupport/newimages/filter/step3.png" alt="" /></p>
<p>Write the filter amount to 5000 &amp; click OK.</p>
<p><img src="//support.flexquarters.com/esupport/newimages/filter/step4.png" alt="" /></p>
<p>&nbsp;</p>
<p>A customer with a Balance of 5000 &amp; more is showing in the spreadsheet. In the same way, you can apply another filter as per your requirement.</p>
<p><img src="//support.flexquarters.com/esupport/newimages/filter/step5.png" alt="" /></p>
<p>Also, refer to the&nbsp;<a href="https://support.office.com/en-us/article/Guidelines-and-examples-for-sorting-and-filtering-data-by-color-b1bf3982-051d-49b8-8330-80e99c94365b">Guidelines and examples for sorting and filtering data by color</a> for more details.</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to create a report in Excel using QXL exported spreadsheet data]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2797]]></link>
<guid isPermaLink="false"><![CDATA[74378afe5e8b20910cf1f939e57f0480]]></guid>
<pubDate><![CDATA[Fri, 08 Jul 2016 09:58:34 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to create a report in Excel using QXL spreadsheet&nbsp;data
Problem Description:
I want to refresh my spreadsheet automatically from the QXL-exported spreadsheet. So, my spreadsheet data gets updated automatically using the QXL exported spreadsheet....]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to create a report in Excel using QXL spreadsheet&nbsp;data</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I want to refresh my spreadsheet automatically from the QXL-exported spreadsheet. So, my spreadsheet data gets updated automatically using the QXL exported spreadsheet. <br /><br />How to create an MS Excel spreadsheet that automatically updates data from QXL exported Excel files?</span>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p>Note: In recent versions of Microsoft Excel (including Excel 365), the Microsoft Query (Legacy) feature is hidden by default from the Get Data tab.<br /> Please refer to&nbsp;<a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3092" target="_blank">Troubleshooting - How to enable Microsoft Excel 365 - Legacy Microsoft Query</a>.<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please follow the steps below to create an MS Excel spreadsheet, which gets updated data automatically from the QXL exported spreadsheet data:<br /><br />1. Create a New MS Excel file.&nbsp;<br /><br />2. Navigate to the "Data" tab &amp; click on "Connections" to add a QXL exported spreadsheet connection. <br /><br /> </span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step1.png" alt="" /></span></p>
<p><br /><br />3. Add a connection by clicking on "Add."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step2.png" alt="" /></span></p>
<p><br /><br />Click on "Browse for More." &nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step3.png" alt="" /></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Navigate to the XL Exported sheet folder.&nbsp;</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step30.png" alt="" width="672" height="509" /></p>
<p>The Default QXL Export sheet folder path is "This PC" --&gt; "Documents" --&gt; "QXL" --&gt; YourQuickBooksCompanyName.<br /><br /></p>
<p>In this example, the QXL export sheet folder path is: "This PC" --&gt; "Documents" --&gt; "QXL" --&gt; Rock Castle Construction.</p>
<p><br />Select the QXL exported Excel file that you want to use as a source&nbsp;&amp; click on "Open."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step4.png" alt="" /></span></p>
<p><br /><br />Click "OK."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step5.png" alt="" /></span></p>
<p><br /><br />Connection added. Click the "close" button.<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step6.png" alt="" /></span></p>
<p><br /><br />4. Import Data from the added connection by clicking on "Existing Connection." <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step7.png" alt="" /></span></p>
<p><br /><br />Select the connection &amp; click on "Open."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step8.png" alt="" /></span></p>
<p><br /><br />Configure the Imported Data property &amp; click "OK."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step9.png" alt="" /></span></p>
<p><br /><br />5. Data Imported. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step10.png" alt="" /></span></p>
<p><br /><br />Now we are hiding a column that we don't want to use. You can hide column/columns by selecting a column/columns suitable, clicking on it, &amp; click on "Hide."<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step11.png" alt="" /></span></p>
<p><br /><br />In this example, I want to see only an Unpaid Invoice. So, I have filtered the IsPaid column. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step12.png" alt="" /></span></p>
<p><br /><br />I have added a new column, Due Date, which will get data from the DueDate field. We are converting this DueDate data to a date using the DATEVALUE function. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step13.png" alt="" /></span></p>
<p><br /><br />By converting it to a DateTime data type, the value displayed in Excel is numeric, and the correct value is shown only after formatting the cell. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step14.png" alt="" /></span></p>
<p><br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step15.png" alt="" /></span></p>
<p><br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step16.png" alt="" /></span></p>
<p><br /><br />Now we will hide the Original DueDate column &amp; add the Aging column, which we use for counting the Aging Days of the invoice payment due. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step17.png" alt="" /></span></p>
<p><br /><br />We can count aging using the DATEDIF function. <br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step18.png" alt="" /></span></p>
<p><br /><br />Now, let us sort the data according&nbsp;to the customer name &amp; use conditional formatting to show aging data.&nbsp;<br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step19.png" alt="" /></span></p>
<p><br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step20.png" alt="" /></span></p>
<p><br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step21.png" alt="" /></span></p>
<p><br /><br /></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step22.png" alt="" /></span></p>
<p><br /><br />After applying all the formatting, the data looks as follows.</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step23.png" alt="" /></span></p>
<p>&nbsp;</p>
<p>To refresh your Excel sheet report, use the QXL Application and click the "Export" button. Once your source is updated, you can restore your Excel sheet.</p>
<p><br />To refresh the Excel sheet report, click the "Refresh All" button from the menu Data--&gt;Refresh All menu.</p>
<p>&nbsp;<img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLSpread/step24.png" alt="" width="676" height="106" /></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] How to Change QXL Sample Report Data Source]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2796]]></link>
<guid isPermaLink="false"><![CDATA[e27a949795bbe863f31c3b79a2686770]]></guid>
<pubDate><![CDATA[Fri, 08 Jul 2016 09:28:32 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to Change QXL Sample Report Data Source
There are two ways to change the QXL Sample Report Data Source. 1. Automated. 2. Manual
1. Automated
Open the QXL Sample spreadsheet.

Click on the Change Data Source button.

Choose the QXL Export folder...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">How to Change QXL Sample Report Data Source</span></h2>
<p>There are two ways to change the QXL Sample Report Data Source. <br />1. Automated. <br />2. Manual</p>
<h3><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">1. Automated</span></h3>
<p>Open the QXL Sample spreadsheet.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step1.png" alt="" /></p>
<p>Click on the Change Data Source button.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step2.png" alt="" /></p>
<p>Choose the QXL Export folder you want to use &amp; click on the Apply &amp; Close button.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step3.png" alt="" /></p>
<p>Data in the sample spreadsheet will be refreshed using the provided QXL Export folder data.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step4.png" alt="" /></p>
<h3><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">2. Manual</span></h3>
<p>Open the QXL Sample spreadsheet and navigate to the Data tab.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step5.png" alt="" /></p>
<p>&nbsp;</p>
<p>Click on the Connections button.</p>
<p><img src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step6.png" alt="" /></p>
<p>&nbsp;</p>
<p>Select the workbook connection &amp; click on properties.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step7.png" alt="" /></p>
<p>&nbsp;</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step8.png" alt="" /></p>
<p>Navigate to the Definition tab &amp; click on the Browse button.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step9.png" alt="" /></p>
<p>Choose the QXL Export folder &amp; spreadsheet which you want to use &amp; click ok.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step10.png" alt="" /></p>
<p>&nbsp;</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step11.png" alt="" /></p>
<p>&nbsp;</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step12.png" alt="" /></p>
<p>To save the new report data source, click ok.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step13.png" alt="" /></p>
<p>Click on the close button to save the configuration.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Customer-Sample/step14.png" alt="" /></p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL Getting This feature is not enabled or not available in this version of QuickBooks]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2794]]></link>
<guid isPermaLink="false"><![CDATA[e465ae46b07058f4ab5e96b98f101756]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 15:10:06 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL Getting: This feature is not enabled or not available in this version of QuickBooks 
Problem Description:
I am trying to export data from QXL. After the export is completed. I got the "Export Completed. One or more tables were not...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL Getting: This feature is not enabled or not available in this version of QuickBooks </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in QXL. <br /><br />After reviewing the Output folder, I noticed some of the tables are not exported &amp; found the following error in the error logs from the export table folder:<br /><br />This feature is not enabled or not available in this version of QuickBooks.</span>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">This is not an error. This is only a warning and can be safely ignored. You will receive this warning when QXL tries to access a feature in QuickBooks that is not available in your installed QuickBooks version. You will not receive this warning if you exclude the tables that produce the warning(s) from the export list.</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL QuickBooks Error: Invalid Certificate]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2793]]></link>
<guid isPermaLink="false"><![CDATA[4191ef5f6c1576762869ac49281130c9]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 15:09:10 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL QuickBooks Error: Invalid Certificate
Problem Description:
I have installed QXL and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I click on the QXL export but...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL QuickBooks Error: Invalid Certificate</span></h2>
<h3><span style="color: #0066cc; font-family: Arial,Helvetica,sans-serif;">Problem Description:</span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I have installed QXL and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I click on the QXL export button, I get a message from QuickBooks saying <strong>The certificate is invalid</strong>.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step1.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step8.png" alt="" /></span></p>
<h3><span style="color: #0066cc; font-family: Arial,Helvetica,sans-serif;">Solution:</span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please download &amp; install QXL's latest version &amp; test again.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">If the above does not resolve the issue, then please follow the steps below:</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please make sure you are connected to the internet from the machine to validate the certificate.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please check the property at c:\Windows\SysWOW64\qxlfqqb32.dll or c:\Windows\System32\qxlfqqb32.dll from the Digital Signature tab.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step2.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please click on <strong>Details</strong> to check the certificate.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step3.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please click on Install Certificate to install a&nbsp;<span id="f6bd252a-9e3b-4879-90de-1cb67f91f281" class="GINGER_SOFTWARE_mark">certificate</span>.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step4.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please follow the&nbsp;<span id="687732a5-7b5e-4eb7-b018-696d435a439e" class="GINGER_SOFTWARE_mark">installation steps</span>&nbsp;below.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step5.png" alt="" /></span></p>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step6.png" alt="" /></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please finish the installation by clicking on <strong>Finish</strong>. After installation, please <strong>restart</strong> the machine and test the connection.</span></p>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-Cert/step7.png" alt="" /></span></p>
<p>&nbsp;</p>
<p><strong>If the above solution does not work, then you need to manually install the certificate by using the link below:</strong></p>
<p><a href="http://www.symantec.com/business/support//index?page=content&amp;pmv=print&amp;impressions=&amp;viewlocale=&amp;id=TECH218029" target="_blank">http://www.symantec.com/business/support//index?page=content&amp;pmv=print&amp;impressions=&amp;viewlocale=&amp;id=TECH218029</a></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">&nbsp;</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 80040408 QuickBooks is running on this machine and is logged in as Admin to the Company file -Unable to connect to QuickBooks]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2792]]></link>
<guid isPermaLink="false"><![CDATA[1264a061d82a2edae1574b07249800d6]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 15:04:38 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 80040408 Error 
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below. Unable to connect to QuickBooks. Ensure that QuickBooks is installed and running...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 80040408 Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below. <br /><br />Unable to connect to QuickBooks. Ensure that QuickBooks is installed and running on this machine and that it is logged in as an Administrator to the Company file.<br /><br /> Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 80040408, Could not start QuickBooks. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-80040408/step1.png" alt="" border="0" /> </span></p>
<p>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial, Helvetica, sans-serif;">The error message above indicates that QuickBooks is not running.</span></p>
<p>&nbsp;</p>
<p>Step 1: Launch QuickBooks and Open the Company File</p>
<p>Open QuickBooks Desktop.</p>
<p>&nbsp;</p>
<p>Log in to the desired company file using the QuickBooks user "Admin".</p>
<p>&nbsp;</p>
<p>Log in to QuickBooks as the "admin" user to authorize the connection to the QuickBooks company file.</p>
<p>This is a one-time activity for each new application you want to connect to QuickBooks Data.</p>
<p>&nbsp;</p>
<p>Step 2: Test connection using QXL</p>
<p>Go to Start &rarr;&nbsp;QXL</p>
<p>Click the Export/Run button.</p>
<p>&nbsp;</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 8004041a,80040420,8004041d - QuickBooks is running and is logged in as admin]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2791]]></link>
<guid isPermaLink="false"><![CDATA[ad82140cafe816c41a9c9974e9240b7a]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 15:01:59 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 8004041a,80040420,8004041d Error 
Problem Description 1:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. Unable to connect to QuickBooks. Make sure QuickBooks ru...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 8004041a,80040420,8004041d Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description 1:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine and is logged in as Admin to the Company file. Make certain the QuickBooks Company file is in Single User Mode and try again. Or try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File-&gt;Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.<br /><br />Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 8004041a. This application does not have permission to access this QuickBooks company data file. The QuickBooks administrator can grant access permission through the Integrated Application preferences.<br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004041a/step1.png" alt="" border="0" /><br /><br /> </span></p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description 2:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. Solution: Try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File-&gt;Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.<br /><br />Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 80040420, The QuickBooks user has denied access. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004041a/step2.png" alt="" border="0" /> </span></p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description 3:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine and is logged in as Admin to the Company file. Make certain the QuickBooks Company file is in Single User Mode and try again. Or try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File-&gt;Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.<br /><br />Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 8004041d. This application cannot log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for an automatic login through the Integrated Application preferences. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004041a/step3.png" alt="" border="0" /> </span></p>
<p>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please make sure QuickBooks runs on this machine, and the user is logged in as Admin to the Company file. Also, make certain the QuickBooks Company file is in Single User Mode and try to connect again. <br /><br />It should pop up the Data Access Certificate on QuickBooks. Please accept the Certificate &amp; test again. <br /><br />If the above does not resolve the issue, please start QuickBooks, log in as Admin, and switch QuickBooks to single-user mode.<br /><br />Try removing "Flexquarters QODBC" from the Integration Application in QuickBooks.<br /><br />Please refer to how<a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2482/0/how-to-remove-qodbc-related-certificates-from-integrated-application-under-quickbooks" target="_blank">&nbsp;to remove QODBC Related Certificates from Integrated Application Under QuickBooks</a>.<br /><br />After performing the above steps, try to connect again.</span></p>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Tags: Unable to connect to QuickBooks using QXL</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 8004040a - Company file is different - Unable to connect to QuickBooks. You have QuickBooks open to a particular company file tha...]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2790]]></link>
<guid isPermaLink="false"><![CDATA[ec0bfd000f253eff3acb1043e1c06979]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 14:59:40 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 8004040a Error 
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. Unable to connect to QuickBooks. You have QuickBooks open to a particular co...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 8004040a Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. You have QuickBooks open to a particular company file that is different than the one you had originally set up in QXL, or you have QuickBooks available to a particular company file that is using a different path than the one you had initially set up in QXL.<br /><br />Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 8004040a, A QuickBooks company data file is already open and different from the one requested, or there are multiple company files open. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step1.png" alt="" border="0" /> </span></p>
<p>&nbsp;</p>
<p>Company files Open in QuickBooks. You can find the QuickBooks company file path via QuickBooks UI. Press the F2 key to see the file information.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step2.png" alt="" width="1055" height="631" /></p>
<p>The company file path is set up in QXL.</p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step3.png" alt="" width="655" height="481" /></p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">The above error message says the company files currently open in QuickBooks are different from the path of the company file setup in your QXL. Please verify the company file path on QXL and QuickBooks. These two paths should be the same.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step3.png" alt="" width="655" height="481" /><br /></span></p>
<p><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step7.png" alt="" width="1441" height="802" /></p>
<p>&nbsp;</p>
<p><strong>OR</strong> &nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">You can select "Currently Opened Company File" as the QuickBooks Source and test again.</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-8004040a/step4.png" alt="" width="659" height="479" /></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Tags: How to connect to QuickBooks using QXL</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 80040417 - Make sure QuickBooks is running - Unable to connect to QuickBooks]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2789]]></link>
<guid isPermaLink="false"><![CDATA[b19aa25ff58940d974234b48391b9549]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 14:57:23 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 80040417 Error 
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine, ...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 80040417 Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine, and the Company file is loaded.<br /><br />Error Occurred: ERROR [00000] [QODBC] Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 80040417. If the QuickBooks company data file is not open, a call to the "BeginSession" method must include the name of the data file. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-80040417/step1.png" alt="" border="0" /> </span></p>
<p>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please navigate to QuickBooks &amp; make sure that QuickBooks is running &amp; the company file is loaded in QuickBooks. If the QuickBooks company file is not loaded in QuickBooks, you will get this error. </span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL 80040414 Popup window(s) in the QuickBooks Must be closed - Unable to connect to QuickBooks]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2788]]></link>
<guid isPermaLink="false"><![CDATA[d210cf373cf002a04ec72ee395f66306]]></guid>
<pubDate><![CDATA[Tue, 28 Jun 2016 14:54:07 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL 80040414 Modal Popup Error 
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. Unable to connect to QuickBooks. Popup window(s) in the QuickBoo...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL 80040414 Modal Popup Error </span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message. <br /><br />Unable to connect to QuickBooks. Popup window(s) in the QuickBooks application MUST be closed before QXL can communicate with QuickBooks.<br /><br />Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 80040414. A modal dialog box is showing in the QuickBooks user interface. Your application cannot access QuickBooks until the user dismisses the dialog box. <br /><br /><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL-80040414/step1.png" alt="" border="0" /> </span></p>
<p>&nbsp;</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Please navigate to QuickBooks &amp; make sure that there is no modal pop-up window open in QuickBooks. If any modal pop-up window is available in QuickBooks, you will get an "Error = 80040414; A modal dialog box is showing in the QuickBooks user interface....". QuickBooks says that a modal connection is active for this part of QuickBooks, and you need to wait. <br /><br />It would be best if you closed this modal popup window in QuickBooks &amp; export data using QXL. <br /><br />QXL does not have control over the modal pop-up window in QuickBooks. QXL cannot suppress or bypass this type of dialogue. It would be best if you disabled the modal pop-up from QuickBooks.</span></p>
<p>&nbsp;</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Tags: Unable to connect to QuickBooks using QXL</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] QXL options and settings]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2786]]></link>
<guid isPermaLink="false"><![CDATA[fb3f76858cb38e5b7fd113e0bc1c0721]]></guid>
<pubDate><![CDATA[Mon, 27 Jun 2016 15:30:33 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL options and settings
QXL options and settings/Configuration:
The first step in configuring the application is to click on the settings icon for details on QXL options.
&nbsp;
General Tab:From the General Tab, you can change the following:1. Output...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">QXL options and settings</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL options and settings/Configuration:</span></h3>
<p>The first step in configuring the application is to click on the settings icon for details on QXL options.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step1.png" alt="" /></p>
<p><strong>General Tab:</strong><br /><br />From the General Tab, you can change the following:<br /><br />1. Output Folder: - You can change the path of the output folder by clicking the "Browse" button.<br /><br />2. Format: You can format the exported file to XLSX, XLS, CSV, or SQL Server.<br /><br />3. SQL / ODBC Connection String: - You can set the SQL / ODBC Connection String.<br /><br /> <strong>Note:</strong>&nbsp;A QXL Professional&nbsp;Edition license is required to export data to SQL Server / ODBC Data Source.<br /><br />4. Export In: - You can change the export option to Separate File or Single File.<br /><br />5. Output file(s) read-only: - You can protect exported file for unwanted write. This option will set exported files to read-only if you select "Yes."<br /><br />6. QuickBooks Source: - You can set up a QuickBooks company file path using the "Browse" button in QXL or the Currently Opened Company File.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step2.png" alt="" /></p>
<p><strong>Advanced Tab:</strong><br /><br />From the Advanced Tab, you can change Optimizer &amp; Messages settings as follows:</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step3.png" alt="" /></p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Optimizer Setup:</span></h4>
<p><strong>What is an Optimizer file?</strong></p>
<p>When you access any table, QXL will gather data from QuickBooks and store it in an Optimizer file. When you turn on the Optimizer, QXL will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries. Next time you query the same table, QXL will request differential records that are added, modified, and deleted from QuickBooks and sync them to the Optimizer file. This way, QXL will only have to get the differential records instead of the entire data set from QuickBooks. As a result, you will notice a performance gain compared to working without an optimizer.</p>
<p>Initial data optimization has been benchmarked at up to a 30% reduction in load time. The first time you access a given QuickBooks table, QXL, by default, optimizes access to that data, so the next time you need data from that table, it will be much faster.&nbsp;</p>
<p><strong>The optimizer</strong> brings some data to a local cache to increase query retrieval performance. Check to activate the optimizer.</p>
<p><strong>Optimizer Database Folder</strong> specifies where the local data store will be saved on disk. The default location %AppData%\QXL - QuickBooks Data Export Data Made Easy\Optimizer is under your Windows login account name under your Documents and Settings folder. The data will be stored in a file in this folder with a name similar to the company file name with a .opt extension. If you store that data somewhere other than the default, click the browse button and select the destination folder. You can change the path of the Optimizer folder by clicking the "Browse" button. With very large company files, we suggest running synchronization after hours.<br /><br /><strong>Reset Optimizer File(s)</strong>: This button is used to rebuild the optimized data from scratch. It is useful when starting with a new company if you do not want to synchronize the tables as you first encounter them and ensure that your data is 100% current.</p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Messages:</span></h4>
<p>Messages allow you to review message logs from QXL regarding errors and issues communicating with QuickBooks, clear these messages, and review messages produced by the QuickBooks qbXML SDK interface. <br /><br /><strong>When selected, the Display Driver Status Panel</strong> shows precisely what QXL is doing when accessing the QuickBooks data and provides a good assessment of speed using optimized and non-optimized data.</p>
<h4><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Export Options:</span></h4>
<p><strong>Create a table from the sheet</strong> option will create the table from the spreadsheet (for Excel 2010 or above in [xlsx] format only)</p>
<p><strong>The table Styles</strong> option is used for formatting Excel cells by choosing predefined styles (for Excel 2010 or above in [xlsx] format only. You can select a predefined type using the drop-down.</p>
<p><strong>Header Color</strong> option used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only). You can change the header color using the "Click to change header color" button.</p>
<p>&nbsp;</p>
<p id="QXLFAQOptionTableSettings"><strong>Table Settings Tab:</strong><br /><br />From the Table Settings Tab, you can change table options as follows:<br /><br />1. ALL tables: - This option will export all tables to the output folder. <br /><br />2. Selected Table: - This option will export selected tables to the output folder. <br /><br />3. Excluding Selected Table: This option will export all tables to the output folder we have not selected. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step4.png" alt="" /></p>
<p>In the Selected Table option, you can select the table by double-clicking on the table name. You can select all tables by clicking "All." You can clear the selection by clicking "None." You can invert table selection by clicking "Invert."</p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step5.png" alt="" /></p>
<p id="QXLFAQOptionCustomQuery"><strong>Custom Query Tab:</strong><br /><br />From the Custom Query Tab, you can write your custom query and fetch data according to your requirements.<br /><br />You need to write the table name in the Custom Table Name box &amp; write the query in the Custom Query box. After writing the table name &amp; query, click on the "Add or Update" button to add the question. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step6.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step7.png" alt="" /></p>
<p>You can update existing queries by double-clicking on the table name &amp; modify the query Custom Query box. After changing the query, click on the "Add or Update" button to update the query.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step8.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step9.png" alt="" /></p>
<p>You can remove the existing query by double-clicking on the table name &amp; click on the "Remove Selected" button to delete the query.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step10.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step11.png" alt="" /></p>
<p id="QXLFAQOptionReportsSettings"><strong>Report Setting Tab:</strong><br /><br />This tab allows you to add default reports to export. You can also add a custom report with different parameters. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step12.png" alt="" /></p>
<p>You can choose the default report from the drop-down list &amp; add the report for export.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step13.png" alt="" /></p>
<p>Select any report from the drop-down list &amp; click on the "Add or Update" button to add the report for export.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step14.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step15.png" alt="" /></p>
<p>If you want to add a Custom report using different parameters, you can add it by writing a report query &amp; output report name. <br /><br />You need to write the report name in the Output Table Name box &amp; write the query in the Report Query/Command box. After writing the report name &amp; query, click on the "Add or Update" button to add the report query. <br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step16.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step17.png" alt="" /></p>
<p>You can remove the existing report by double-clicking on the report name &amp; click on the "Remove Selected" button to delete the information.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step18.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step19.png" alt="" /></p>
<p>You can modify the existing report by double-clicking on the report name. Report name &amp; query/command will be shown in the Output Table Name box &amp; Report Query/Command box. You need to modify the report &amp; "Add or Update" button to update the report query. <br /><br />You can save all the above configurations by clicking the "Close" button &amp; you can discard changes by clicking the "X" button.<br /><br /> <span id="QXLFAQActivateDeactivate"></span> <strong>Activate/Deactivate Tab:</strong><br /><br />You can activate / Deactivate QXL by clicking on the "Activate / Deactivate" button.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step20.png" alt="" /></p>
<p><strong>Activation:</strong><br /><br />Activate is the online option for entering the CD Key issued to you upon purchasing the product to fully start QXL from the evaluation version to the entire Standard Edition purchased. Suppose you do not have internet access to activate the product from the machine you intend to use. In that case, you can use the manual option to generate an activation code from a device with internet access.<br /><br />Enter CD Key &amp; click on "Activate."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step21.png" alt="" /></p>
<p><strong>Manual Activation:</strong><br /><br />Enter the CDKey &amp; click on "Manual."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step22.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step23.png" alt="" /></p>
<p><strong>Deactivation:</strong><br /><br />Deactivate is the online method of deactivating a currently registered version of QXL to transfer the product to another machine. If internet access is unavailable from the registered device, you can use the manual option to generate a deactivation code from a machine with internet access. Using the latest version of QXL, credit for deactivation CDKEY is received instantly. In some cases, this process will take 24 to 48 hours before your CD Key account is credited with the deactivated license, and you can reactivate the license on a different machine.<br /><br />Enter the CDKey &amp; click on "Deactivate.<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step24.png" alt="" /></p>
<p><strong>Manual Deactivation:</strong><br /><br />Enter the CD Key &amp; click on "Manual."<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step25.png" alt="" /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step26.png" alt="" /></p>
<p><strong>Pro Edition Tab:</strong><br /><br />You can export QuickBooks Data into SQL Server &amp; ODBC database using the Pro Edition Tab. Please refer to the link below for more details.</p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2921" target="_blank">How to export to SQL Server - using SQL Default Driver &amp; ODBC</a></p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2920" target="_blank">How to export to MySQL</a></p>
<p><a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2919" target="_blank">How to export to MS Access</a></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step28.png" alt="" /></p>
<p><strong>Note:</strong><br />A QXL Professional&nbsp;Edition license is required to use this feature.</p>
<p><strong>About Tab:</strong><br />The&nbsp;<br />About screen shows the QXL version currently installed, whether it is an evaluation copy or a fully registered copy. The first letter in the serial number denotes the license type installed, and the 2nd &amp; 3rd digits are the QXL major version number. (The serial number may be required for upgrades, rebate offers, technical installation support, or the Help Desk system.)<br /><br /></p>
<p align="center">&nbsp;<img src="//support.flexquarters.com/esupport/newimages/QXLSetup/step27.png" alt="" /></p>
<p>Also, Refer: <br /><a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2938" target="_blank">QXL Command line arguments/parameters</a><br /><a href="https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2939" target="_blank">How to use QXL with scheduler for multiple company files</a></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] Troubleshooting - QXL is not Licensed for this QuickBooks Edition]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2783]]></link>
<guid isPermaLink="false"><![CDATA[ccd45007df44dd0f12098f486e7e8a0f]]></guid>
<pubDate><![CDATA[Fri, 27 May 2016 14:38:17 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[ Troubleshooting - QXL is not licensed for this QuickBooks Edition.
Problem Description:
I was able to use QXL earlier. Our company recently upgraded to QuickBooks Pro 2016 and can no longer connect with QXL, as it says QXL is not licensed for this Quic...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;"> Troubleshooting - QXL is not licensed for this QuickBooks Edition.</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I was able to use QXL earlier. Our company recently upgraded to QuickBooks Pro 2016 and can no longer connect with QXL, as it says QXL is not licensed for this QuickBooks edition. <br /><br /> <img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXLLicense/step1.png" alt="" border="0" /></span></p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solution:</span></span></h3>
<p><span style="font-family: Arial,Helvetica,sans-serif;">QXL licensing is not upward compatible, only backward, meaning you need a registered 2017 QXL License CDKEY to work with QuickBooks 2017. QXL 2017 license CDKEY will work with QuickBooks 2002- 2017 Pro and Higher. <br /><br /> For Example:<br /><br /> A QXL 2016 License will allow you to connect to QuickBooks 2002- 2016 Pro and Higher. But you can't use it with QuickBooks 2017.<br /><br /> To use QuickBooks 2017, you need to purchase a QuickBooks 2017 license CDKEY. Please get in touch with our sales team to <a href="http://qodbc.com/contact.htm" target="_blank">purchase/upgrade the license</a>.</span></p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-ALL] QXL Limited Use Software License &amp; QXL Limited Warranties and Limitation Of Liability]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2643]]></link>
<guid isPermaLink="false"><![CDATA[38181d991caac98be8fb2ecb8bd0f166]]></guid>
<pubDate><![CDATA[Wed, 08 Apr 2015 11:14:49 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[QXL Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) utiliz...]]></description>
<content:encoded><![CDATA[<p>QXL Limited Use Software License</p>
<p>LICENSE:</p>
<p>LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) utilizing a single operating system and (ii) make archival copies of the Program for backup purposes only for use with the same computer.</p>
<p>The serial number issued to you for this product indicates the highest version of QuickBooks Pro, Premier, or Enterprise with which the product can be used. If your registration code contains the year "10" at positions 2 and 3 of the serial number, it is registered to only work with QuickBooks 2010 and lower versions. If the registration code is set to "14," it will work with QuickBooks 2014, lower versions, and so on.</p>
<p>You agree to affix a label to the archival copies that contains the copyright notice printed on the original disk or tape from which the copy is made. LICENSER retains all rights to the Program not expressly granted in this agreement.<br />OWNERSHIP OF PROGRAMS AND COPIES: This license is not a sale of the original Program or any copies thereof. LICENSER retains the ownership of the program and all copies of the Program, regardless of the form in which the copies may exist. The Program and accompanying manual(s) ("Documentation") are copyrighted works of authorship and may contain valuable trade secrets and confidential information proprietary to LICENSER. The Program and the Documentation may not be copied, modified, or transferred without the express written permission of the LICENSER. You agree to exercise reasonable efforts to protect LICENSER'S proprietary interest in the Program and Documentation and maintain them in strict confidence.</p>
<p>USER RESTRICTIONS: You may physically transfer the Program from one computer to another, provided that it is operated only on one computer. You may not electronically transfer such a Program. You may not translate, modify, adapt, disassemble, decompile, or reverse engineer the Program. Versions of this product not designated as "Web Version" may not be used in a web service, time-sharing, or service bureau operation. You may not create derivative works based on such Program, Documentation, or any portions thereof.</p>
<p>TRANSFER: The Program is provided for use in your internal commercial business operations and must remain upon premises owned or leased by you. You may not rent, lease, sublicense, sell, assign, pledge, transfer, or otherwise dispose of the Program or the Documentation, on a temporary or permanent basis, without the prior written consent of LICENSER.</p>
<p>TERMINATION: This license is effective until terminated. This license will terminate automatically without notice from the LICENSER if you fail to comply with any license provision. Upon termination, you must cease all program use and return it, any copies thereof, including any archival copies, and the Documentation to LICENSER.</p>
<p>GENERAL: This license shall be governed and construed in accordance with the laws of the State of Nevada. It shall in no way affect the validity or enforceability of the agreement. If a provision of this agreement shall be held unenforceable, it shall be deemed severable from the remaining provisions. The headings and captions used in this agreement are for convenience only and are not to be considered in construing or interpreting this agreement.<br /><br /><strong>QXL Limited Warranties and Limitation Of Liability</strong></p>
<p>LIMITED WARRANTY: LICENSER grants you as the original user of the Program a limited warranty that (i) the media on which the Program is distributed and the Documentation will be free of material defects for NINETY (90) DAYS, and (ii) the Program will perform substantially in accordance with the material descriptions in the Documentation for NINETY (90) DAYS. These limited warranties commence on the day you obtain the Program and extend only to you, the original customer. Statements or representations which add to, expand, or modify these warranties are unauthorized by LICENSER and should not be relied upon by you. These limited warranties give you specific legal rights, and you may have other rights which vary from state to state.</p>
<p>DISCLAIMER: EXCEPT AS SPECIFIED ABOVE, THE LICENSER MAKES NO WARRANTIES OR REPRESENTATIONS, EXPRESS OR IMPLIED, ORAL OR WRITTEN, REGARDING THE PROGRAM, MEDIA, OR DOCUMENTATION AND HEREBY EXPRESSLY DISCLAIMS ALL OTHER EXPRESS AND IMPLIED WARRANTIES, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. LICENSER DOES NOT WARRANT THE PROGRAM WILL MEET YOUR REQUIREMENTS OR ITS OPERATION WILL BE UNINTERRUPTED OR ERROR-FREE.</p>
<p>EXCLUSIVE REMEDY: Your sole and exclusive remedy in the event of a breach of the limited warranty set forth above is limited to either repair or replacement of the Program or the Documentation by LICENSER or refund of your money, at the Licenser's sole discretion. To obtain warranty service, however, you must return the nonconforming item, with proof of the date you obtained it, to LICENSER no later than TEN (10) days after the expiration of the applicable limited warranty period. If LICENSER determines that the particular item has been damaged by accident, abuse, misuse, or misapplication, or has been modified without the written permission of LICENSER, or if any</p>
<p>The LICENSER label or serial number has been removed or defaced, the limited warranties above do not apply, and you accept full responsibility for the product.</p>
<p>LIMITATION OF LIABILITY: LICENSER AND ALL PARTIES INVOLVED IN THE CREATION OR DELIVERY OF THE PROGRAM OR DOCUMENTATION TO YOU SHALL HAVE NO LIABILITY TO YOU OR ANY THIRD PARTY FOR SPECIAL, INCIDENTAL, INDIRECT, EXEMPLARY, AND CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, LOSS OF PROFITS, GOODWILL OR SAVINGS, DOWNTIME, DAMAGE TO OR REPLACEMENT OF EQUIPMENT AND PROPERTY OR RECOVERY OR REPLACEMENT OF PROGRAMS OR DATA) ARISING FROM CLAIMS BASED IN WARRANTY, CONTRACT, TORT (INCLUDING NEGLIGENCE), STRICT TORT OR OTHERWISE, EVEN IF LICENSER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH CLAIM OF DAMAGE. THE LICENSER'S LIABILITY FOR DIRECT DAMAGES SHALL NOT EXCEED THE ACTUAL AMOUNT PAID FOR THE PRODUCT.</p>]]></content:encoded>
</item>
<item>
<title><![CDATA[[QXL-Desktop] How to use QXL]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2641]]></link>
<guid isPermaLink="false"><![CDATA[f21e255f89e0f258accbe4e984eef486]]></guid>
<pubDate><![CDATA[Thu, 26 Mar 2015 13:31:58 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[How to use QXL
Step 1 - Download QXL
 If you haven't already downloaded QXL, go to the download page&nbsp;now. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features, and other driver information...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial, Helvetica, sans-serif;">How to use QXL</span></h2>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Step 1 - Download QXL</span></h3>
<p><span style="font-family: Arial, Helvetica, sans-serif;"> If you haven't already downloaded QXL, go to the <a href="http://qxl1.com/qxl-for-quickbooks-desktop-downloads/">download page</a>&nbsp;now. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features, and other driver information. Save the self-extracting executable "QXLSetup.exe" in a temporary directory or your "My Documents" folder to extract the installation files.</span></p>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Step 2 - Running the Installer:</span></h3>
<p>Click on the Install program from within Windows to install the driver. Select the destination directory to install the QXL support files. Click "OK" to continue.</p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step1.png" alt="" /></p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step6.png" alt="" /></p>
<p>The QXL - QuickBooks Export Made Easy&reg; has been successfully installed on your computer. You can begin to use it because it will immediately run as a 30-day evaluation version.</p>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">Step 3 - Use QXL:</span></h3>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step7.png" alt="" /></p>
<p>After installation, you may notice the following icons on the desktop.</p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step28.png" alt="" /></p>
<p>QXL &ndash; Silent Mode - It uses the last saved settings of QXL and automatically starts executing the data export with no user interface.QXL &ndash; Direct Mode - It uses the previously saved settings of QXL and automatically starts executing the data export with the user interface, i.e., displaying progress data export.QXL &ndash; Manual execution of Data Export/Update Settings/Activation-Deactivation. You can select tables and destinations to which the files should be exported. Start QuickBooks, log in to your company file, switch back to QXL, and click Export Data.</p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step8.png" alt="" /></p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step9.png" alt="" /></p>
<p>After the export is completed. The exported data folder will open.</p>
<p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="//support.flexquarters.com/esupport/newimages/QXL/step10.png" alt="" /></p>
<p>Exported data is placed at the below location by default: C:\Users\User Name\Documents\QXL\</p>
<h3><span style="color: #0066cc; font-family: Arial, Helvetica, sans-serif;">QXL Features:</span></h3>
<p>1. Export QuickBooks Data to XML format via QODBC.</p>
<p>2. Export QuickBooks Data to CSV format via QODBC.</p>
<p>3. Ability to choose export file(s) location.</p>
<p>4. Ability to export to Separate files or a single file.</p>
<p>5. Ability to export all selected, tabled, or excluded tables.</p>
<p>6. Ability to save your default settings from Options.</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Also, Refer:</span><br /> <a href="http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2786" target="_blank">QXL options and settings</a></p>]]></content:encoded>
</item>
</channel>
</rss>