Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
5007 Weergaven

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
Annuleer
Beste antwoord

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
Annuleer

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!

Gerelateerde posts Antwoorden Weergaven Activiteit
2
sep. 20
5895
1
jul. 25
400
1
apr. 25
1989
1
feb. 25
1213
1
okt. 24
1526