Dear All, I am trying to make All in One Master Report Useful for Excise & VAT both. Please help me in the code. How to write function for getting the figures...
my objective is to get a report in which all the fields are fetched of the Purchase & Sales entry. Both reports differently. But in the report each & every fields data should come. Am hereby attaching our manual sheet. Please look at it.
I would like to explain in brief that we want to achieve the report itemwise. I had highlighted in the sample sheet attached. Then i have to do lots of formulas and then create pivot table and get the required report of fields needed. But if its possible to directly get the fields as i showed in sheet. I will have to then just make pivot of the report. Kindly give some advice for the required report.