Set up VAT Daybook reports in Microsoft Dynamics GP

Hi..
This article will demonstrate how to map one tax detail to a particular column of choice in the VAT Daybook report.This is particularly useful for users of Dynamics GP in Saudi Arabia and U.A.E where the VAT will be imposed from 1st of January 2018. Dynamics GP users in Bahrain and Kuwait are expected to follow  VAT implementation from mid 2018. 

Heres the guide on setting up VAT Daybook report in GP.

Cheers.. 

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.)


Recommended Book