Time Saving Tips Part 3: Templates for Recurring Invoices and Journal Entries in Dynamics 365

July 9, 2018 Diann Spencer

We’ve got more tips to save you time and frustration in Microsoft Dynamics 365 for Finance and Operations and our third article shows how templates can be used to automate recurring invoices and journal entries. The use of templates can greatly increase both the speed and accuracy of transactions, making your ERP system much more productive and effective.

If you invoice some customers for the same amount on a regular basis, you will want to set up recurring invoices to help automate the process. In effect, you are creating an invoice and saving it as a template. If you often need to create sales and purchase lines with similar information, you can also set up standard lines to insert on recurring sales and purchase documents.

Likewise, templates and copy/paste can also be used to help automate journal entries. This is particularly useful for longer entries, helping to guarantee the correct data is captured and internal control is not compromised.

Let’s take a look at how this works.


Make templates for recurring invoices or long journal entries.
For a video demonstration, visit our YouTube Channel.

  1. First, create a new Journal Name with Journal Type = Periodic.



This is what a one-time setup of the Periodic Journal looks like.



  1. Next, create the lines in the Periodic Journal, with or without amounts.
  2. Mark how often the recurring journal should be posted. For example, if the journal is to be posted once a month the Units = Months and Number of Units = 1.


  1. To modify amounts in a recurring journal (if needed) and post, go to General Journals (or Global General Journals) and create a new journal.


  1. Go to Lines. Click on Period Journal > Retrieve Journal.


  1. Enter the date on which you want to post the journal. Select the Periodic Journal.

  1. Select Copy and then Click OK.


The journal will be rendered to the screen. You can change any of the accounts, financial dimensions or amounts. You can add and delete lines.

  1. Make any needed entries and when the journal is correct and complete, simply click Post.


The list of capabilities for automating repetitive tasks in Dynamics 365 Finance and Operations is almost endless. Both recurring invoices and journal entries are just a few of the many common tasks that Dynamics 365 can handle. We hope this example of the use of templates provides you with ideas for improving your organization’s efficiency.

Want more time-saving tips for Dynamics 365 Finance and Operations?

Reach out for more information about saving time with Dynamics 365. We are here to help.

About the Author

Diann Spencer

Diann Spencer, Western Computer’s Dynamics AX Finance Consultant, has been involved in many successful implementations of Dynamics AX in small, midmarket, and large companies across a variety of industries. Diann has over a decade of financial experience and she is a Certified Public Accountant.

More Content by Diann Spencer
Previous Video
Time-Saving Tip | Recurring Invoices | Western Computer
Time-Saving Tip | Recurring Invoices | Western Computer

Yet another time-saving tip in our series for Dynamics 365 for Finance and Operations. Watch this video to ...

Next Video
How to Use Implementation Checklists and Setup and Close Checklists within Dynamics 365
How to Use Implementation Checklists and Setup and Close Checklists within Dynamics 365

Watch 'How to Use Implementation Checklists and Setup and Close Checklists within Dynamics 365' and learn h...