コンテンツへスキップ
メニュー
この質問にフラグが付けられました
1 返信
5066 ビュー

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
5938
1
7月 25
514
1
4月 25
2072
1
2月 25
1246
1
10月 24
1610