web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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

I have the same question (0)
  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    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

  • Jeff Wawok Profile Picture
    Jeff Wawok 55 on at

    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....

  • Jeff Wawok Profile Picture
    Jeff Wawok 55 on at

    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!

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at

    Hi Jeff,

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

    Thanks,

    Kirk

  • DebN Profile Picture
    DebN 3,954 on at

    Hi All,

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

    Thank you!

  • Suggested answer
    LMC Profile Picture
    LMC 10 on at

    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.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    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
    Lam Le Profile Picture
    Lam Le 180 on at

    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.

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans