Administration, Core Financials, and Project Accounting

[section203]

The goal is to use pricing sheets to use a list price and then an uplift for International pricing all in USD (not using the multi-currency module).  There is only 1 warehouse setup at this point.  The items are software, maintenance and service items so I don't need to manage inventory.

The following has been completed:

Inventory Management\Maintenance\Maintain Prices\Price Sheets

Item = part numbers

Pricing UOM = Each

Effective date = dates prior to today

List Price = US price 99.00

Foreign = uplift for International 149.00

Inventory Management\Maintenance\Maintain Items

Item type for a specific part testing = finished good

Standard price = 99.00

Accounts Receivable\Maintenance\Maintain Customers

Customer Class = Foreign

Status = Active

Price Group = Foreign

Price Base = Foreign

When entering orders in Sales Order, the price is not pulling from the Price sheet but from the maintain Item standard price field.

I would like sales order to pull from the price sheet so that I may setup 2 price sheets; 1 for US and 1 for international using the same part numbers but have different values.

Any help would be greatly appreciated.

[emurphy]

In general, you can go to IM -> Insights -> Price Inquiry to see what price rules will be applied for a given warehouse / item / customer.

Here is the hierarchy of price rules ("pricing options" in the help index).  The base in Maintain Customers doesn't come in until 10-11, so you probably have one or more rules at 1-9 that are overriding it.

1. Item - customer address
2. Item - customer
3. Item - national account
4. Product price group - customer address
5. Product price group - customer
6. Product price group - national account
7. Matrix (PPG-CPG) - customer address (customer price group)
8. Matrix (PPG-CPG) - customer (customer price group)
9. Base product price group
10. Customer address price base - plus or minus optional adjustment percent (price sheets or costs)
11. Customer (main) address price base - plus or minus optional adjustment percent
12. List price - price sheet
13. Item - standard price (item only)

(Inventory Pricing was added more recently - I think it goes between 3 and 4.)

1,2,4,5 are covered by Contract Pricing

3,6 are covered by National Account Pricing

7,8 are covered by Matrix Pricing (they both access the same data in a different way, think rows vs. columns of a grid)

[rroselli]

It sounds to me like you are taking this a level higher than you need to.  If all of your international customers are paying the same price then I wouldn't recommend using customer price groups. Just assign the base price in customer maintenance and then you will only have to maintain the list and price sheet 1 (Int'l). This will greatly simplify maintenance and reporting.

If you do need multiple price groups then follow the advice you already received. It does sound like you probably missed a step along the way.