Sunday, October 8, 2017
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 , click on , point to , point to and click .
b. Mark the checkbox for the company you want to with.
c. Select a 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 .
2. REPORT SETUP: Set up report ID's and map column codes as follows:
a. Click on , point to and click .
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 r 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 option, you will access to resubmit the VAT Return.
f. Click on the link to open the VAT Daybook Column Codes window.
g. Enter the 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 as either Sales or Purchases.
I. Next to , 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 :
• is the total tax amount.
• is the total taxable amount.
k. For the , select if you want to pull in for , , or both
l. Add more Tax Detail ID's to pull into this column as needed.
*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 point to and click on . 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 . 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 under , point to , point to , and click on .
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:
• - will print a draft of the detail in the TX30000 for the report setup that you defined, along with any exception reports.
• - 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*.
• - This is the report to generate the VAT Return and will print the summary, detail and exception reports. This is the final report and will 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.
• - 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.)
Hello.. One of very critical issue using Cashbook Bank Management is the voiding of cash receipts.Its bit tricky and would like to share t...
Hi .. Another very useful information on setting up Fixed Assets in Microsoft Dynamics GP. Cheers. When you set up Fixed Asset Manageme...