Can you tell me what the SQL behind the sp_report SalesbyItemDetail is? I would need to pull custom fields in that format, but they are not supported by the stored procedure.

Thanks, Michael

And see all the columns available in a given SP_REPORT by using sp_reportcolumns reportname

As well as SP_PARAMETERS to list all the parameters available for a given SP_REPORT. The VALUES column lists available values that can be used with the parameter.

But as far as sales are concerned, I can get a better view of items (stock parts) sold by using the QODBC tables themselves, for example:

SELECT "InvoiceLine"."TxnDate" as Date, "InvoiceLine"."RefNumber" as Num, "Customer"."FullName" as Name, 
"InvoiceLine"."InvoiceLineDesc" as Memo, "InvoiceLine"."InvoiceLineQuantity" as Qty,
"InvoiceLine"."InvoiceLineItemRefFullName" as Item,
"InvoiceLine"."InvoiceLineRate" as Rate, "ItemInventory"."PurchaseCost" as Cost,
"ItemInventory"."AverageCost" as "Average Cost",
("InvoiceLine"."InvoiceLineQuantity" * "ItemInventory"."AverageCost") as Amount
FROM   "Customer" "Customer","InvoiceLine" "InvoiceLine", "ItemInventory" "ItemInventory"
WHERE  ("InvoiceLine"."CustomerRefListID"="Customer"."ListID")
AND  ("InvoiceLine"."InvoiceLineItemRefListID" = "ItemInventory"."ListID")
ORDER BY "InvoiceLine"."TxnDate"

Thank you Tom, but the example doesn't apply in my case. I am basically looking for adding a CustomField to the result of a 'SalesbyItemDetail' report. The current report syntax is:

SELECT * FROM OPENQUERY (Quickbooks, 'sp_report SalesByItemDetail show Account, TxnType, Date, RefNumber, Item, Memo, Name, Quantity, UnitPrice, Amount, OpenBalance, ModifiedTime parameters DateMacro = "ThisMonth"') where "Account" LIKE '%Maintenance%' ORDER BY Date

As reports don't support custom fields, how can I retrieve the same result set plus custom fields?