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.
example:-
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 |