Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 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:Modify Sales Tax Schedule Report
Description: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 percentages and to add them up by Tax Schedule.

To print the report navigate: Reports >> Company >> Taxes
Select "Tax Schedule" for the report type.

I made three modifications:

Add the Tax Detail Percent field from the Sales/Purchases Tax Master table, to the body of the report. You'll want to make some room for it.

Add a footer with Report Section Options, using the Sales/Purchases Tax Schedule Header table, and the Tax Schedule ID field.

Add the Tax Detail Percent field from the Sales/Purchases Tax Master table, to the new footer. Change the Display Type to "Sum".

And that's it. This gave me the basic information I needed to ensure that I had set up the tax schedules correctly. It took me less than ten minutes to get the basic report.

You may want to make it look a little better by adding labels and formatting the total amount.

This is what mine looks like:

Category:GP USER INFO: Taxes
Link Owner:
Date Added:June 17, 2010 02:08:47 AM
Number Hits:36
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.