Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6100 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Set up VAT Daybook reports in Microsoft Dynamics GP
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.


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 InvoicesCredits, 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
Link Owner:
Date Added:October 09, 2017 02:59:33 PM
Number Hits:2
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.