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:
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
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.
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 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.
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.
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
