콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
5185 화면

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
6052
1
7월 25
632
1
4월 25
2252
Search a message 해결 완료
1
2월 25
1319
1
10월 24
1723