Is there a way of printing items associated with the mix & match tables. I tried to use crystal reports, but I couldn't find the correct tables. Does any one know how this can be done?
LISTING OF ITEM IN MIX N MATCH TABLE
Apr 05, 2006
1 Replies
You can run this query from SO Admin. If you have several Discount schemes and want to see all of them just remove the WHERE clause from the statement.
SELECT QuantityDiscount.Description, ItemLookupCode, Item.Description FROM Item INNER JOIN QuantityDiscount ON Item.QuantityDiscountID = QuantityDiscount.ID WHERE QuantityDiscount.Description = 'XXX'
XXX is the Description of the Quantity Discount.
Rob
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required