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 specific products over a date range. 

Solution:

Please use the 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