Skip to main content
Solved

Invoice posting error

  • September 22, 2021
  • 4 replies
  • 472 views

Forum|alt.badge.img+10
  • Sidekick (Customer)
  • 107 replies

Hi,

I need some help in clearing a couple of customer invoices with errors:

I have two invoices which have been processed at a different value to the payment plan, IFS rejects these differences, details below:

 

Customer            Inv                          Order                    Invoice                 Plan                       Var

x                     970023938           00026513             1776                       1633.32                 142.68

y                    970023828           00015520            2051.45                 2031                       20.45

 

below is the error message on the 2nd line for customer Y

 

ORA-20105: Invoice.ACCERROR1: Error (Payment plan amount (2031) should be equal to invoice amount (2051.45).) occurred while booking Invoice CD 970023828.

Best answer by Shehan Almeida

Hi @m.arif ,

 

Invoice amounts cannot be modified unless you do a data repair. 

 

Therefore, you will have to raise a support ticket for this.

 

Otherwise as you have mentioned you can get this invoice posted with the current values (This can be done by updating the installment plan) and raise  credit invoice. Then re-create the invoice with correct amounts.

 

Shehan Almeida.

 

 

This topic has been closed for replies.

4 replies

Shehan Almeida
Superhero (Partner)
Forum|alt.badge.img+18
  • Superhero (Partner)
  • 271 replies
  • September 22, 2021

Hi,

 

If the invoice amounts are correct and only the instalment plan amounts needs to be corrected, you can update it as follows.

 

Go to customer invoice window, RMB and select ‘Instalment Plan & Discounts’

There You can update the invoice payment plan as follows.

 

 

 

Hope this would help.

 

Shehan Almeida.


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 107 replies
  • September 22, 2021

Thanks @Shehan Almeida  , but it otherway around  . the invoice data comes from Salesforce and we need to do a correction at customer invoice. Is there a way to do it other than passing credit invoice and recreating it.  The invoice is in error state with error

ORA-20105: Invoice.ACCERROR1: Error (Payment plan amount (2031) should be equal to invoice amount (2051.45).) occurred while booking Invoice CD 970023828..


Shehan Almeida
Superhero (Partner)
Forum|alt.badge.img+18
  • Superhero (Partner)
  • 271 replies
  • Answer
  • September 22, 2021

Hi @m.arif ,

 

Invoice amounts cannot be modified unless you do a data repair. 

 

Therefore, you will have to raise a support ticket for this.

 

Otherwise as you have mentioned you can get this invoice posted with the current values (This can be done by updating the installment plan) and raise  credit invoice. Then re-create the invoice with correct amounts.

 

Shehan Almeida.

 

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 107 replies
  • September 22, 2021

Thanks @Shehan Almeida