Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Project Employee Expense MC Tax Distribution Wrong Through eConnect

(1) ShareShare
ReportReport
Posted on by 130

I am creating PA employee expenses through eConnect stored procs. The only issue I am having is that the distribution for the tax component has the same value for both the originating and functional currencies. The document seems to integrate fine. When I post it, it goes through the PA module and runs into problems in the PM module. I then have to manually go into the the voucher in PM, amend the distribution and post the batch again through PM.

The tax amount is 2 euros (originating), which is 1 gbp (functional). I pass in the value of 2 for the tax amount, and GP stores this value in doc line and doc header tables just fine, and also stores the correct tax amount and originating tax amount in the PA EE tax work table. But the distribution shows both 1 for originating, and 1 for functional.

Everything seems correct, not a single other issue. When I create a transaction in the functional amount, no errors. eConnect allows the currency ID to be passed through in the header and lines but not the tax insert proc. I don't want to modify the post proc.

Any ideas anyone?

*This post is locked for comments

  • Suggested answer
    K_G Profile Picture
    K_G 130 on at
    RE: Project Employee Expense MC Tax Distribution Wrong Through eConnect

    Hello Heather, sorry for the delayed response, this was a while ago. I found a way on line of decrypting SQL stored procedures. The Employee expense header procedure, executes a procedure/s for the creation and inserting of the distributions. It is in one of these where the incorrect value is calculated. If you really want to know I can find it for you. I put this as a bug on Microsoft Connect and Microsoft simply said thank you and that they will look into it. Yes there is nothing on MSDN about this but I assure you the bug is very much there. By all means, please try and create an MC employee expense transaction which has some tax values using tax details which use "Percentage of Purchase/Sale" as the tax base. You will notice that the functional and originating distribution values for the tax distribution are the same.

    The only resolution, modify the post header procedure to correctly recreate the tax distribution values.

    thanks

    Kemal

  • RE: Project Employee Expense MC Tax Distribution Wrong Through eConnect

    Kemal,

    Would love to know where/if you found a schema for the stored procedures taPAEECreateDistributions

    taPAEEDistributionInsert

    ?  Not finding anything on MSDN:(

    Heather

  • Verified answer
    K_G Profile Picture
    K_G 130 on at
    RE: Project Employee Expense MC Tax Distribution Wrong Through eConnect

    For anyone running into the same problem, I have figured out the issue.

    The issue is was a bug in the eConnect store procedure tapaeecreatedistributions. The procedure is coded to insert the total sum of the functional tax amounts from the EE work tax table (not including sequence 0) for both the functional and originating tax amounts in the distribution table. I do not want to report this as a bug since it costs money to do so, but I have verified this on GP2013R2 and GP2015 (first release). The way to cure this is to simply insert a script into the post EE header proc.

    Thanks

    K

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,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans