Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / A negative tax amount ...
Microsoft Dynamics GP (Archived)

A negative tax amount can't be entered for a positive tax detail ...

(0) ShareShare
ReportReport
Posted on by Community Member

I have the following scenario:

Insurance Charges       $2000
Rent Charges                ($1000)
============================
Sub Total                       $1000
Tax 1 (5.00%)                    ($50.00)
Tax 2 (8.00%)                    ($80.00)
============================
TOTAL                              $870.00

Only rent is taxable, so the taxes are negative.  But there's a positive invoice balance.

When I try to adjust a tax amount manually (by only a penny) in the Invoice Tax Summary Entry form, I get the following error:

A positive tax amount can't be entered for negative tax detail and a negative tax amount can't be entered for a positive tax detail.

Why does this error appear?

Thanks for any help you can give.

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    Wayne, I have to agree that this is not the ideal situation, but you got to where I was going to suggest - dividing the transactions into two pieces.

    We have had to do this over the years for clients, and you noted, not ideal, but the long term 'health' of the GP data is a bit more important to us - so we split.

    If you are doing the process electronically, it should not be that big of a hit, the time it takes to make the second transaction is minor compared to the issues you would / will encounter if you need to make corrections in the system at a later date.

    Well done.

  • Community Member Profile Picture
    Community Member on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    Thanks for checking back, Bill.

    Your comment about GP wanting to use positive numbers and rely on the Doc Type to know whether plus or minus is precisely what I believe to be the problem.  And my boss says that even if we were able to get it to work, he'd be suspicious of the potential for downstream problems within GP.

    We put the records into the GP tables by inserting directly into the SQL Server tables from another system; that way, we can insert the records with the negative taxes on an invoice.  However, when later opening those records within GP, GP balks if we try to change one of these records, again (I assume) because it doesn't like any negative entries on an invoice.

    We've pretty much resigned ourselves to the need to split such an invoice into two pieces:  an invoice for the pluses and a credit note for the negatives.  Not ideal, but we don't know what else to do.

    Thanks.

    Wayne

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    Just wondering if you got to a resolution to this problem?

    I know that one of the issues here is using the Invoice format and having a negative sale value.  GP uses the Document Type to determine in a lot of cases how to deal with the "SIGN" of the money.  So, even when you enter a CREDIT Memo, you do not enter ( - ) sign, you enter 100.00 and the application knows it is a negative value.

    I am trying to duplicate this right now, and want to confirm that you are using the Invoice Entry screen and not the SOP screen to do data entry.

  • Community Member Profile Picture
    Community Member on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    If I use Insert/Edit Media to try to post an image, I get "an error occurred while trying to save this post".  Can't I attach a file in this forum???

    What am I doing wrong?

    Thanks.

  • Community Member Profile Picture
    Community Member on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    OK, I lied above to make the numbers simpler.  Here are the real numbers (and screenshots):

    Insurance Charges       $52,559.77

    Rent Charges              ($17,675.80)

    Sub Total                       $34,883.97

    Tax 1 - on Rent (5%)         ($883.79)

    Tax 2 - on Rent (8%)       ($1414.06)

    TOTAL                            $32,586.12

    Invoice Entry Form:

    Taxes (by clicking on the arrow next to -2,297.85 above):

     

    If I want to adjust the Tax on the Invoice Entry form to (2297.86), GP opens the Taxes form, wanting me to adjust there, too.  If I change the first line's Tax Amount to -$883.80, it should balance and be happy, but instead I see this error:

     

    As I see it, if Taxable Sales are negative, a negative tax should be not only fine, but expected.

    If I try a similar adjustment on an invoice with all positive values, GP has no complaint and allows me to save the adjustments.

    (I'm getting an error when I try to save with screenshots....)

    Thanks for any help you can give.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: A negative tax amount can't be entered for a positive tax detail ...

    Can you post a shot of the screen where the error is generated as well as the error message.  I would like to see if I can duplicate this from the same module.

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans