Report: Show Loaded Price Lists

The following query can be entered into the Administration > Run SQL Query… dialog to show which price types are loaded for each price sheet (and counts).

select psn.PriceSheetNm, ps.PriceSheetNumber, p.PriceTypeCD, Count(*) Cnt  
from PriceSheet ps 
  join PriceSheetName psn on ps.PriceSheetNmID = psn.PriceSheetNmID  
  join Price p on p.PriceSheetNumber = ps.PriceSheetNumber  
group by psn.PriceSheetNm, ps.PriceSheetNumber, p.PriceTypeCD   
order by psn.PriceSheetNm, p.PriceTypeCD
Revised: 2011-10-20