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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import Payrolls in Bus...
Small and medium business | Business Central, N...
Suggested answer

Import Payrolls in Business Central

(0) ShareShare
ReportReport
Posted on by Ivan Labrador 30

Hello, I am following that step by step https://community.dynamics.com/business/b/arounddynamicsnavworld/posts/import-payrolls-in-business-central to import a payroll but I always end up getting this error: "The Account No. column is mapped in the PAYROLL_IMPORT format to BigInteger field, which is not sopported."

does anyone know why?

I have the same question (0)
  • Katrin Kinau Profile Picture
    Katrin Kinau on at
    RE: Import Payrolls in Business Central

    Hi,
    I would suggest to check the column definition first:
    What "Data Type" is defined for the clolumn "Account No"?

    And what format does the field "Account No" have in the file you use?

  • Ivan Labrador Profile Picture
    Ivan Labrador 30 on at
    RE: Import Payrolls in Business Central

    Hi Katrin, thanks for replying, in my Data Exchange Definitions configuration, I have my fields set up as texts.

    pastedimage1582808308246v1.png

    This is the error I always get:

    pastedimage1582808308248v2.png

    And this is my input file:

    pastedimage1582808308249v3.png

  • DollarDave Profile Picture
    DollarDave 76 on at
    RE: Import Payrolls in Business Central

    Would you be willing to copy and paste the entry into a General Journal instead of what is mentioned in the link?  I just worked with ADP to create a CSV file and now I am able to run it and copy and paste it right into BC.

  • Steve.Fitzgerald Profile Picture
    Steve.Fitzgerald 90 on at
    RE: Import Payrolls in Business Central

    What version of ADP are you using? How were you able to handle Dimensions?

  • Suggested answer
    DollarDave Profile Picture
    DollarDave 76 on at
    RE: Import Payrolls in Business Central

    We are using ADP's WorkforceNow platform.  For payroll entries, the Dimensions we use are location and department.  Our General Journal template is set up to have those as available fields in Dynamics.

    You may need to contact ADP to see if they can write an export file if you not able to do so in their Run environment.  I can say for us, now that we can download this file quickly, the copy and paste into the journal entry is so easy and quick.  HUGE time-saver.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,761

#2
Sumit Singh Profile Picture

Sumit Singh 2,611

#3
YUN ZHU Profile Picture

YUN ZHU 1,975 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans