Seelction of latest price in Catalog

[Former Member]

Hi Experts,

1. Price of u2018Catalog itemu2019 is stored in a u2018Qualified tableu2019 with u2018Purchasing Orgu2019 as the non-qualifier. The qualified table is supposed to store price revisions. Hence, when the price is revised a new record is added in the qualified table (The old price is not deleted).

2. To identify the latest price, u2018Indicatoru2019 field is added as non-qualifier in the qualified table. This field can take only 2 values.

a. u20181u2019 u2013 Latest price

b. u20180u2019 - Old price

Hence, the qualified table has 2 non-qualifiers (Pur. Org and Indicator) and 1 qualifier (Price).

We want to configure the system such that - When the catalog item is selected in SRM portal it should automatically enable selection of only the most recent price (i.e. price with Indicator value as u20181u2019) and disable other older prices from being selected. However, the older prices should be displayed.

How can this be done?

Note: SRM MDM Catalog Version 2.0

Thanks & Regards,

Anoop Sahu

[masa_139]

Hi,

How about implementing a small UI for price history?

We had similar requirement that only specific purchaser need to know price history. Our proposal was adding a hyper link in item and small UI shows price history.

What is business reason to show the old price?

Regards,

Masa

[Former Member]

Hi Masa,

Thanks for the reply.

Users want to view old price if required. A link, on which users can click to know old price is also perfectly fine. In your scenario, did you store the old price in qualified table itself or in different table? When the user click on the link to know the history, where is the price fetched from? Can you help us by elaborating on your solution.

Thanks & Regards,

Anoop Sahu

[masa_139]

Hi,

Our proposed solution has not been implemented but the plan was using chang tracking functions in MDM Console and small custom application reads log from DB level. If user needs only previous price, I would add 1 custom field just for information text and store the text by 'Assignment' function.

Regards,

Masa