Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect issue with Taxes

Posted on by Microsoft Employee

Hello,

we are using SalesPad that uses eConnect to feed sales order to GP. Unfortunately, we are having an issue regarding how taxes behave when we try changing the default taxation option for Item set as none-taxable in GP.

During the scripts, (I block the process of  saving the order by  showing a message box just before the end of the script), while changing an NONE-TAX item to taxable, I can see the changes occuring in the taxes table (SOP10200 and SOP10105), however, as soon as I acknowledge the messagebox, the process of saving the document is completed and the item returns to its GP states of NONE-TAX in the salesorder and the tables.

After investigating, Salespad was pinpointing that eConnect is responsible for such behaviour.

Any comments are welcome,

jpg

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect issue with Taxes

    Hi,

    As per the msdn.microsoft.com/.../ff623968.aspx, The taSopLineIvcInsert accepts the parameter IVITMTXB where you can change the tax option. So, Can you please check and let me know the xml file which is interacting with eConnect to integrate the transaction.

    Thanks,

    Gururaj

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect issue with Taxes

    Hi Gururaj,

    sorry for not replying before, just saw this reply, I was flooded with all the message from the forum before I changed my options to receive only this.

    It has been a while since I've look into this and need to get back to it.

    If the change is being made in GP there is no problem, it does work perfect. Open the saleorder line detail, change the item to taxable and save the order. Works perfect, the item remain taxable.

    The sales tax need to be changed only for that specific order and the item tax option in IV00101 should not be touched and remain the same.

    When using salespad, I can achieve changing the salesorder line detail and change tax option for the salesline during a script. However, it seems like when the order is officially saved, it must check the ITEM TAX OPTION in IV00101 and if the item is set to NONE-TAX, it removes the taxes that was added to the salesline. According to salespad this behaviour is supposed to be related to E-Connect and not their software.

    I will revert back in the next days with something for you.

    jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect issue with Taxes

    Hello JPG,

    Can you please share some log scripts/SQL Log which may help me to analyse the cause.

    Few more queries.

    1) Are you updating the Item Setup in run time?

    2) what you can see the at Sales Tax Option in Item Maintenance window.

    Thanks,

    Gururaj

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans