Solved

Invoice posting error

  • 22 September 2021
  • 4 replies
  • 378 views

Userlevel 5
Badge +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.

icon

Best answer by Shehan Almeida 22 September 2021, 13:18

View original

This topic has been closed for comments

4 replies

Userlevel 7
Badge +17

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.

Userlevel 5
Badge +10

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..

Userlevel 7
Badge +17

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.

 

 

Userlevel 5
Badge +10

Thanks @Shehan Almeida