Report: Show Loaded Prices for a Price Sheet

The following query can be entered into the Administration > Run SQL Query… dialog to show all of the loaded prices for a selected price sheet. Change the ‘enter price sheet number’ with the desired price sheet number on the second to last line (keeping the single quotes).

SELECT psn.PriceSheetNm, ps.PriceSheetNumber, b.BrandID, b.BrandNm, p.PID, pb.PartNumber,
    p.PriceTypeCD, p.Amount, p.CurrencyCD
FROM PriceSheet ps
    INNER JOIN PriceSheetName psn ON ps.PriceSheetNmID = psn.PriceSheetNmID
    INNER JOIN Price p ON ps.PriceSheetNumber = p.PriceSheetNumber
    INNER JOIN PartBrand pb ON p.BrandID = pb.BrandID AND p.PID = pb.PID
    INNER JOIN Brand b  ON pb.BrandID = b.BrandID
WHERE ps.PriceSheetNumber = '**enter price sheet number**'
ORDER BY b.BrandNm, pb.PartSort;