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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Import question
Microsoft Dynamics GP (Archived)

Import question

(0) ShareShare
ReportReport
Posted on by Community Member

I currently import my payroll from ADP... 

Can I import a journal entry ( non payroll related)  into  GP.. use a separate billing system would like to set up an export JE that can be imported into the gl.

Deb

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Deb do have Integration Manager?  That is the easiest tool to use, if not, you can also use Copy/Paste from excel.  I have used this with limited success.

    Depending on the complexity of the JE's and the variety, we have actually had a custom scripting system built for a client that allows them to - in excel - create there working papers, which create JEs and then this application pulls the completed JEs from the spreadsheets into GP GL.  Pretty nice tool.

    Let me if you might be interested.

    Bill

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    If you can create a single entry for all the distributions you can use the Excel paste feature of GP. If multiple entries are required check out this product from InfiniaTech

    www.excelintegrator.com

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

    Hi,

    All of the other ideas are correct, but I'm going to throw a curve ball. You can use the ADP import to import any journal entry so long as it is formatted correctly. The source needs to be a .csv file where each field is included in quotes. There are 10 fields in the source file, even though many of them are not used, they still need to exist. So, if you can format it correctly, you can import any JE.  The following explains what a JE needs to look like in order to use the ADP import to get it into the JE entry screen:

    support.microsoft.com/.../the-adp-import-process-in-payroll-connect-and-the-specific-fields-that

    Kind regards,

    Leslie

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans