Customer Report

Dear All,

I need help in designing a VAT sale report. The required format is :-

Sno. Customer TIN Taxable Amount VAT Amount Gross Total

In this format they want Customer who have their TIN No come in one column and customer who have not TIN No cone in one column.

I don’t know how to do this [:(]. Can anyone please help me to solve this problem.


Please put in an excel spreadsheet with some examples and email to May be able to help.

Also which version of Dynamics Nav and which country version of Nav?