Closing Stock Godown

Dear Sir
Please find the attached document.

in this customer using the material in 1 qty only. but they are transferring the material for service 1 location to another location. Here i need finally the material available godown in report.
how to achieve this, here I am try an code for this but location only can't come there. pls give solution any one for this

 

any one give solution for this

 

I need closing stock available godown name in the last column in my developed report