Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
1 ตอบกลับ
5073 มุมมอง

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!

Related Posts ตอบกลับ มุมมอง กิจกรรม
2
ก.ย. 20
5947
1
ก.ค. 25
534
1
เม.ย. 25
2111
Search a message แก้ไขแล้ว
1
ก.พ. 25
1249
1
ต.ค. 24
1625