web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics GP (Archived) / IM Document number alr...
Microsoft Dynamics GP (Archived)

IM Document number already exists in Payables integration

(0) ShareShare
ReportReport
Posted on by TD2012 943

I am trying to import payables transactions but after the first line of each transaction I get the error 'Document already exists", it will not bring in the rest of the transaction.  This is setup using the sample integrations and worked a few weeks ago but now it will not.  We have changed the document numbers to ensure there are not duplicates.

I have checked my groupings and the header includes vendor ID and document number as well as several other fields.   I have the query relationship based on document number (as the sample does).  If I change the setup to allow duplicate invoices it will work but we don't want that on so that when there truly is a duplicate we are warned.

I have used this for other clients in the past with no issues, what can I possible be missing?

Thank you for any help.  I have spent much time searching through GP knowledgebase and searching here.

Tracey D

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Hello,

    We may need you to open a support case on this issue, as we normally like to look at the actual integration and source files ourselves and test the integrations.

    That being said, with this error, other than the obvious, we've seen it caused by things like:

    >>The header is not grouped to help define what comprises a record

    >>Header and Detail Source files they were exactly the same and the issue was that the Document Number was repeated on the Source file.

    >>Either the document exists in the PM10000, PM00400, PM20000, or PM30200 or when you preview the Header source, the document number displays more than once.

        If the document displays more than once or if the document exists in the PM tables the document number will need to be changed and/or add a Group By on your Header source.

    Thanks,

  • TD2012 Profile Picture
    TD2012 943 on at

    Thank you for your reply.  We are using the same file for both the header and distribution.  I have it set exactly like they so in the sample-including the groupings.  I believe they are linked by document number so the document number needs to be in both source files.  Perhaps if I try to link them by some other field.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Looking at the sample PM Transaction integration, it is using two source files:

    >PM Header

     --Columns showing: Doc Type, Vendor, Doc Date, Doc Number, Purchases Amount, Check Amount, Description

    >PM Distributions

      --Columns showing: Account, Dist Type, Debit, Credit, Doc Number, Dist Ref

    This integration is using the same source file as well.

    The query relationship is setup to connect the Doc Number from both the PM Header and PM Distribution, so you're correct on that.

    Thanks,

  • TD2012 Profile Picture
    TD2012 943 on at

    We discovered that we had a different description on each line of the transaction-the document description needs to be the same for each part of the invoice.  We added the column "Distribution Description" to add detail of each part of the transaction within the invoice.  This line is on the GL entry part of the transaction.  Otherwise we kept it exactly the same as the sample PM Transaction.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans