Filtering Customers by last invoice date

Question

Hello all,
We recently switched to Odoo from Sage 50, and are getting used to the way things work, but struggling with certain tasks.  Currently, I am working on making a mailing list for our print catalog, and in Sage 50 we could just make a list of customers that included their 'Last Invoice Date', and export to excel, sort out customers who have not ordered in the last 2 years, and we were good to go.
In Odoo, I cannot figure out how to do such a similar filter.  Anyone out there have any goo

Jon Toktas · Answer

I'm trying something similar and found under Sales>Customers  filter by  advanced search "last full reconciliation date"  less than or equal than  'desired date'. This seemed to find what I needed. However, sometimes order date and invoice reconciliation are two different dates. So i'm not sure how to pull up the "last sale order date"
Did you find another approach?

Clark Steward (cst) · Answer

From the Accounting > Customer Invoices you can filter by "Invoice Date >= date", then export Partner/Email, Partner/Name, and Invoice Date of the results. You could also do the same thing from Sales > Sales Orders.

Balvant Ramani · Answer

for that require to create custom filter in res.partner. and you can override read_group and search method.

This question has been flagged

Enjoying the discussion? Don't just read, join in!