excel – delete invoices with 0 total vba

I’m back folks!

got a tiny issue here and have no time to think of a solution!

enter image description here

i want a vba code to delete all the invoices with same invoice number and their amount is equal to 0 just like the two highlighted ones in the pictures i want to delete these two rows since the total of these invoices in column G is equal to 0 but keep the last one !

any ideas ?