web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Integration Manager - Sales Taxes Included

(0) ShareShare
ReportReport
Posted on by 987

I'm looking for some advice.  I have a GP2018 site for which we are developing a Receivables Integration via IM.

It's a simple enough integration with a single invoice and distribution amount for each document.  My problem is that sales taxes are already included in the invoice amount.  As such I am using a script to back out the taxes, entering that amount as the document amount, and then assigning the proper tax schedule to the invoice. The process works for the most part, but on occasion leaves me with a penny rounding difference.  I've tried rounding the calculations, but am not finding a way of avoiding the occasional penny discrepancy.

Has anyone else ran into this scenario and have any suggestions as to how to work around?

Am open to suggestions.  Thank you.

JG

Categories:
I have the same question (0)
  • Suggested answer
    agaber Profile Picture
    on at

    Hello JG-

    Thank you for posting your question on the Forums.  I have not seen a way around this as you will need to make sure that your amounts equal to the penny when you are backing them out.  Let's see if anyone else in the community has any suggestions though.  Have a great day!

    Adam G.

    Microsoft Dynamics GP

  • Suggested answer
    SL_GP_BC_123 Profile Picture
    987 on at

    We've been able to arrive at a resolution for this issue.  In this case the customer was invoicing fixed amounts and only selected tax schedules were affected by the rounding.  

    As such we developed a script to add a penny to either the Miscellaneous charge or to the Trade Discount depending upon the direction of the rounding error.  The script was specific to affected tax schedules and amounts and as such was narrowly defined.

    JG

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans