Working with Recurring Batches in Dynamics GP 2010

Most finance departments have at least a handful of journal entries they need to make on a regular basis, whether for accruals or allocations or other reclass entries. We could definitely do this longhand each month, entering each journal entry manually. But with the use of recurring batches, we can simplify the process—and hopefully speed up your month-end!

Let’s start with the batch setup:  Financials Page | Transactions | Batches

The key to setting up a recurring batch is the frequency. This defaults to single use, which is used for most journal entries. A single-use batch is posted once, and the transactions are no longer available in Work (unposted status). If you pick another frequency, like monthly, the batch automatically becomes a recurring batch. You can save entries to the batch.

For recurring batches, there are five additional important fields:

  • Clear Recurring Amounts – This option will clear the amounts in the entry window when the batch is posted. You then can enter updated amounts before posting the batch the next time.
  • Last Date Posted – This will track the last time you posted the recurring batch.
  • Times Posted – This will track the total number of times you have posted the batch.
  • Recurring Posting – Select this option if you want the batch to be posted only a certain number of times—perhaps a recurring batch is only valid for 12 months, so there would be 12 postings. Note:  When the recurring postings are reached, the entries will post the final time and not recur.
  • Days to Increment – This field is available if the frequency selected is miscellaneous. This can be used if you need to increment the recurring batch in a nonstandard way—for example, every 15 days.

Once you have your batch configured, you can enter transactions as you would normally at Financial Page | Transactions | General.


Then, when we post the batch (Financial Page | Transactions | Series Post or Batches) it behaves as it would normally. The posting journals will print as they would normally. The difference is that rather than the batch going away, as it does with a single use batch, the batch remains available after posting in the Series Post and Batch Entry windows:

After posting the batch, it’s still available. Note that the last date posted and times posted have been populated. In this case, prior to the initial posting, we marked “Clear Recurring Amounts.”  So let’s look at the effect on the actual entry.

Financial Page | Transactions | General

Note two key changes:

  • The transaction date has been incremented based on the batch frequency to May 30, 2017—monthly from the original date, April 30, 2017.
  • The debit/credit amounts have been cleared because we marked “Clear Recurring Amounts” when we created the batch. This must be marked before you post for the clearing to occur.

We could populate the amounts and/or edit the journal entry as we would normally. Then, at the end of May, we could post the batch again. Because the batch remains available throughout the month, it’s important that you name the Batch ID something obvious so users know it is a recurring entry, e.g., MONTHLY or Z_MONTHLY or Z_ALLOCATIONS; naming with a Z ensures the batch falls to the bottom of the batch lookup. Naming the recurring batches in an obvious way will help to avoid accidental posting of the batch. If future periods are open, the recurring batch could be posted multiple times into the future.

Another important note about recurring batches:  Note that the journal entry number of the original entry dated April 30, 2017, and the recurring entry for May 30, 2017, both use journal entry number 3543. Recurring entries will use the same journal entry number each month. This is unique to recurring entries, as GP does not generally allow duplicate journal entry numbers within an open year; this is done on purpose so we can track and identify all entries resulting from a recurrence.

If you have any questions about recurring batches, or if you need assistance with setting up recurring batches to meet your needs, please visit our Dynamics GP Support Center or email

17 thoughts on “Working with Recurring Batches in Dynamics GP 2010

  1. avatarMona

    hi Christina
    kindly inform me how to do the above steps and the transaction date will be in comming year and still i did’t add it or open it
    and we do’t want to open the year

    also is there any notification for these trx?
    thank you

  2. avatarHeather Bayless

    I would like to know two things:

    1) Once a recurring batch is set up, is there a way to modify the name of the batch or the frequency or some other item already set up within the batch

    2) Using the same journal entry over and over is counter to the way we file our journal entries. Can I input a different journal entry number or some alpha numeric combination and overwrite the journal entry number assigned?

    Heather Bayless
    Reach Beyond

    1. avatarChristina Phillips

      Yes, you can modify the frequency, description, and also move items to a new batch or add items to the batch. I would strongly encourage you to test out this functionality in your test company so you can see it for yourself as it does behave much like other batches in GP. As the journal entry number is automatically generated when the entry recurs, you cannot override or modify it.

  3. avatarShelly M

    My recurring batches will not post more than once – We posted it fine the first month, but the second month, the batch kept going into Batch recovery, with no indications (messages) as to what the error is. What could be the problem? Have you seen this happen before? I worked at another company that used the recurring batches and we never had this problem. Please help.

    1. avatarChristina Phillips

      It is hard to say without seeing it, but I would suggest printing an edit list before posting it the second time to see if an error is displayed.

  4. avatarMarla Kapperud

    I’m interim controller at a company that uses GP. I’m responsible for several JEs each month, one of which is recurring. I’m a bit freaked out because one of my first attempts to use the recurring JE I ended up deleting it inadvertently, requiring the company to restore the latest back up. Here’s my question:

    when I select recurring JE, the Transaction Entry window opens with a new JE number, not the recurring JE number. The Batch ID is “Recurring” as it should be. How do I bring up the prior month’s JE so I can edit the amounts? I know it can be done, but the instructions I’m working from aren’t resulting in an editable screen. When I attempt to leave the screen, I get a window that says, “do you want to save changes or delete this txn?” I’m afraid to “delete” because of what happened a month ago (deleting the entire recurring txn, requiring restoring a backup). Can you help me figure out how to get the prior month’s JE on the screen so I can edit it with the current month’s data?

  5. avatarHANEEFA

    please help me,

    how is post repeating entries for invoice journal without manual , i mean creatable by system

    if any option , please convey

    1. avatarChristina Phillips

      You would just delete the batch. If you are referring to scheduled payments, you would need to void the posted scheduled invoices.

  6. avatarmicrosoft dynamics

    Thank you so much for this tutorial about how to work with recurring batches in Microsoft Dynamics GP software, the clear and detailed explanation helped me to understand this topic in large extend.

  7. avatarJeff

    If you set up a recurring batch for a journal entry and you make it monthly for 12 months. Is there a way to post all 12 entries at once instead of going back to the GL batch and posting 12 individual times?

  8. avatarNancy

    I just set up my first recurring batch. I set it up as miscellaneous and checked “clear recurring amounts.” When I went back in, the account numbers are not there. It shows the last date posted and times posted, but the actual accounts are missing so I will have to enter all of the numbers again. Any ideas? It also does not keep the same journal entry numbers as I thought it would. It brings up the next available JE #.

    1. avatarChristina Phillips

      It sounds like you are accessing the batch with a new journal entry, rather than the specific journal entry in the batch. Can you click the JE lookup on the transaction entry window and see if your JE is listed? Also make sure you entered a number of days for the recurrence, since you picked miscellaneous.

Leave a Reply

Your email address will not be published. Required fields are marked *