Matrix Pricing by Customer Group and timCustItemPrice

SUGGESTED

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?

  • 0
    SUGGESTED

    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.

  • 0 in reply to Ramon M.

    We only use Customer Group pricing and all of our other customers (in other groups) are in the timCustItemPrice table. One warehouse - no address differentials or any other pricing is set up.

    Why would one group not show up in that table?

  • 0 in reply to dsusannah

    As Sage 500 ERP is a pretty open system, I cannot know for sure how the data got there.  And since the table does not have a CreateType or CreateDate field, it would be harder to guess.

    If you took one of those items/warehouse records that are in timCustItemPrice now, what application can you use to edit existing records?  I am wondering if someone or some process has moved data over there if contract pricing was never used.  This could probably be done through the back-end if you make a few assumptions, which perhaps was done in the past to support what you are looking to do? 

    If you find that the PricingKey in timCustItemPrice is not unique, then that may be an indication the data was generated outside of a Sage process, but I cannot verify that without further research. 

    Perhaps someone else can comment ...