This is close to what I want.  Let me confirm that this report shows qty to ship only if it has been invoiced, right?

I would like to get the qty to pick, regardless if it has been invoiced or not.  When entering a sales order inside of quickbooks, if you were to print the pick list for an order of 10 widgets.  But only 3 are available to ship, the pick list prints 3 "To Pick" quantity.  This is done before invoicing.

How can I get that quantity of 3 exported out, without invoicing?

All you need to add is a link to the ItemInventory table to pick up the quantity on hand and compare it with the ordered quantity ordered and invoiced to date (invoiced or not) and call the column "Qty to Pick".

Something along the lines of:

SELECT SalesOrderLine.SalesOrderLIneItemRefFullName as Type, SalesOrderLine.TxnDate as Date,
SalesOrderLine.DueDate, SalesOrderLine.RefNumber as Num, SalesOrderLine.CustomerRefFullName as Name,
SalesOrderLine.SalesOrderLineQuantity as "Qty Ordered", SalesOrderLine.SalesOrderLineInvoiced as "Qty Invoiced",
(SalesOrderLine.SalesOrderLineQuantity - SalesOrderLine.SalesOrderLineInvoiced) as "Qty to Pick",
ItemInventory.QuantityOnHand as "Qty Available", ItemInventory.QuantityOnOrder as "Qty on Back Order"
FROM SalesOrderLine, ItemInventory
where SalesOrderLine.SalesOrderLineItemRefListID = ItemInventory.ListID
and SalesOrderLine.IsFullyInvoiced = FALSE
and SalesOrderLine.SalesOrderLineInvoiced < SalesOrderLine.SalesOrderLineQuantity

Thank you very much.

Is it possible to make it so that the Qty on hand is lowered for subsequent transactions?  For example

Sales Order 1 - Item ABC - Qty ordered 5 - Qty Invoiced 0 - Qty on hand 5 - Qty to pick 5 - Qty on backorder 0

Sales Order 2 - Item ABC - Qty ordered 5 - Qty Invoiced 0 - Qty on hand 0 - Qty to pick 0 - Qty on backorder 5

I know that backorders are not tracked until invoiced, so its not that important for now.

What I would like is a sort of allocation of inventory to the sales order.  Can this be done?