Excise Register Query

Dear Experts,

I need a single query for Output & Input Excise base on Outgoing & Incoming document.

The result should like this

Output Excise

Doc No Doc Date Customer Name Ass Value BED Cess HSCess

Total of Output Tax

Input Excise

Doc No Doc Date Customer Name Ass Value BED Cess HSCess

Total of Input Tax

Net Excise Payable

Regards

Datta Kharat