Open Forum

Expand all | Collapse all

Recurring Batches

  • 1.  Recurring Batches

    Posted 27 days ago
    We have several GL recurring batches and I was wondering if there was a way to post them all the way that I mean if the recurring batch is for 36 months, is there a way to post the batch 36 times so the batch goes away without me having to click post 36 times?  My apologies if this has been asked and answered...did a search but couldn't find what I was looking for...thank you in advance for your time.

    Debra Lewis
    Hunton Group
    Houston TX
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Recurring Batches

    Posted 27 days ago
    You could record a macro to post a batch one time, then edit the macro file and copy/paste the block 36 different times in the file. The macro could be recorded from the point the Batch Entry window is open, you would then go to Tools > Macro > Record on that window, enter the name of the macro. Follow steps to select the batch, post, and dismiss any reports that may show up. Go to Tools > Macro > Record and stop recording.

    Open the macro file and copy/paste 35 times down. If you have to do the same for another batch, then copy the previous 36 block and then replace the batch name.

    Hope this helps.

    Mariano Gomez Bent, MVP, Dynamics Credentialed Professional
    Director of Technology

    Academy - Online Interactive Learning from Experts

  • 3.  RE: Recurring Batches

    Posted 26 days ago
    @Debra Lewis

    Depending on what exactly your recurring batches are, you might consider using the Revenue and Expense Deferral module. There are several advantages to this module, and in your case the one that is the most relevant is that it will post all of the entries out to the end of the amortization period. Once caveat>> The periods have to exist, BUT they do not have to be open! Another advantage is that if you are amortizing a prepaid and it does not come out even, RED will take that into account and adjust for the small difference in the last period so that you do not over or under-amortize.​

    With RED you can create as many profiles as you want and use them over and over. Each profile will have a length of time and the 2 accounts that you need to debit and credit in each entry. For example PPD INS 12 MO or DEF REV 36 MO. You can use it in the AP/AR modules and attach the profile to the transaction right away or in the GL after the fact.

    RED comes with GP and is one of the most underutilized modules, IMHO. If you do not see Deferrals in the Financial Setup box then you might need to activate it. Check with your sa user or your Partner for assistance, or reach out here.

    I have attached the User Guide for this module, as well as some notes that I took while I was learning the module.

    Barbara Gavron
    Atlantic Beach / Jacksonville FL


    Academy - Online Interactive Learning from Experts

  • 4.  RE: Recurring Batches

    Posted 25 days ago
    Hi @Debra Lewis

    I agree with @Barbara Gavron, if these batches reoccur because they are for, say, insurance or other then you can use the Rev Exp and Deferral product and they post to the future relatively easily.

    There are also third party products that you can purchase for reasonable rates and can program to auto-post your batches.  I have worked with a couple of them, but there may be more.  The ones I know about and have worked with are:

    • SmartPost by eOne (everything they do is pretty great. the only issue with this one is you must leave an instance of GP running for this to work)
    • PostMaster by envisage (this one runs behind the scenes for auto-posting and is by the indomitable @Steve Endow
    Both are great options and can be used for more than just recurring GL batches.  Here are some links:

    @Mariano Gomez Bent 's suggestion is a good one, though, if you don't have it in the budget to buy something already-made.​​​​



    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role