Matrix Pricing by Customer Group and timCustItemPrice

Question

We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to: 
 Method - Discount Amt 
 Base - List Price 
 Amount - 0 
 
 The customers in this price group do not show up in the timCustItemPrice table at all. 
 We have a custom Crystal report that utilizes this table (among others) to run Price Lists per customer. 
 Why are the customers belonging to this simple set up not populated in the timCustItemPrice table?

Ramon M. · Answer

it has been a while, but I believe timCustItemPrice is used for contract pricing, where specific items have a defined price for a warehouse/customer or warehouse/customer/address. 
 Pricing for groups is stored at the group level, and the individual prices are generated at run-time. Trying to maintain this type of information in real-time at the time level would be a big performance hit among other issues. 
 I believe to get a price list utilizing group pricing would require running items through the pricing engine. Recall that pricing can be affected by many attributes and that there is a hierarchy of pricing methods and can possibly vary by a warehouse, a customer's address, promotions, etc. Running items through a pricing engine is the only reliable way to get current pricing on a given date. 
 So depending upon how complicated the pricing is with multiple pricing methods and multiple pricing date ranges, utilizing the pricing engine is the only way to get an accurate price for a given item on a particular date shipped to a particular address from a particular warehouse. If pricing is very simple, you may be able to get around using the pricing engine, but that is potentially risky over time, and is not recommended.

Sage 500

Matrix Pricing by Customer Group and timCustItemPrice

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING