Pricing Matrix List
The Pricing Matrix List provides various pricings for a specific item. This list is supported when one or more of the following features are enabled: Multiple Currencies, Multiple Prices, and/or Quantity Pricing. For each item, you can set multiple pricings based on the following:
-
Currency the item is offered in
-
Price levels available for the item — as defined in the price level user defined list
-
The quantity of items being sold — when the Quantity Pricing feature is enabled
|
Field Name |
|
Req. |
Mapping |
Notes |
|---|---|---|---|---|
|
currency |
RecordRef |
Y/N |
— |
References the currency the price level will be set for. This field is required when the multi-currency preference is ON. Otherwise, the default currency is sourced for this field and it is NOT required. |
|
discount |
double |
Y |
Pricing / Default Discount % |
This is a read-only field that returns the discount rate associated with the priceLevel. |
|
priceLevel |
RecordRef |
Y |
Pricing / Price Level |
This is a read-only field that references values in a user-definable list at Setup > Accounting > Setup Tasks > Accounting Lists > New > Price Level. For details on how to edit this list, see Price List. |
|
pricelist |
List |
N |
— |
See Price List. |
Price List
To provide multiple entries in the Price List, the Quantity Pricing feature must be enabled. Otherwise, only one Price List entry should be submitted. Notice that in the UI, the quantity for multiple pricings is entered only one time. In SOAP web services, however, you must submit the quantity for each pricing. The quantity values for each price submitted in the same list must match. If they do NOT match, an error is returned.
|
Field Name |
|
Req. |
Mapping |
Notes |
|---|---|---|---|---|
|
quantity |
double |
— |
Qty |
Sets the quantity required to receive this price. |
|
value |
double |
— |
Pricing / amount text box |
This is calculated based on the Base Price level and discount rate for the specified priceLevel but can be overwritten. |
Pricing Matrix Keys
The key for the Pricing Matrix List varies according to the related features that are enabled. The key is the field or combination of fields with values that are used to uniquely identify each line in the list. The following table describes possible key combinations.
|
Enabled Feature(s) |
Key Field(s) |
|---|---|
|
Multiple Currencies only |
currency |
|
Multiple Currencies, Multiple Prices |
combination of currency, priceLevel |
|
Multiple Currencies, Quantity Pricing |
combination of currency, quantity |
|
Multiple Currencies, Multiple Prices, Quantity Pricing |
combination of Currency,priceLevel, quantity |
|
Multiple Prices only |
priceLevel |
|
Multiple Prices, Quantity Pricing |
combination of priceLevel, quantity |
|
Quantity Pricing Only |
quantity |
In endpoints prior to 2012.1, pricingMatrixList updates ignore the replaceAll attribute and all requests behave as if it is set to TRUE. For the 2012.1 and later endpoints, replaceAll is respected. If you upgrade to one of these later endpoints, you need to carefully evaluate which replaceAll setting to use for pricing updates. For details about how replaceAll works with matrix sublists, see Matrix Sublists and replaceAll.