While running the query "sp_report InventoryStockStatusByItem" I seem to be unable to retrieve any inventory stock status for Inventory Assembly items. They are available though the QuickBooks report, are assembly items not supported through QODBC?

If not, is this planned for a new version or is a quick workaround possible?

Thanks,
Tom

I just ran:

sp_report InventoryStockStatusByItem show Text, Blank, ItemDesc, ItemVendor,
ReorderPoint, QuantityOnHand, QuantityOnSalesOrder, QuantityAvailable,
SuggestedReorder, QuantityOnOrder, EarliestReceiptDate, SalesPerWeek
parameters DateMacro = 'ThisMonthToDate'

and the results matched my QuickBooks Inventory Stock Status by Item report on the screen, but without showing any of the Build Assemblies on sales order or anything. You will need to run a seperate query using something like this:

SELECT ItemInventoryAssemblyRefFullName as "Item Description",
QuantityOnHand as "On Hand",
QuantityOnSalesOrder as "On Sales Order"
FROM BuildAssembly where TxnDateMacro='ThisMonthToDate'