What would be either a unique field or a unique combination of fields in the report SalesbyItemDetail (with reference to data rows)? I am loading report results into a SQL table and want to define a key column for updating purposes. Thanks!

This is a report, not a table export, but for:

sp_report SalesByItemDetail show TxnID, RowNumber, TxnType, Date, RefNumber,
Memo, Name, Item, ItemDesc, Quantity, UnitPrice, Amount, RunningBalance
parameters DateMacro = 'All' where RowType='DataRow'

RowNumber would make a good unique key and TxnID and RowNumber would make a good lookup.

Hi Tom, not sure if this will work, though. I understand that one invoice, for instance, is considered one transaction. That means all line items on this invoice will have the same TxnID, correct? I might use a combination of TxnID and Item, if there is no identifier per line item that can be pulled through the report.

I had hoped that TxnID was the InvoiceLineTxnLineID, but you're right, it's the TxnID of the Invoice. Item, won't work either as items can be invoiced within an invoice multiple times, so I changed my previous answer to RowNumber

We have asked Intuit for a unique key in all their reports.

Tom, RowNumber won't work either. It identifies a unique line item in the report itself, but I am looking for an identifier of the underlying record that it's pulling. As running an update on a report (e.g. with "ThisMonthToDate") will yield different row numbers each time,  I can't use it to update the fields in the target SQL table. Sorry if I haven't communicated this correctly.

An alternative I could think of is executing the SQL underlying the sp_report and including columns that don't come standard with the report. Is it possible to do that and can you share the content of the stored procedure?