Report of items on a disocunt scheme

Hi, Does anyone have or no of a report which shows all your items and what discount scheme is applied to each item?

Many thanks Matt

Reply to
matty102
Loading thread data ...

Hi Matt - don't have it on a report but as a saved query....

select itemlookupcode, item.description, quantitydiscount.description from item inner join quantitydiscount on item.quantitydiscountid = quantitydiscount.id order by itemlookupcode

If you are not familiar with query> Hi,

Reply to
convoluted

Reply to
matty102

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.