Created a new import for General Journals using Integration Manager. Why would every transaction (row) come into the Transaction Entry in it's own General Journal Entry?
*This post is locked for comments
It's all about how you are grouping them in the integration. What are the columns in your file? Even if you have it in one sheet, you still need to think of them as Header and Line. Header would be your BatchID, Reference, JE Date, etc... The line would be debit or credit amount, account and distribution ref if you are using it.
You have to give it a "key" field to connect the header and line in the relationships. I always like to just use a field that isn't mapped, like associate them with a 1, 2, 3 or a, b,c.
Here's an example (hope it displays correctly) where I have 3 journal entries going into 1 batch. In my header file, I would "group" by the JE Key
JE KEY | Batch | Date | Account | Debit | Credit |
1 | Batch1 | 4/1/2012 | 11-22-33-44 | $ - | $ 100.00 |
1 | Batch1 | 4/1/2012 | 22-11-33-44 | $ 50.00 | $ - |
1 | Batch1 | 4/1/2012 | 33-44-11-22 | $ 50.00 | $ - |
2 | Batch1 | 4/1/2012 | 11-22-33-44 | $ 300.00 | $ - |
2 | Batch1 | 4/1/2012 | 22-11-33-44 | $ - | $ 300.00 |
3 | Batch1 | 4/1/2012 | 44-11-22-33 | $ 25.00 | $ - |
3 | Batch1 | 4/1/2012 | 11-22-33-44 | $ - | $ 50.00 |
3 | Batch1 | 4/1/2012 | 22-11-33-44 | $ 75.00 | $ - |
3 | Batch1 | 4/1/2012 | 33-44-11-22 | $ - | $ 50.00 |
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156