Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Sales Tax Query/Report

Posted on by 165

We are a cash basis taxpayer and are having difficulties finding a report or query that could assist us in helping us prepare our monthly sales tax reporting obligations.  Are there any gp reports that could assist us with this?  Or even a simply query would help?  We can pull the invoices but not sure how to join in the payment side.  If we were accrual it wouldnt be a big deal.

Any suggestions would be appreciated.

 

Craig

*This post is locked for comments

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Sales Tax Query/Report

    If you set up your sales taxes correctly, it is easy and there are several reports.

    It takes a bit to explain so let's do this....go to our web site ( http://www.AccoladePublications.com ).  Login (just create a new account if you don't have one, it's free) Goto Free Stuff (far right top menu) and pick Position Papers then White Papers and scroll down to the paper on Sales Tax.  It explains what you need right there!

    While you are there, we have 20 other books on GP, check out Books in our Library.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Sales Tax Query/Report

    Craig,

    Here is a SQL view that may help with the payment apply information: victoriayudin.com/.../sql-view-with-ar-apply-detail

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Tax Query/Report

    Hi Craig.

    Have you looked at the Tax Reports under Administration Reports.

    You will find the Period Detail and Transaction Detail Version of transactions against tax details.

    If you have the allow Tax Details in GL Entries in your company options turned on you should be able to justify the payments through GL Entries if you are not currently doing it with an equal tax detail in the purchasing module.

    Hope this helps

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans