This problem is a little difficult to explain and my first post on here so please bear with me.
I am using Sage 50 Pro version 21 (2015)
Somehow Sage has used the same invoice number for two invoices but only in the Transactions list. When you look at the "invoices and credits" the first invoice is displayed, it is only when you look into "transactions" for the invoice number that you can see the duplicate. The correct invoice is also in Sage with the correct invoice number, date, customer and details.
I have no idea how this has happened, if you use the same invoice number twice in Sage, it brings up the contents of the invoice that already exists. the duplicate has a later transaction number, therefore it was created in Sage after the first one, so the existing invoice has not been changed.
I need to delete the duplicate invoice that only shows in the Transactions, without affecting the VAT as it shows as reconciled.