Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

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

Integration manger - Adding pay code based on another results in SUTA error every other record.

(0) ShareShare
ReportReport
Posted on by Community Member

So this is a continuation of https://community.dynamics.com/gp/f/32/t/96807, since it was open for 5 years with no answer I thought I'd give more info and hope for a solution.

I have a 2 csv’s one with base codes (not based on any others like hourly), one with dependent codes (like OT based on hourly).

I run the base one first, all ran fine (606 of them 3 codes per 202 ppl). 

However when I try to run the codes that are based on other codes like overtime, I randomly get a SUTA error (see below), and the really weird thing is it happens every other doc. I’ve even put the SUTA state in my source (as well as a constant), neither works still complains even though I’m passing it. Also checked to be sure the employee has a suta state in upr00100 (as that was mentioned in the other post), they all do.

DOC 185 ERROR: Pay code 'ORIENH' requires a SUTA state.

DOC 187 ERROR: Pay code 'ORIENH' requires a SUTA state.

DOC 189 ERROR: Pay code 'ORIENH' requires a SUTA state.

DOC 191 ERROR: Pay code 'ORIENH' requires a SUTA state.

DOC 193 ERROR: Pay code 'ORIENH' requires a SUTA state.

GP2016 Here is the very simple mapping. 

3125.Error.PNG

Here is what the csv has (just a few records of course).

EMPID,PAYCD,BASEDON,SUTA,PAYPERIOD
AHMH,ORIENH,HOURLY,CO,2
ALIM,ORIENH,HOURLY,CO,2
ALLB,ORIENH,HOURLY,CO,2
ALTF,ORIENH,HOURLY,CO,2

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Integration manger - Adding pay code based on another results in SUTA error every other record.

    I'll leave this open in case any of you want to re-create it and if you are a var/partner maybe open a ticket with MS. I worked around it by importing, running a query to find the 1/2 that failed, export to csv that 1/2, import again, find the next 1/2 that failed, and over and over and over. Until they were all complete. This is just bizarre.

  • Community Member Profile Picture
    Community Member on at
    RE: Integration manger - Adding pay code based on another results in SUTA error every other record.

    Added a delay via script below after document, no joy there (also tried before doc). Still fails every other one.

    Dim dteWait

    dteWait = DateAdd("s", 10, Now())

    Do Until (Now() > dteWait)

    Loop

  • Community Member Profile Picture
    Community Member on at
    RE: Integration manger - Adding pay code based on another results in SUTA error every other record.

    Digging up even more clues. So I cleared the csv except for 1 person that had failed. Ran it, and it worked.  So then I cleared it again, entered 2 people, the first one worked, the 2nd failed. Cleared the one that worked, and it worked again.

    So something is up with the sequencing, it is almost as if it is processing too fast and the 2nd record fails.

  • Community Member Profile Picture
    Community Member on at
    RE: Integration manger - Adding pay code based on another results in SUTA error every other record.

    My hunch is that there is some voodoo going on when you do a based on code. If I do it from the screens you get a prompt for default or cancel when you assign a normal code, however when you add one based on another code you get that Company or Employee default options. Wondering if it has something to do with that?

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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans