Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP: Integration
Microsoft Dynamics GP (Archived)

GP: Integration

(0) ShareShare
ReportReport
Posted on by Jatin 75

I am looking for some help to Pull in data into General ledger from a CSV file, (data is coming from a 3rd party software, the text file is being created by that software and the files goes into a directory on server), primarily data related to fee payments. We need to import this CSV file somehow directly into the ledger for posting or is there a better way to directly import data into General ledger tables without going through the standard e-connector?

The structure of fie (.CSV file) is:

Header:

Date (YYYY-MM-DD)

Details:

Fee Description, GL Account #, Payment Type,  Amount

Example:

Building Permits,156.451.0270.45514,VISA,4352.21

Thanks, I have been looking all over the world for a solution and I strongly believe there should be a work around fro this problem.

Thanks!

Jatin

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP: Integration

    Jatin, if you have installed IM you can look in the samples folder that is there. You will find sample GP import files. Model your file after these and you will be all set. You will need something to contain the total debit amount of each transaction as IM cannot be used to compute any values. Perhaps you can create a pre-parse routine to do that or even create an application to do that calls eConnect. There are several tool available to complete this task.

  • Jatin Profile Picture
    Jatin 75 on at
    RE: GP: Integration

    Thanks Richard. Yes, I do have access to Integration Manager.

    I was under the impression that since the entries are coming from external source, I would be able to to setup the system to create automated entry numbers, but If not, I can come up with a transaction (Journal Entry) from the source itself.

    Since these are ONLY Revenues (Payment Receipts) dollars, these would be CREDIT ENTRIES.

    Yes, I have the ability to modify the program which is spitting out this file, I can add or excludes fields.

    Thanks Once again!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP: Integration

    You should also consider eConnect.

    Ian.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP: Integration

    Do you have access to Integration Manager? It would be helpful if you could pattern this after the sample GL import file you would find in the IM samples subfolder. I do not see a journal entry number nor any way to distingish whether this is a debit or credit. If you wall these transactions going into one ledger entry you could do without the J/E number but we still need someway to determine debit or credit. Sometimes for simple things like this I will jsut modify a VS program I have the create ledger batches. Do you have the ability to add fields to this csv file?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans