Is there a screen/search I can use to determine which invoices are set up to pay in instalments rather than full amount?
Hi
There is a report Supplier Invoices Due for Payment.
Amounts due for payment are shown in installments
Best regards
Aneta
Hi,
Installment can defined in payment term & when you use relevant payment term while creating the invoice it will create the installment based on selected payment term. Refer below screen preview for easier reference.
You may use below window to modify the installment once invoice created.
Best Regards
Narmada
There are two options to review the installment information in Accounts Payable and Account receivable
In APP10 navigation path
Financials\Accounts Receivable\AR Reports\Customer Invoices Due for Payment
Financials\Accounts Payable\AP Reports\Supplier Invoices Due for Payment
Hi,
you can use two windows to check it.
One of them is the Customer Invoices Due for Payment Analysis window, the other is the AR Customer Invoices Analysis window.
There is a checkbox Installemnt Plan - you can quickly see which invoices have an installment plan and which don’t have.
Best regards,
Małgorzata
Hi,
You can create a quick report by joining payment_plan with invoice.
Query:
select i.company,i.series_id,i.invoice_no,count(*) installmennts from payment_plan p,invoice i where i.company=p.company and i.invoice_id=p.invoice_id and i.company=NVL('&company' ,i.company) and i.series_id=NVL('&series_id',i.series_id) group by i.company, i.series_id,i.invoice_no having count(*)>1
Best regards,
Viraj
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.