Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

IM-Integration creating an extra $0 distribution of Type TAXES for Invoices without taxes.

Posted on by Microsoft Employee

I have an integration that import PM Invoices to GP. some invoices have taxes which import successfully and have the correct distribution of type TAXES with the correct tax amount. However for the Invoices that do not have taxes i.e tax= $0, i'm seeing an extra distribution line of type TAXES but with a $0 amount.  How do i get the integration to NOT create a distribution line for taxes for invoices that do not  have taxes?

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: IM-Integration creating an extra $0 distribution of Type TAXES for Invoices without taxes.

    I think you may need to create a separate source for taxes so that you can set a relationship that will only try to import tax amounts with the transactions who have taxes. You can still use the same spreadsheet or whatever to create the taxes source. As a rule of thumb, you need a separate source for each yellow folder in the distribution mapping.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: IM-Integration creating an extra $0 distribution of Type TAXES for Invoices without taxes.

    There's no Tax distribution lines in the source.There's column for taxes in the source.  The taxes column is mapped to the Tax field in GP.

  • 26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: IM-Integration creating an extra $0 distribution of Type TAXES for Invoices without taxes.

    Hello Ken:

    How are you identifying the tax distribution lines in your source?

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans