Skip to main content

Is there a screen/search I can use to determine which invoices are set up to pay in instalments rather than full amount?

Hi @SMcLees 
 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