date range for purchase price

Hi all!!!

Is there any provision in navision by which I can know the date range for the direct unit cost of a purchased item.


if I purchased an Item A at 5Rs/KG from 01/04/18 to 30/04/18

then the rate changed to 10 rs/kg. the report should show

From Date To Date Supplier Name Item Code Desc Rate Qty Purchased
01-04-2018 30-04-2018 ABC A A 5 300
01-05-2018 30-05-2018 ABC A A 10 350

You can create a small email notification customization such that when ever a rate is changed a email notification is sent out.