Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Tax included in item price with 2 tax details

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans