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

Need help with integration manager and general journal

(0) ShareShare
ReportReport
Posted on by 75
I wrote an integration to add lots of records to the general journal. After running the integration, I can go into GP, look under batches, and find the batch ID I used with my integration. At this point, my batch hasn't been posted. When I click on "Transactions" I see my various general journal entries, BUT most of the data fields are blank! I don't see any data in the debit field, the credit field, etc. Any ideas? I'll describe my integration below. I read in two (2) CSV files, one named GJ-header, and the other just named GJ. The header has one row for every two rows in the other file, and I link them together using a column named "rownum". In the main GJ file, I have a row for the debit record and then a row for the credit record. In the GJ-header file, I have a rownum column, a batch ID column and a reference column. In the GJ file, I have a rownum column, an account column, a debit column, a credit column and a distribution reference column. When I run the integration, I don't get any errors or warnings. Any ideas? Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • mm123 Profile Picture
    2,535 on at
    Re: Need help with integration manager and general journal

    Matt,

    We have developed a utility , that will import the Journal Entries in created in Excel into a Great Plains Batch straight away without the interface of Integration Manager. If you are interested please drop an email to learn more.

    MV

    manick.m@hotmail.com

     

  • Jeganeedhi Krishnan Profile Picture
    2,500 on at
    Re: Need help with integration manager and general journal

     Matt,

     In integration manager, "GL Transaction "  sample integration is available. First you try to integrate few of ur data using that sample integration. If it is working fine. Then problem is in ur integration file or ur mappings. And compare sample integration mapping and urs and find out what u have missed. Otherwise integrate ur data using sample integration.

     

    regards

    Jeganeedhi

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

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans