Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager - ...
Microsoft Dynamics GP (Archived)

Integration Manager - Add to Existing Payroll Transaction Batch?

(0) ShareShare
ReportReport
Posted on by Jeff Wawok 55

We are using Integration Manager to import payroll transactions into Microsoft GP 2013.  Rather complicated, but the transactions come in 4-5 different unique sources, and it would be rather complicated to combined them into 1 single import.  In an ideal world, we would like to perform 4 separate integrations, all adding to the same Payroll Batch ID.  However, after the initial batch has been imported, the subsequent integrations refuse to import and says that the "Object (which equals the Batch ID), already exists --cannot Insert"

This problem of adding to an existing batch does not seem to exist in other GP modules (SOP for example).  Does anyone have any idea of a way to get IM to add to the batch that already exists?  

*This post is locked for comments

  • Suggested answer
    Lam Le Profile Picture
    Lam Le 180 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Make sure you only have 1 item on batch header for Batch ID.  When you preview the payroll header source it should only show your batch ID. 

    Under columns section of Payroll header, check Show and Is Key, leave every other item uncheck.

    When you have multiple items under the Header, it will create an "Object Already Exists Error"\

    Let me know if it works for everyone.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Hi Jeff,

    Here's an idea. Since we cannot insert another payroll batch with the same ID into the batch master, how about deleting the existing batch ID from the Payroll Batch Header (UPR10301) and importing the next group of transactions? Now, the totals will not be automatically adjusted, but the transactions should all come together. You could even use a VB script to delete the batch ID after the first imports complete.

    Do you think this would work?

    Kind regards,

    Leslie

  • Suggested answer
    LMC Profile Picture
    LMC 10 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    I found that after successfully creating the batch, I was only able to get one item to import.  Check on the "entries" section of the Destination Mapping ; then go to the options tab.  Make sure the default record source is the record source with the detail transactions, NOT the batch header source.

  • DebN Profile Picture
    DebN 3,954 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Hi All,

    Has anyone resolved this issue yet?  I've run into the same problem.

    Thank you!

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Hi Jeff,

    Did you ever find a resolution for this? I am experiencing the same issue.

    Thanks,

    Kirk

  • Jeff Wawok Profile Picture
    Jeff Wawok 55 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    One follow-up to this:  I also attempted to change the Posting Accounts (under Tools - Setup - Posting - Posting) to APPEND the batch (if there is an existing batch), rather than Create New.  But this seems to have no impact when trying to add to the batch with Integration Manager.  Any ideas would be greatly appreciated!

  • Jeff Wawok Profile Picture
    Jeff Wawok 55 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Thanks so much for the response!  I actually was not aware of this option....I am sure this will be very useful in the future.

    Unfortunately, when I tried to follow the suggestions, the only option listed under Destination Edit Mode was "Insert Only". 

    If I do an integration to the destination "Payroll Master" for example, I have the option to change it to "Insert and Update", but for some reason the "Payroll Transaction" destination is only showing "Insert Only".  Will keep searching for a solution to this problem, but no luck so far! 

    Thank you so much for looking into this for me and if anyone has further suggestions it would be appreciated....

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 10 on at
    RE: Integration Manager - Add to Existing Payroll Transaction Batch?

    Hi Jeff,

    Our community member Soma posted on this issue already.  Please refer to the following.

    community.dynamics.com/.../how-to-solve-integration-manager-error-object-xxx-already-exists.aspx

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans