Knowledgebase
[QXL-ALL] How to export QuickBooks Data daily for current date filter using QXL.
Posted by Jack - QODBC Support on 09 May 2017 09:27 AM

How to export QuickBooks Data daily for the current date filter using QXL.

Problem Description:

I am using QXL & I want to create a report that will pull the following items.

Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to City, Ship to State, Ship to Zip, PO#, Item, Qty.

How to export QuickBooks Data daily for the current date filter using QXL?

Solution:

You can export QuickBooks Data daily for your desired date using QXL.

The first step is Start QXL. Click the Options/Settings icon.

Under the "General" tab, Click "Comma Separated Value (CSV)."

 

To add desired date filter, You need to create a custom query & add it to the export list.

From Custom Query Tab you can write your custom query and fetch data according to your requirement.

You need to write the table name in the Custom Table Name box & write the query in the Custom Query box. After writing the table name & query, click on the "Add or Update" button to add the query.

For Example:

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

If you wish to pull the last 7 days' data, you may use the query below.

For Example:

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 >= ({fn CURDATE()}-7) and TxnDate <= ({fn CURDATE()})

Click "Close" to save the configuration & You should be back to QXL Main screen.

The data will be exported by clicking on the Export icon from QXL Main Screen.

The data is exported into a CSV file.

Also Refer: How to use QXL with Scheduler.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).