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
Copied!