How do I access the QuickBooks' "Open Sales Order by Item" report please?

Actually we don't have a sp_report for the QuickBooks "Open Sales Order by Item" report, however I've managed to extract similiar data using QODBC.

For example, when using the Rock Castle Construction QuickBooks 2006 sample company file: sample_product-based business.qbw the report looks like this:

By using the following select statement:

SELECT SalesOrderLIneItemRefFullName as Type, TxnDate as Date,
DueDate, RefNumber as Num, CustomerRefFullName as Name,
SalesOrderLineQuantity as Qty, SalesOrderLineInvoiced as Invoiced,
SalesOrderLineAmount as Amount FROM SalesOrderLine
where IsFullyInvoiced = FALSE
and SalesOrderLineInvoiced < SalesOrderLineQuantity

what is shown in the above report appears using QODBC:

This can also be made must faster by limiting the date range like this:

Make sure you are running QODBC v6.00.00.155 or later.

Try this instead:

SELECT SalesOrderLIneItemRefFullName as Type, TxnDate as Date,
DueDate, RefNumber as Num, CustomerRefFullName as Name,
SalesOrderLineQuantity as Qty, SalesOrderLineInvoiced as Invoiced,
SalesOrderLineAmount as Amount FROM SalesOrderLine unoptimized
where IsFullyInvoiced = FALSE
and SalesOrderLineInvoiced < SalesOrderLineQuantity

Well, this will work based on the actual current system date (not the QuickBooks date):

SELECT SalesOrderLIneItemRefFullName as Type, TxnDate as Date, DueDate, RefNumber as Num, CustomerRefFullName as Name, SalesOrderLineQuantity as Qty, SalesOrderLineInvoiced as
Invoiced, SalesOrderLineAmount as Amount, ClassRefFullName as Class, Memo,
({fn CURDATE()}-TxnDate) as Aging FROM SalesOrderLine unoptimized
where IsFullyInvoiced = FALSE and SalesOrderLineInvoiced < SalesOrderLineQuantity

I've not heard or seen anything about adding sp_reports for Open Sales Orders by Customer or Open Sales Orders by Item.

See also: Open sales orders by Item