跳至内容
菜单
此问题已终结
1 回复
5001 查看

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?

形象
丢弃
最佳答案

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)]"/>
形象
丢弃

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!

相关帖文 回复 查看 活动
2
9月 20
5891
1
7月 25
393
1
4月 25
1982
1
2月 25
1213
1
10月 24
1521