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
Report of items on a disocunt scheme
Dec 05, 2007
2 Replies
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,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required