You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
7.1.1 Pricing Question
- Thread starter nate100
- Start date
For 7.1.1, for the line items, QAD calculates the Net Price. Is this determined the Item Number, QTY Ord and the customer? Can anybody verify that it is based on all 3 of these.
Thanks
Price Lists in QAD can support simple to complex pricing schemes. As you suggest , you can create a Customer/Item/Quantity scheme in 1.10.1.1. You would then select "Net Price" as the Amount Type. However, this is the most labor intensive method for set up and ongoing maintenance of prices. I would only recommend this if you have a small number of Customers and Items. An even then I would consider using 1.8 Analysis Codes to cut down the work.
Analysis Codes found in 1.8 allow you to group customer and items together. In this manner as you add customers and/or items they can automatically be included in the group using data from the Customer Master or Item Master respectively. These groups are then associated to a Price List and when a Sales Order Line is created the system finds the correct price.
So let's say you have a situation where all Customers get the same Net Price based on the Item Number.
In 1.8.1 you would create an Customer Analysis Code of ALLCUST
In 1.8.4 you give the system the criteria for selecting records for ALLCUST. You could use almost any of the selection choices but let's say you use Bill-To and the wild card * in the From/To fields. In effect you are saying from Bill-To 00000000 To Bill-To 99999999 are included in the group ALLCUST.
Now you can run 1.8.19 Analysis Code Detail Build - this executes and stores the relationships you defined in the two steps above.
Now you can go to 1.10.1.1 and create pricelist called NET.
Instead of putting in individual Customer Numbers you would put ALLCUST in the Customer/Analysis Code field. This is telling the system to use all of the Customers associated with this Analysis code and eliminates entering them one by one.
You would still need to put in each individual Item Number and the prices but when you enter a new Customer, it will automatically get added to the ALLCUST group (provided the Automatic AC Regen flags are set to Yes in 1.10.24). And you will only have to maintain one Price List. If you add a new part to the Item Master, you only need to add it to the NET price list once and all customer get this price.
Analysis codes can also be used to group Items so that if different types of Items have different pricing methods you can accomodate them.
The help screen will give you some information but it might be better to refer to the User Guides for more details.
Good Luck. -Let me know if I can be of any more help