DMT for Journal Entries

dmt

(Sally Wheeler) #1

Does anyone have a working DMT template for GL Journal Combined?

Many thanks in advance!


(Jenn Lisser) #2

We never went as far as a DMT template - accounting has the ability to paste insert in list view (they do manually type the header, but they have an Excel template the copy/paste insert the lines from). Maybe that would work for your team?
Jenn
ERP Business Analyst


(Sally Wheeler) #3

Thanks,

We think that is great also for monthly entries. I have some reclassification entries that hit each month of 2018 and I was hoping for an easier method.


(Mike Watkinson) #4

These are the columns from a DMT template I have used to upload historical financials when we implemented. Once the template finishes uploading, you will still need to go in and post each entry. For our larger month end entries we just do paste insert from an excel template as Jenn suggested.

Company
GLJrnGrp#GroupID
GLJrnGrp#JEDate
GLJrnGrp#BookMode
GLJrnGrp#JournalCode
GLJrnHed#Description
GLJrnHed#JEDate
GLAccount
Description
TotCredit
TotDebit


(Sally Wheeler) #5

Thank YOU!! Worked Great!