web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Monthly recurring GL b...
Microsoft Dynamics GP (Archived)

Monthly recurring GL batches do not increment "monthly"

(0) ShareShare
ReportReport
Posted on by Community Member

Has anyone ever run into this issue?


I have a GL batch that I set up to recur monthly (in this case it's an accrual). I'd like it to recur on the last day of every month, but GP actually adds 30 days to the original date. So, if my first transaction is dated 12/31, January and February post on the last day of the month, but since there are only 28 days in February the March journal entry posts on 3/28 instead of 3/30.

Is there any way to have the system intuitively assign the last day of the month to the next journal entry instead of just incrementing by 30 days?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    GP doesn't just add 30 days to the original date, he add one to the month value then validate if that day exist in the following month, if not he will chooses the last day of that month, but if the date exist GP considers that everything is ok and don't change the date. There is no way (yet?) to ask GP to use the last day of the month. You can always go to https://connect.microsoft.com/dynamicssuggestions and add the suggestion to be able to use the last day of the month.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Bummer! Thanks Pierre!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Mike,

    If you do create a new suggestion for this, please post the link here, so we can vote for it.

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Here is the link:

    connect.microsoft.com/.../1049671

    Please vote! This seems like it would be pretty basic... I know other systems can be made to do this (NAV and Sage PFW, probably others too).

  • Community Member Profile Picture
    Community Member on at

    Just a quick update... I logged in to connect site this morning to make another suggestion, and saw that Microsoft responded. Here's what he said:

    "Thanks for the suggestion. We'll take a look at this for consideration for updating batch functionality in a future release."

    High five for that six month update cycle! Let's see if it comes out in the next release!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans