News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Multiple Transaction E...

Microsoft Dynamics GP (Archived)

Multiple Transaction Entries from Integration Manager

(0) Share

Report

Report

Posted on by Rich Mikolainis

705

I created a job in Integration Manager in the General Ledger - General Journal, 1 source file.

When I import, all my transactions are imported correctly, however it seems it creates a duplicate transaction entry # for each GL account number. I just need 1 transaction entry #.

here's a sample of what my import looks like:

Gl Account, Amount, entry

1233, 100, 001

1555, 100, 001

9999, -200, 001

All 3 lines are entered into the 1 transaction entry correctly, but it creates 2 additional transactions with the same entries.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Rich Mikolainis 705 on at

Like (0)

Report

Re: Multiple Transaction Entries from Integration Manager

Awesome, that fixed the issue Rubal!

Thank you!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Multiple Transaction Entries from Integration Manager

Hi Rich,

You will need to group the lines by columns which are repeated like JE number or date or reference. This way integration manger will know these are part of same transaction and won’t import them multiple times. Also, you will need to add two sources pointing to same source file (if you have not already added them) and create a relationship between two sources.

You can refer to sample integration GL import with one source file. You can also refer to following post

qfactorconsulting.wordpress.com/.../integration-manager-the-basics

Rubal,

http://dynamicsgphelp.com/

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans