DMT - Import GL Journals

Epicor ERP 10
,
1

Wonder if anyone has had any issues with importing GL journals using DMT 4.0.48.0?

We had a template that worked fine on 4.0.43.0 but on the latest version it is no longer working. We adjusted some columns and get DMT to process the file without any errors but it only creates the group and nothing else. We are using the “GL Journal Combined” option.

The columns we have in our template are as follows:

Company
GroupID
FiscalPeriod
FiscalYear
JEDate
GLJrnHed#Description
GLJrnHed#JEDate
GLJrnHed#FiscalYear
GLJrnHed#FiscalPeriod
GLJrnDtlMnl#GLAccount
GLJrnDtlMnl#TotCredit
GLJrnDtlMnl#TotDebit
FiscalCalendarID
JournalCode

2

we are having issues doing the GL Journal Combined in version DMT 4.0.48.1
also, we are on 10.2.400.13 - at least in test .

here are the columns we have in our file
Company
GroupID
JEDate
JournalCode
GLJrnGrp#ActiveUserID
GLJrnHed#Description
GLJrnDtlMnl#JournalLine
GLJrnDtlMnl#GLAccount
GLJrnDtlMnl#Description
GLJrnDtlMnl#TotDebit
GLJrnDtlMnl#TotCredit

when did this - got an error GLJrnhed#JournalNum does not belong to table
if i add that column with no data - then get error saying it is invalid
if i add a 1 then the journal entry group does import with the detail - but every line in the journal entry is its own journal within the group.

Here’s the columns that worked for us with version 4.0.45.1
Company
GLJrnGrp#GroupID
GLJrnGrp#JEDate
GLJrnGrp#JournalCode
GLJrnGrp#ActiveUserID
GLJrnHed#Description
JournalCode
JournalLine
GLAccount
Description
TotDebit
TotCredit

3

I was referred to this KB article by Epicor Support.

It did work with those specific fields but my journals were 0 value. So I added columns for the detail line value and now the group is being created with the current date instead of the date in the import file.

I have sent feedback to Epicor Support.

4

Just an update, a problem ticket has been opened by Epicor Support (PRB0215148)

5

Just wondering if any update on this issue

Anyone know where I can find what the next GLHed journal number would be
I am wondering if I can use a zero in first line of template and then the next journal number on the rest of the rows :face_with_monocle:

6

I have no feedback from Epicor Support yet. It has been passed onto DMT Support.

Anyone know where I can find what the next GLHed journal number would be
I am wondering if I can use a zero in first line of template and then the next journal number on the rest of the rows

I think you add a 0 for all lines and the journal number will be auto-assigned.

7

Using zero produced individual journals
L

I added code in the customization to create a new group and then a new header. I then used the Journal number created by the code in the csv file for DMT to process.

It produces a single journal with multiple lines

8

If anyone still comes across this, on v 10.2.600.40 I had to put ‘0’ as journal number but then add sequential line numbers to get it to generate as a single journal with multiple lines that would balance and post

image