Solved

Deleting Advance Invoice

  • 23 February 2022
  • 6 replies
  • 127 views

Userlevel 5
Badge +8

Hi Community,

 

Could you please help me with below issue?

 

We have an advance invoice which is created my mistake. Since there is no any posting controls setup for advance invoices in this company this invoice is ended up with error message and in the ‘’Printed’’ status.

 

Error message - ORA-20105: PostingCtrl.NOPOSTINGTYPE: Posting type IP19 is missing in Posting Control

 

Currently both create credit/ correction invoice options are not available in the invoice level. Therefore, kindly let me know how to delete this advance invoice.

 

Thanks in advance!

Thakshila

icon

Best answer by Adam Bereda 23 February 2022, 18:30

View original

6 replies

Userlevel 7
Badge +12

Hello,

I am afraid that since invoice number has been given to the invoice already, it cannot be removed. It would create hole in invoice numbering, unacceptable from legal point of view. 

You should set up required posting types, post invoice and then create credit note (option will be available for posted invoice) and offset these two against each other.

Userlevel 5
Badge +8

Hi Adam,

 

Thank you so much for your quick support. Can we delete this from database side rather setting up posting types?

 

Best regards,

Thakshila

Userlevel 7
Badge +12

Hello,

if you think about direct database action, it is better to change invoice status back to Preliminary. Preliminary invoices can be deleted from front-end.

Do not forget about missing number in invoice serie - if no invoice printed after, number serie can be adjusted

Userlevel 5
Badge +8

Thank you so much for this. We will try this out.

Userlevel 5
Badge +9

Hi Thakshila,

In addition to the steps suggested by @Adam Bereda, you may refer following article which might be helpful while rectifying the issue.

 

 

kind regards,

Shanuka.

Userlevel 5
Badge +8

Thank you Shanuka for your this.

Reply