Hi All,

I was wondering if someone would be able to help with an issue we have when trying to post a customer invoice please. The invoice in question has popped up on the ‘Customer Invoices with Errors’ screen. When clicking into it to see the detail of the error, “ORA-20105: Invoice.ACCERROR1: Error (Connected advance invoice AD XXXXXXXX already Settled/Cancelled.) occurred while booking Invoice CD XXXXXXXX.” pops up with the Advance invoice and invoice number details.

The Advance invoice was paid on 29/08/2024 but it looks like we have processed 2 mixed payments, One on 29/08/2024 which was approved and then one looks to be dated 30/08/2024 which was cancelled. Both mixed payments included the payment of the advance invoice.

The CUPIA from the payment on 29/08/2024 looks to be on the account, as it would normally be when an advance invoice is paid. Hence why we are confused why it is saying its ‘settled/cancelled’.

We are unable to post the invoice due to this error, but cannot see where it stems from.

Any help would be greatly appreciated! 

Thanks,

Lucy