Page 1 of 1
unable to cancel the prepayment invoice
Posted: Thu Jul 15, 2010 1:00 am
by nrao1981
Hi All,
In AP 11i (11.5.10.2)
I have a prepayment invoce, which is not yet paid. I want to cancel that prepayment invoice, but while canceling it is giving message like you cant cancel the invoice or see user guide.
can any one help me regard to this
Thanks in advance
Posted: Fri Jul 16, 2010 2:27 pm
by mido_emam
Would you please send me the message exactly.
Mahmoud Maher
Posted: Sat Jul 17, 2010 2:55 am
by nrao1981
[quote]Would you please send me the message exactly.
Mahmoud Maher
<i><div align="right">Originally posted by mido_emam
Posted: Wed Jul 21, 2010 3:22 am
by sartek
im having the same error, were you able to resolve this already?
~thanks
Posted: Wed Jul 21, 2010 4:23 am
by sartek
was able to cancel the invoice, with a datafix
UPDATE ap_invoice_distributions_all
SET prepay_amount_remaining = (your invoice amount)
WHERE invoice_distribution_id = &
AND invoice_id = &;
Posted: Wed Jul 21, 2010 5:14 am
by Goutamasa
Hi,
You can directly go to actions button and cancel the invoice from there. You can cancel the prepayment invoice (even if it is validated).
Posted: Wed Jul 21, 2010 9:52 am
by Rizwan.Mumtaz
Hello Nrao
Try this if it work for you
Find your invoice and in the invoice header find field Prepayment type and change it to temporary if it is permanent, then cancel your invoice.
Do tell me if it works. thanks