Open Forum

Like what you see? Discover the benefits of the D365UG/AXUG Community. Learn More

1.  Import Journal entries in 365

Posted 4 days ago

I am looking to see how others are uploading General Journal Entries to 365 from excel.    Like all companies, we have general journal entries with thousands of lines that we want to upload.   We looked at the delivered excel import tool within 365 but my IT folks tell me it has to be customized to add dimensions.    Can you share if you have encountered the same and how you resolved it?  i.e. - a 3rd Party solution or modification of the delivered excel upload template in 365.

I appreciate any insight you can share.

Thank you!



------------------------------
Mark Kratky
Medxcel Facilities Management
Indianapolis IN
------------------------------


2.  RE: Import Journal entries in 365

TOP CONTRIBUTOR
Posted 3 days ago
​I have successfully used Globe Software Atlas product to do these loads of General Journal entries

------------------------------
Paul Martin
Production Program Manager
Elite Comfort Solutions, LLC
Conover NC
------------------------------



3.  RE: Import Journal entries in 365

Posted 3 days ago
Mark;

It's a pretty standard change to the excel template.  It's done through visual studio.  I can send you the instructions on how to do this if needed.

------------------------------
Bradley Bertchie
Dynamics AX - Financial Functional Consultant
Fullscope
Denver CO
------------------------------



4.  RE: Import Journal entries in 365

TOP CONTRIBUTOR
Posted 3 days ago
@Bradley Bertchie What about for AX09? They won't let me get Atlas...

Thanks, Sean​

------------------------------
Sean Blais
Operations Support
Sutphen Corporation
Dublin OH
------------------------------



5.  RE: Import Journal entries in 365

GOLD CONTRIBUTOR
Posted 3 days ago
Mark,

If there are a large number of lines, you may want to look into the data management functionality in D365 as it would import the lines with higher performance.  Here is a blog to get you started.  Using the built-in Excel functionality is user-friendly and suggested if there are not a huge number of lines to import as performance would not be as big of an issue.  Altering the default Excel templates is not a complicated task- as Bradley mentioned.

------------------------------
Chris Rusing
Logan Consulting
Chicago IL
------------------------------



6.  RE: Import Journal entries in 365

Posted 3 days ago
​Hi Brad,   Thanks for replying to my thread.   I would appreciate the instructions.

My IT Team has said that it is difficult to locate the Dimension Fields to modify the template as the have to research to find the SQL Tables and Field Names to add dimension (i.e. - not a check the box of available fields as other systems I have used).   Any thoughts you can offer on this would also be greatly appreciated.

Thanks again,
Mark



------------------------------
Mark Kratky
Medxcel Facilities Management
Indianapolis IN
------------------------------



7.  RE: Import Journal entries in 365

Posted 2 days ago
  |   view attached
Instructions are attached.  This is also on TechNet

------------------------------
Bradley Bertchie
Dynamics AX - Financial Functional Consultant
Fullscope
Denver CO
------------------------------

Attachment(s)



8.  RE: Import Journal entries in 365

Posted 3 days ago
​We are using the standard D365 Excel functionality, I think we do have to add the dimensions each time we have to upload the journal entries.

------------------------------
Surender Goli
Atara Biotherapeutics
South San Francisco CA
------------------------------