unable to cancel the prepayment invoice

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

unable to cancel the prepayment invoice

Post 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
mido_emam
Posts: 22
Joined: Tue Oct 21, 2008 8:54 am
Location: Egypt

Post by mido_emam »

Would you please send me the message exactly.

Mahmoud Maher
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

Post by nrao1981 »

[quote]Would you please send me the message exactly.

Mahmoud Maher

<i><div align="right">Originally posted by mido_emam
sartek
Posts: 2
Joined: Wed Jul 21, 2010 3:15 am
Location: Philippines

Post by sartek »

im having the same error, were you able to resolve this already?

~thanks
sartek
Posts: 2
Joined: Wed Jul 21, 2010 3:15 am
Location: Philippines

Post 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 = &;
Goutamasa
Posts: 27
Joined: Fri May 29, 2009 3:58 am
Location: India

Post 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).
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 22 guests