Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do I change the ta...
Microsoft Dynamics GP (Archived)

How do I change the tax basis on a (GP 9) Tax Detail ID?

(0) ShareShare
ReportReport
Posted on by Ken Denman 85

Starting January 2013, the Quebec government is changing how sales tax is calculated.

Currently the tax basis is the item purchase price plus applicable GST (VAT).

The change is to item purchase price only. The rate will be changed to derived the same results as the old basis.

However, once a GP 9 tax detail ID is use (in our case we call it QST-P and QST-S), the tax basis cannot be changed.

We'd really like to avoid setting up new tax detail ids and changing all open documents (both SOP and POP).

How are others dealing with this? Can we force the change directly in the database?

Ken

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How do I change the tax basis on a (GP 9) Tax Detail ID?

    Hi Ken,

    I believe your only option is to set up new Tax Details with the new calc basis.

    I would not attempt to do it through SQL. There is a lot riding on the tax details.

    Ian.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: How do I change the tax basis on a (GP 9) Tax Detail ID?

    I can confirm the behavior of GP2010 is no different from what you describe (i.e. once a Tax Detail is in use, the basis is not changable).  We are trying to use the Date Effective Tax module to try to save some time and effort.  First we had to overcome the fact that if GP2010 was installed using the RTM media, the Date Tax Effective module could not be installed.  I booked a support call and for only about $300CDN was told that the behaviour was "by design" and I would have to remove the GP client and re-install using the GP2010 SP2 media.  A KB on the topic would have been a little nicer...<sigh>.

    Given your experience here, I won't blame you for not sharing the solution.  I can't offer any insight about how to approach this in GP9 (we skipped that version).

    Tim Foster

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How do I change the tax basis on a (GP 9) Tax Detail ID?

    Ken,

    Sorry if you feel Jonathans response was insensitive, but he was just calling out that since your running a unsupported version of GP he will not be able to provide you with a fix for this exact question.

    Glad to hear that you were able to get an answer to your question.  

  • Ken Denman Profile Picture
    Ken Denman 85 on at
    Re: How do I change the tax basis on a (GP 9) Tax Detail ID?

    That is an NVA answer, as well as being insensitive and not in keeping with your role.

    My company is small (<100) and has been struggling with the effects of the European sovereign debt crisis and trade wars between China and the US/EU.

    D'ya not think if I'd had the money, I would have upgraded by now????!!

    I did get an answer on this but curiously, it did not come from a Microsoft employee or customer. It came from an SAP implementation consultant.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: How do I change the tax basis on a (GP 9) Tax Detail ID?

    Upgrade to a support version of GP. GP 9 hasn't been supported in almost 2 years.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans