This article will demonstrate how to map one tax detail to a particular column of choice in the VAT Daybook report. However, how you map the columns, to which column and what tax detail codes to map is your responsibility and out of scope for what a Microsoft engineer/documentation can advise on. You are responsible to map the columns according to the reporting rules required by your own taxing authority.




1. ACCESS: Give the company access to use VAT Daybook, if you are using VAT Daybook reports for the first time as follows:

a. Under Microsoft Dynamics GP, click on Tools, point to Setup, point to System and click Use VAT Daybook.

b. Mark the checkbox for the company you want to Use VAT Daybook with.

c. Select a Report Template to use for your VAT report. This will be the default summary report template used for your VAT Return. Leave blank if you do not have any set up yet.

d. Mark the Multiple Countries checkbox if you need to register for VAT in another EU country. This will allow you to print the summary reports for different countries.  Refer to the VAT Daybook manual for more information. 

e. Click OK.

2. REPORT SETUP: Set up report ID's and map column codes as follows:

a. Click on Cards, point to Company and click VAT Daybook Reports.

b. Enter a Report ID , report description, and country code.

c. Enter the column code for as many columns as you want on the report.  You can have a maximum of 25 column codes each, for Sales and Purchase Tax Detail ID's.

d. If you mark the Default on Vat Viewer checkbox, the Report ID you've selected will be the default ID in all transaction entry windows and VAT Daybook Report Options windows.

e. If you mark the Revision Allowed option, you will access to resubmit the VAT Return.

f. Click on the Column Code link to open the VAT Daybook Column Codes window.

g. Enter the column code such as '01' and give it a description that will appear as the heading in the VAT Detail report. You set up a maximum of 25 columns for each sales or purchase type.

h. Mark the Tax Type as either Sales or Purchases.

I. Next to Tax Detail ID, click on the lookup and select the tax detail codes that you wish to pull into this column. You will select them one at a time.

j. For each tax detail ID, enter a description, and select the Account Type:

• Tax Amount is the total tax amount.

• Net Amount is the total taxable amount.

k. For the Document Type, select if you want to pull in for Invoices, Credits, or both Invoices & Credits.

l. Add more Tax Detail ID's to pull into this column as needed.

m. Save.

*NOTE: You cannot edit or modify these tax details once you have printed the summary report. To make any changes, you will have to copy the Report ID and make changes to the new report ID before using it.

*NOTE: You are responsible to know which tax details to print in what column.  Microsoft is unable to advise on this setup. If any questions, contact your local tax authority for any guidance.

3. CALENDAR: Go to Cards, point to Company and click on VAT Calendar. Select the country code, year, Date to Use (choose Document Date, Posting date or Tax date), and define the first and last day of the year and number of periods and click Calculate. Once you print the Audit Trail report for the period, the Return Number column will display a Return number comprised of the period, year, and report ID to indicate that the report for this period has been printed.

4. REPORTS: To print the VAT Report:

a. Click on Tools under Microsoft Dynamics GP, point to Routines, point to Company, and click on VAT Daybook Reports.

b. Select an existing report option, or key in a name of your choice to create a new report option.

c. If you marked a report as 'Default on Vat Viewer' in the setup above, then that report ID will default in. 

d. Select the type of report you wish to print:

Draft - will print a draft of the detail in the TX30000 for the report setup that you defined, along with any exception reports. 

Draft+Draft Return - will print a 'preview' of what the Detail/Summary reports. It is recommended to print this option and review both the summary and detailed reports*. 

Audit Trail - This is the final report to generate the VAT Return and will print the summary, detail and exception reports. This is the final report and will commit or mark off the transactions in the TX30000 table and generate a Return Number. There is no functionality in the front-end to 'un-do' this, so make sure you have printed and viewed the draft reports first before you run this final report.

Audit Reprint - Allows you to reprint the final Audit Report that was submitted.

e. The Dates will look to the calendar you set up.

f. Select Transactions of sales, purchases or both to be included. (The options of Draft+Draft Return or Audit Trail will default to Both.)

g.  click Print.

More Information

Refer to the VAT Daybook manual for more information.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!