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

Business Central/NAV User Forum
1

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?

2

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.

3

Or in Item Card

go to

Item–>Statistics–>Entry Statistics

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