How to import general journal with Excel in Dynamics 365?

on

you can upload your journal from excel with simple steps as the below.

Go to General ledger /general entries /general journal 


create new journal and select your journal 


click lines to enter line details  


download Excel template to fill your data 


click download


open the download template 




complete data entry and click publish

 
return to your journal in dynamics to check data upload 


Thanks.

Comments

  1. UnknownAugust 2, 2018 at 9:12 AM

    It is very useful
    Thank you very much
    I have searched more for this ,but i still have one point :

    How we can upload General Journals with dimensions ?
    What appear is only main account without recorded FD

    ReplyDelete
  2. UnknownAugust 16, 2018 at 8:24 PM

    Hi Unknown,

    You can do either of the following

    1) Use the DESIGN button in the excel document to add in the dimension field yourself. However this means that you need to do this each time you open excel in this manner.

    2) You can go into the COMMON module > Document templates. This gives you the option to download the GL Journal template, make the change noted above, and reimport this changed template. This is the better option, as the template is then changed from that point onwards.

    Regards
    James

    ReplyDelete
  3. UnknownJuly 13, 2020 at 1:14 PM

    Can you further explain how to add cost center? I can not figure it out in the design editor.

    I chose design -> add field -> cost center -> I do not know what to do once i get to this point.

    ReplyDelete

Post a Comment