Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - Reporting Ship To Addresses
Posted by Jack - QODBC Support on 13 July 2016 02:31 PM

Troubleshooting - Reporting Ship To Addresses

Problem Description:

Has anyone run a report that will pull all the detail for a range of invoices? In particular, I'm looking to run a report that shows the ship to addresses for particular products over a date range. 

Solution:

Please use below query to get the ship to addresses for particular products over a date range.

select InvoiceLineItemRefFullName, RefNumber, TxnDate, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,ShipAddressAddr5, ShipAddressCity, ShipAddressState, ShipAddressPostalCode,ShipAddressNote from InvoiceLine where TxnDate >= {d'2009-01-01'} and TxnDate <= {d'2009-03-01'} and (InvoiceLineItemRefFullName = 'Cabinets' or InvoiceLineItemRefFullName = 'Window') order by InvoiceLineItemRefFullName, RefNumber, TxnDate

(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).