Get Prices in SRM from MDM/ Historical Prices in MDM
I have this requirement, that we need to build a report based on price difference analysis between price in catalog and possible prices changes in SRM Purchase Order. For example, i get product from catalog with a price of 10u20AC, but I change it in Purchase Order for 18u20AC. What I need is a report, that gives this information, per product.
But i am facing two constraints:
1) How can I get prices from Catalog in SRM? I can't find that information... Is there any table or any application I can call to have this information?
2) Is that possible, in MDM to keep a history of prices? For example, if the price of the product in MDM was 10 u20AC and today I change for 12u20AC. Is MDM keeping the price of 10u20AC somewhere?
That would be relevant to compare prices on the date of the Purchase Order....
Is there any advice/ ideas you can tell??
Thanks in advance,