Is there a NAV report that shows last purchase date for items

Is there a NAV report that shows last purchase date for items?

If not, is there an existing report to which we could have that added?

Currently no report shows that in standard Navision.

If you are developer then you can do following

We can add a field to Item Card Called “Last Purchase Date”, based on the Item Ledger Entry table.

It’s a Flowfield and the CalcFormula is
CalcFormula = Max(“Item Ledger Entry”.“Posting Date” WHERE (Item No.=FIELD(No.),Entry Type=FILTER(Purchase),Quantity=FILTER(>0)))

This will give user direct display on Item card itself for last purchase date of item.

Or in Item Card

go to

Item–>Statistics–>Entry Statistics

Here you can see all Last Dates of Sales/Purchases…