Dynamics Community Forum Thread Details

Integration Manager-Importing a General Journal

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?

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