Invoice has been fully paid and still be able to choose the payment amount of zero
Background:
Recent users, some of the invoices have been fully paid and still be able to choose zero-sum payment, currently we do not have this feature turned on (enable the Allow Zero Payments option in the Payables Options region of the Bank Accounts window.)
Reasons:
Personally think that may be the bug, leading to no synchronization update flag
Measures:
1> to find the corresponding invoice;
SELECT DISTINCT ai.invoice_id, ai.invoice_num invoice_num,
pv.segment1 vendor_num, pv.vendor_name vendor_name,
'The fully Paid invoice should be closed!' Status
FROM ap.ap_invoices_all ai,
po.po_vendors pv,
ap.ap_payment_schedules_all aps
WHERE ai.invoice_id = aps.invoice_id
AND ai.set_of_books_id = & sob
AND ai.invoice_amount = ai.amount_paid
AND ai.cancelled_date IS NULL
AND ai.vendor_id = pv.vendor_id
AND (ai.payment_status_flag <> 'Y'
OR aps.payment_status_flag <> 'Y'
)
2> update the corresponding flag to conform to the actual operations;
update ap_invoices_all
set payment_status_flag = 'Y'
where invoice_id = & invoice_id;
update ap_payment_schedules_all
set payment_status_flag = 'Y'
where invoice_id = & invoice_id;
Conclusion: The test found
1> 2 form a payment_status_flag any Y, the other values of N or P, in the table would choose not to pay the invoice;
2> the two tables do not payment_status_flag for Y, check whether the two N or P, in the payment table could choose to invoice.
Tags: oracle, AP INVOICE table lt, conclusion, payables, invoices, two tables, amp, payment schedules, gt 2, status flag, vendor id, vendor name, sum payment, aps, bank accounts, pv, measures
















