Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 5 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Update an invoice number with discarded lines
#1
Hello,

How can we update invoice number for the invoice with discarded lines in R12.
If an invoice has the below status:
Status: Needs Re-validation
Accounted: Partial
Approval: Not Required.

How can we do it in oracle r12?

Regards,
Gordon
Reply
Thanks given by:
#2
I think you cant adjust the invoice number if the invoice is accounted. As your invoice status shows partially accounted, so in this case you cannot update the value. The logic behind is that because the invoice number and other accounting information is passed on to GL and this would cause data integrity issues.
 
But If it was not accounted, you would be able to change the invoice number.

Regards,
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Invoice having too many lines in AP r12 Harish Duleep 2 964 09-26-2015, 02:11 PM
Last Post: rajagopal_23
  Different payment method for one invoice Rubab Ali 2 1,164 04-26-2015, 08:48 PM
Last Post: Hassan Habib
  Single payment for multiple invoice under same supplier R.V.Kumar 1 3,933 04-15-2015, 04:22 PM
Last Post: Ambarish
  How we can bring AP Invoice attachments through the FA Mass Additions Process in R12 Saleem Akhtar 1 1,068 03-23-2015, 07:40 PM
Last Post: ajkhan80
  How can we update the invoice number in AP Harish Duleep 1 953 02-23-2015, 08:22 PM
Last Post: ajkhan80
  How to create AP invoice for Delivered Quantity Santosh 1 811 02-18-2015, 09:12 PM
Last Post: ajkhan80
  Update AR transaction number by using AR Doc Sequences Zishan Ali 1 642 02-01-2015, 07:56 PM
Last Post: Gopal Ayog
  Hold “no payee bank a/c” for invoice with Electronic payment method Anumeha Manish 1 796 01-18-2015, 08:12 PM
Last Post: ajkhan80
  How can check delay invoice listing Joseph George 1 720 01-14-2015, 06:06 PM
Last Post: Divya Omkar
  Invoice status “Needs Revalidation” Rachel Hannah 2 4,927 01-06-2015, 03:59 PM
Last Post: mramadhani



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!