Invoice has been fully paid and still be able to choose the payment amount of zero

Posted on 2009-06-25 filed under: Oracle (RSS) 22 views

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.