Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Tax included in item price with 2 tax details

(0) ShareShare
ReportReport
Posted on by 202

Hi,

I want to use the 'tax included with item price' option in the tax detail definition.

I have a customer with a tax schedule id (TAX_INCLUDED) based on 2 tax details (TPSINCL, TVQINCL).

See Image 1. Excel Calculation = Good amounts

See Image 2. GP Calculation = Wrong amounts

How can I resolve this ?

Image 1.

8357.Image1.JPG

Image 2.

Image2-_2D00_-Copy.JPG

*This post is locked for comments

  • MSL Profile Picture
    MSL 202 on at
    RE: Tax included in item price with 2 tax details

    This is the second tax details where tax is included with TPSINCL

    Image5.JPG

  • MSL Profile Picture
    MSL 202 on at
    RE: Tax included in item price with 2 tax details

    Here's the tax details definition.

    They are not set to be a Taxable Tax.

    Thanks,

    Image3.JPG

    Image4.JPG

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Tax included in item price with 2 tax details

    Can you post the Tax Detail Configuration for each of the two Tax Details.

    First pass answer is that one of the two is set to be a TAXABLE Tax and therefore it is looking at the Pre-Tax Amount - calculating the first tax ( one that i think is taxable ) then adding that to the Pre-Tax and then calculating the next tax.

    Post more and we will help you clear up this matter.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans