Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales tax amount is ch...
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales tax amount is changing after transfer

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,796 Moderator

I was asked to examine years of sales order history and to explain why the sales tax amount on an order is different than the sale tax amount on the corresponding invoice. Out of hundreds of thousands of orders being transferred to invoices I found 132 occurrences of this. They do have a custom program that takes orders off the web and inserts them into GP. These orders are then transferred to invoices. Nothing changes from the order to the invoice. The customer and address is the same as is the lines on the order. One thing I did not is that no sales tax schedule is assigned to the orders however if you zoom to the sales tax detail you will see the correct sales tax detail total and percentage amount. I do not have access to the custom code server but I was told they are using eConnect to import the orders. This is GP 2010.

Categories:
Microsoft Dynamics GP
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,796 Moderator on at
    RE: Sales tax amount is changing after transfer

    It is just very strange to see the sales tax amount being one thing on the sales order and another on the corresponding sales invoice. Their code should have nothing to do with that. I am pleading to see the source code.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Sales tax amount is changing after transfer

    Richard,

    if they are using econnect to integrate the Sales Orders, I'd definitely check the code and the data that is pushed to GP, since there is a flag in the eConnect SP's to either use provided sales taxes or do the calculation on the fly as the SOP document gets created in GP.

    docs.microsoft.com/.../aa973830(v=msdn.10)

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,796 Moderator on at
    RE: Sales tax amount is changing after transfer

    The odd thing with with integration is there are no tax schedules on either the header or detail lines. The taxes only exist in the SOP10105 table.

  • Rosemary Profile Picture
    Rosemary 4 on at
    RE: Sales tax amount is changing after transfer

    This is not so strange, we have a third party Service module and there are instances when the invoices are exported to GP tax is calculated.

    We have some customers where they are regarded as zero-rated. The tax schedules are defined at the customer level so I think it has to do with the mapping to GP.

    As you indicated you don't have access to the custom code, I think that may clear things up.

    You said you noticed the tax amount at the detail level, to me it seems the user may have calculated the value and manually entered it.

    Regards

    Rosemary

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,796 Moderator on at
    RE: Sales tax amount is changing after transfer

    Yes, I know. I have been pleading for them to upgrade for over 10 years. I will use this as another reason. I have never seen this type of behavior before. Even going back to the days of eEnterprise.

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Sales tax amount is changing after transfer

    Hi Richard,

    Microsoft Dynamics GP Support is not provide technical assistance/guidance on unsupported versions of Dynamics GP.  Extended Support for 2010 expired on 10/13/2020.

    However, we will leave this post available for anyone else in the community to assist.

    Thank you!

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans