Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Import ADP RUN Payroll Transactions Issue

(0) ShareShare
ReportReport
Posted on by 121

I have downloaded an IIF file from ADP RUN. - This is my first payroll import.

When I try to import the file into a General Journal I get the error "The field in line 6 with index 7 does not exist. The data could not be retrieved."

Here's Line 6  -> SPL GENERAL JOURNAL P/R Tax Expense-S/S Medicare 153.00 01/28/2021

There are only 5 fields here (tab delimited - I've looked at the tabs)

Anyone any ideas???

Simon

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Import ADP RUN Payroll Transactions Issue

    Hello,

    If you are deploying the APP ADP Workforce NOW Outbound Integration, yes you should check with ADP first. Your gut is correct.

    pastedimage1611846123117v1.png

    Hope this helps.

    Thanks,

    Steve

  • scruffysjb Profile Picture
    121 on at
    RE: Import ADP RUN Payroll Transactions Issue

    I have logged this first with ADP.  My gut feel is that this is their issue.

  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Import ADP RUN Payroll Transactions Issue

    Hello,

    If you think that this is a bug, feel free to raise it to Microsoft via your csp or partner.

    Thanks.

  • scruffysjb Profile Picture
    121 on at
    RE: Import ADP RUN Payroll Transactions Issue

    Is this a bug in Business Central?  Or a bug in ADP?

  • scruffysjb Profile Picture
    121 on at
    RE: Import ADP RUN Payroll Transactions Issue

    After more trial and error it looks like the import expects the ADP IIF file to have 2 more fields on each SPL record, the second of those fields becomes the Description in the journal.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 742

#2
YUN ZHU Profile Picture

YUN ZHU 698 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 529

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans