![]() ![]() Please note that the template name defaults to the file name that has been uploaded. Once the template is downloaded and saved, you can open it in Excel and start creating your own design.Īfter all design change are made, the new template can be made available by creating a new document template and importing the Excel document as illustrated in the next screenprint. In my example, I simply changed the template name by replacing the ending numbers with L1. When downloading and saving the template, take care of the name that you give to this file because this name will be important later on when making the file available for usage. …identify the existing template and download it. The only thing you need to do to realize that is opening the document templates form… In other words, you can make use of the existing standard templates and easily modify them yourself as required. However, you do not have to design everything from scratch but can rather make use of the things that are already available. To fix also this problem, one has to design its own template.Ĭreating and designing an own template might sound complicated. ![]() The next screenprint that was taken for a different D365 environment that has this modification implemented illustrates that the system modification allows entering main accounts and financial dimensions in separate columns of the Excel template.Įven though the workbook designer and the optional system modification help to overcome my first issue, you will quickly notice that all Excel design changes that are made via the Office add-in designer are gone the next time you open the Excel template. Luckily this disadvantage can easily be overcome by implementing a minor system modification that is described on the following website. ![]() That is because this sequence is defined in the following integration form in the general ledger module.Ī second disadvantage of entering the main account-financial dimension combinations in a single field is that no tooltip or lookup is available that would help users entering their transactions. The next screenprint exemplifies this.Ī disadvantage of using the account display value field for recording main accounts and financial dimension combinations is that you cannot easily identify the sequence of the different financial dimensions used and thus do not know how to enter your transactions. (a) Enter main accounts and financial dimensionsįixing the first issue is easy and can be achieved by adding the account display value field via the workbook designer. Within the following, we will see how (a) and (b) can be achieved. However, I wanted to (a) enter main accounts and financial dimensions and (b) create new journals and not open already existing ones. Those linkages and functionalities are nice. The standard general journal line entry template that ships with D365 opens an Excel document similar to the one shown in the next screenprint that has (1) a link to the general ledger journal batch number and (2) a link to the main account(s) used. The story began in the general journals form, which allows users opening, editing and re-importing accounting transactions in Excel. Within this post I would like to share some of the experiences that I made with the import of transactions from Excel to D365 general ledger journals. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |