I am trying to customize the Inventory Stock Status by Item report - which I am doing in Crystal.

How do I get the field, "For Assemblies" - which I think is the total, by item, of build assembly orders one can enter into Quickbooks.

Thanks

Victor

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 sub-report using something like this:

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

I am having trouble finding the documentation on your web site for the 'buildassemblies' file - do you have a link?

Thanks, Vic

QODBC is self documenting these days. Just run:

sp_columns BuildAssembly

and

sp_columns BuildAssemblyComponentItemLine

See: Where are the schema rules for using QODBC? How do I use sp_columns?  for more.