report.sql

SELECT *
FROM (
         SELECT IT.ID,
                ROW_NUMBER()
                        OVER (
                            PARTITION BY
                            IT.VendorId,
                            IT.ItemNumber,
                            I.StoreID
                            ORDER BY I.InvoiceDate DESC, IT.InvoiceID DESC
                            ) rn,
                I.InvoiceDate,
                ItemNumber,
                It.VendorId,
                I.StoreID
         FROM Item IT
                  INNER JOIN Invoice I ON InvoiceID = I.ID
         WHERE ItemNumber = 'FB100G-1'
     ) t1
WHERE rn = 1