Is it required to include an invoice followed by a credit note in the accounts?

In this case, both the invoice and the credit note must be entered in your accounts.
This does result in a zero transaction. However, the supplier from whom you purchased the product will also enter this invoice in their accounts. Failure to do so could cause problems with the tax authorities.