From: Jeff R. <je...@jr...> - 2007-04-26 20:24:52
|
Hi All I'm trying to get a set of data out in the form of a price list but I'm having trouble and I hope someone can help. I have five pricegroups, COD, Late, Regular, Established and Preferred. The 'sell price' of the item is equivalent to 'regular'. Late is plus 10% and COD is plus 15% while Established is - 10% and Preferred is -15%. Each item in the database has five prices assigned to it relating to these groups. I have a whole series of groups such as Telephone, Copier, POS, Industrial. I can print a price list of all the items in group Telephone through 'goods and services/reports/all items' but only at the 'sell price' there is no option to select what pricegroup. I can go 'AR/Customers/reports/search' enter a customer name, when the search returns I can select the customer and enter 'edit customer' which has an option of 'price list' but it doesn't give me an option to select pricegroup either. What I want to do is print a price list of all the telephone items for company XYZ who are on 'established' pricing. Is there a way to do this? Jeff Roberts JR Electronics |