20
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
I have the same question (0)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 |
Share
Report
All responses (
Answers (
