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) / GL entry upload from I...
Microsoft Dynamics GP (Archived)

GL entry upload from Integration Manager

(0) ShareShare
ReportReport
Posted on by Lynn Rico 315

I'm new to Integration Manager and am using the "trial and error method" of learning it! I understand the concept, but in some cases I am not getting the expected result. My current issue is with trying to upload a simple GL entry. The integration runs just fine, no errors, but when I go into GP to check the results, the amounts and account numbers in each entry are missing.  Any idea what step I'm missing??

*This post is locked for comments

I have the same question (0)
  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    Preview your Sources in Integration Manager to make sure they are returning data. It's possible your query isn't pulling any data. You can do this by right clicking on the Source and selecting "Preview..." from the menu. Also, check the relationships between your sources if you have more than 1. From your description of the problem it sounds like IM is creating the Journal Entry Header but not pulling in any lines. The relationship between the data sources could cause that problem. You might also check to make sure your Record Source for the Entries in your destination mapping is set to Use Source Recordset and that the Source specified is the Source from which you are expecting the Journal Entries details to pull. Click the Options tab when looking at the Fields in the Entries Destination Mapping. While you're in there make sure the field mappings are accurate and complete. I hope this helps.
  • Lynn Rico Profile Picture
    Lynn Rico 315 on at

    Thanks Michael - I hadn't changed the Record Source to Use Source Recordset, so I think that was my first problem. When I tried to run the integration again tho I am getting an error message stating "DOC 1 WARNING: Distributions are unbalanced". I have set up my entries exactly like the sample in the Quick Start Guide - I have my Debit Amount rule set as "Use Positive Source" and my Credit Amount rule set as "Use Negative Source". In my line detail each doc number has a positive amount and a negative amount - any suggestions??

  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    This might be tricky to diagnose but I suspect that you might have an issue with your Sources and/or the relationship between them. First, check to make sure that your Header Source returns 1 record for each journal entry you want to create. The Header Source must include a key; JE number, Reference, etc. on which you can group the records in your Detail Source. In the General Journal Destination Mapping any fields mapped to a Source Field must be mapped to a field in the Header Source. Then, check to make sure that the records in your Detail Source balance for each key value. Your Detail Source must include the same key column(s). When using Positive and Negative Amounts in your source, the sum of the amounts for each key must equal 0. Finally, make sure that the relationship between the Header and Detail is based on the key column(s). If you don't identify the root cause of the problem you're welcome to send me screenshots of each source preview, the query relationships, and the destination mapping. Maybe I can spot the source of the problem for you.
  • Lynn Rico Profile Picture
    Lynn Rico 315 on at

    Hi MIchael....your solution worked! I have copied a portion of your e-mail to include in the thread, below.

    It must have been just switching the source order because everything else was already set as you described. I can't thank you enough for making my work life a whole lot easier! I will probably be back on here with questions about an AP issue that I have regarding Integration and credit cards....so stay tuned! 

    I have another question for you....can you explain to me why the header source is needed if I include all of the detail in the "detail" file? Can I just assign JE numbers to my detail and just use 1 source for this type of entry?

     Michael's response:: 

    Here’s what I see. 1.       Try reversing your relationships.  The Header Source should be the left most table in the query and the Detail Source should be a child.2.       After, make sure the Relationship Type is 3.  Right Click on the arrow between the sources and select properties to view the Relationship Types.         3.       Try changing the Record Source for the Entries to “Prepaid install” which is your detail query. Otherwise, it looks like you’re doing great.  If one or both of these changes combined don’t solve your problem you should take a look at the integration log.  We might be able to get some clues from that.  Let me know. Michael

     

  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    Lynn, I'm glad you got your problem resolved and I could help. You need the Header Source to create 1 Journal for many Detail Line Items (Entries). You're basically grouping the detail lines items together on 1 journal entry (Header Record). If you look at the General Transaction Entry window in GP and think about how that is organized this will make sense. You need 1 record to populate the transaction header data; JE Number, Batch ID, Transaction Date, Source Document, Reference, etc. Then, you need many records to create a balanced journal entry of many lines. Without the Header Source you would create 1 out of balance Journal Entry for every line in your source. I hope that makes sense. Michael
  • Lynn Rico Profile Picture
    Lynn Rico 315 on at

    Hi Michael...with what you were able to show me I was able to successfully fix an AP Credit Card Integration that kept error-ing out on me last week...thanks!

     Is there a way to delete Integrations that are not being used (or my test ones that didn't work??). Also, I've created an Integration Group but can't figure out how to move some of my existing integrations into it....

    You're the best...thank you so much!

    Lynn 

     

     

  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    Terrific! To delete and generally maintain your integrations open IM and click Objects or select Tools>>Objects Browser from the menu. In the objects browser you can both delete integrations and assign integrations to groups: 1. Click Integrations in the Types list. In the Objects list on the right, you'll see a list of all of your integrations. Highlight the one(s) you want to delete and click the delete button on the bottom of the Object Browser Window. 2. Click Integration Groups in the Types list. In the Objects list on the right, you'll see a list of all of your integration groups. Double-click the group to which you want to add integrations. Click the Integrations Tab in the Properties window that opens. Select the integrations you want to add from the drop down list box in the grid. You're welcome. Michael
  • Lynn Rico Profile Picture
    Lynn Rico 315 on at

    me again!

    I have created a new Integration Group, but when I got to properties under the integration tab, its just blank. There are no integrations to choose, no drop down list.

  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    Lynn, If you click in the Name Column on the integrations tab of the Integration Group Properties window is should activate a list from which you can select your integrations to add to the group. Did you try that?
  • Lynn Rico Profile Picture
    Lynn Rico 315 on at

    well, I thought I had clicked everywhere, but I guess not...that did it! Thanks again so much!

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans