InActive Customers In Nav2009R2

Dear All,

I am using Nav2009R2.

Q:Customers doesn’t have any transactions from past 2 months, i want to display this type of Inactive customers in navision reports.

Can you please give me some logic.


We have added a “last invocie date” field which allows us to use it in report filters.

Or you can set a datefilter on Sales ($) for the last two months and if sales ($) = 0 then you know they did no business.