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
|
