Ir al contenido
Se marcó esta pregunta
searchpaymentsv11
1 Responder
5121 Vistas
Avatar
Community Question

I have Customers who pre-pay and who also carry credits from past orders to future orders.

BEFORE emailing Invoices to my Customers, I'd like to verify if any past pre-payments or credits should first be applied to reduce the balances, in some cases fully paying the Invoice.

I know that I can open EACH Invoice (one at a time) and check if this is shown at the top:


How can I use the FILTERS dropdown to find all of these without looking one by one?

Avatar
Descartar
Avatar
Ray Carnes
Mejor respuesta

See the filter below.

It will find OPEN Invoices where the Customer has a NET balance owed to them (meaning they have payments registered that have not yet been allocated to other Invoices):

<filter name="has_outstanding"
        string="Unapplied Payments" 
        domain="[('state','=','open'),('partner_id.credit','&lt;',0)]"/>
Avatar
Descartar
Kiki Klun

Is there an updated way to accomplish this in V17? Also, which screen are you starting from? I tried the search in the customer invoices list, as well as the accounting -> customers, customer payments, and the contacts app lists, but the option for "has outstanding" does not exist as a custom filter. I'm wondering why this feature disappeared or if I'm doing something wrong. Thanks!

Publicaciones relacionadas Respuestas Vistas Actividad
Filter multiple values of field via XMLRPC? Resuelto
search xmlrpc v11
Avatar
Avatar
2
sept 20
5993
How do I filter a spreadsheet pivot to the current/previous month
search
Avatar
Avatar
1
jul 25
575
When registering payment, i get "can't create a new payment without an outstanding payments/receipts account set"
payments
Avatar
Avatar
1
abr 25
2190
Search a message Resuelto
search
Avatar
Avatar
1
feb 25
1287
payments not sorted by date in invoicing
payments
Avatar
Avatar
1
oct 24
1684