A question came up to the Microsoft Dynamics Forums asks about the tax schedules and why it does not automatically calculated while the tax schedules are already defined and correctly linked to items, customers, vendors and sites.

There is an option in…

Most Dynamics GP users I talk with, complain about the sales tax functionality. They say it's difficult to set up and maintain. I don't necessarily agree.

I just updated the new tax rates effective in California as of July 1, 2009. Because I had setup the taxes using Tax Schedules that contain individual Tax Details to represent the different taxing agencies, all I had to do was update…

I had the honor of updating the sales tax rates in our GP system following the 4/1/09 changes in CA. The existing Tax Schedule report was not useful to me because I had set up the sales tax function in GP to make good use of the Tax Details; so that a typical tax schedule will have 3 - 5 tax details in it. I quickly modified the report to show the tax…

This one is very simple yet powerful illustration, on How GP calculates Sales Taxes, from Frank Hamelly on his…

Hello friends,

I'm happy to report that after all of the issues that came up during the SP 4 year end update and .net 3.5 sp 1, the Forms W-2 and 1099 printed perfectly.

We did have a problem with the Reports dictionary, but that was resolved by creating a new reports dictionary…

Tax Changes in Dynamics (GP)

This is a quick re working of the advice we put together last time the VAT changed from 17.5 to 15%. This change is being reversed in January 2010 so now would be a good time to start thinking about how this might effect your systems. The changes in VAT where originally set out in the Chancellors PBR on the 24th November 2008. Because of the nature of Tax calculations in Dynamics (GP) this article is intended purely as a Guide and you will need to choose the appropriate actions for your circumstances.

Note: We have kept these notes fairly generic as we have clients on several different versions, however in version 10 where we give a path to Setup>company etc these are found under Tools> setup > Company

Tax Details

Originally we advised that everyone will need to set up a new set of tax details to replace the 17.5% details currently used. We recommended that you did not simply change the rate on your existing detail as this could cause you reporting problems and issues when trying to post back.

To set up a new Tax detail you need to go to Setup>Company>Tax details
You needed to set up a minimum of two details, one for sales and one for purchasing. This needed to be done in each of your companies.

If you followed this advice you should now still have your original 17.5% tax codes to which you can now revert in January.

Tax Schedule

Here you have Two choices.

Option 1: We advised that you could retain the existing Tax schedule and simply remove the 17.5% detail from this schedule. Then add the new 15% detail to the schedule and to the ALL…

Use tax is one of those things that many companies using Microsoft Dynamics GP immediately resort to third-party solutions without really considering the systems out-of-the-box capabilities. The reasons may be various, among them, a lack of…

Business Situation

A few days ago, a user was facing an issue in which apparently, their tax history was not being recorded or was missing for a good number of transactions created in Sales Order Processing. In addition, the user wanted to use Dynamics GP's built-in tax reports as they did exactly what she needed.

Of course, the question came in: How can I rebuild my Tax History?

Solution

One thing I love about Dynamics GP is the fact that information created in the subsidiary modules, flow to other parts of the application tables when GP is instructed to do so. This instruction comes via the configuration options in the system.

In this particular case, when Sales Order Processing transactions are created and taxes are calculated for those documents, the tax detail information is stored in the Sales Tax Work and History table (dbo.SOP10105).

When invoices and returns are posted, and…

1.  Select the Product Manager from the Products drop down.

2.  Expand the first Occasion.

 

 

3. …