how to know if the invoice is already fully paid or not?

julkifli33

hi all...
can we know which invoices already fully paid?
from Posted Sales Invoice i mean

because when i want to create credit memo,
i use copy document
i want to select from posted invoices which havent fully paid
so i need to filter it

thanks before

ara3n

There is no field in posted sales invoice that displays amount paid. That information is only in customer ledger. You could create a flowfield that will display the remaining amount from Detailed Cust. Ledg. Entry.

TheDoubleH

The field 'Open' on the Customer Ledger Entry indicates if the entry have been fully applied. If the Value is Yes, is has not been fully applied (paid or credit note applied)

julkifli33

i need to filter it when i want to copy document for sales credit memo
do anyone have idea?
thanks

ara3n

as I mentioned, you need to create a flowfield, either to cust. detail or customer ledger on the open flag.
Once you've created the flowfield, you can filter on it. If you do not know how to do this, then contact your partner.