Skip to main content
Solved

Deleting Advance Invoice

  • February 23, 2022
  • 6 replies
  • 359 views
T
Sidekick (Partner)
Forum|alt.badge.img+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

Best answer by Adam Bereda

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

This topic has been closed for replies.

6 replies

A
Hero (Customer)
Forum|alt.badge.img+16
  • Adam Bereda
  • Hero (Customer)
  • 735 replies
  • February 23, 2022

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.

Regards, Adam
T
Sidekick (Partner)
Forum|alt.badge.img+8
  • Thakshila
  • Author
  • Sidekick (Partner)
  • 45 replies
  • February 23, 2022

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

A
Hero (Customer)
Forum|alt.badge.img+16
  • Adam Bereda
  • Hero (Customer)
  • 735 replies
  • Answer
  • February 23, 2022

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

Regards, Adam
T
Sidekick (Partner)
Forum|alt.badge.img+8
  • Thakshila
  • Author
  • Sidekick (Partner)
  • 45 replies
  • February 23, 2022

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

S
Superhero (Employee)
Forum|alt.badge.img+14

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.

T
Sidekick (Partner)
Forum|alt.badge.img+8
  • Thakshila
  • Author
  • Sidekick (Partner)
  • 45 replies
  • February 23, 2022

Thank you Shanuka for your this.

Terms & ConditionsCookie settingsAccessibility statement