AR Movement Report requirement

We have an AR Movement report which has columns as mentioned below.

Opening balance , Invoice, Debit Note, Write off, Discount, Receipt, Closing balance

The Opening balance is derived from the logic of the std AR "As of" which basically has the Open Gross amounts. We now need a report showing the above columns but including the VAT amount.

I am aware that its possible to get the same for the  below columns,

Invoice, Debit Note, Write off, Discount

But what about for the VAT for Opening balance or closing balance.? Any idea please share?