Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Posting date is not wi...
Small and medium business | Business Central, N...
Suggested answer

Posting date is not within your allowed posting dates...

(1) ShareShare
ReportReport
Posted on by MichelleCA 47

Hi all,

Thank you all in advance for all your hard work at helping out newbies like me

My customer service team is having a problem where it causes an error at, seemingly, random times when she tries to ship and invoice an order. The error says "Posting Date is not within your range of allowed posting dates in Item Journal Lines Journal Template="", Journal Batch Name="", No.:'0'"

The problem is that the order she is trying to ship and invoice was not created until the 4th of April and needed to be shipped and invoiced today (5th of April), and the user's allowed posting date is set to 01-04-2022 to 30-04-2022. This is to avoid any accidental invoicing outside the current month. We know for a fact that changing her allowed posting dates to 01-03-2022 would work but we need to avoid having to do this every time this error pops up as they (the people responsible for changing the allowed posting dates) forget to change it back and then we are back to the risk of invoicing in the wrong month.

Can anyone explain why this error is popping up and how we can make it stop without having to change the user's allowed posting dates please? Thank you!

  • MM-11060324-0 Profile Picture
    MM-11060324-0 11 on at
    Posting date is not within your allowed posting dates...
    Hi there

    Was there ever an answer to this? Currently experiencing this issue and don't know how to fix it.
     
    Thanks
    Marissa
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Posting date is not within your allowed posting dates...
    [quote user="MichelleCA"]

    I ended up finding out the following, via lots of testing (as I wasn't allowed to preview posting on one of the affected orders for some reason) that it posted a "rounding" on one of the items from the order for the amount of 0,01 but it posted it on 1st of March! So it would make sense why the user wasn't able to post but I was (as I have allowed posting date from 1st of March because I'm still finishing vendor invoices for March)

    I currently have our NAV support company on the issue as I have absolutely no idea how this could be fixed or why it's doing it? I suspect it posts the rounding on 1st of March due to the general ledger setup (which is set to 1st of March until around the 10th where we officially "close" March) but why is it posting it on 1st of March? I would have thought it should have posted this 'rounding' on the same date the invoice is posted?? The document number seems to refer to the production order of said item I think (I am far from an expert on our production orders however!)

    See attached screenshot of the G/L entries for the invoice that I tested it on

    NAV-screenshot.png

    [/quote]

    It looks like those two rounding lines are created by a customization, So i am sure the partner will be able to figure it out when they debug it.

  • Srdjan Grandic Profile Picture
    Srdjan Grandic 95 on at
    RE: Posting date is not within your allowed posting dates...

    It's quite possible you have some automatic inventory revaluation kicking in in the background or some customization that posts additional entries. Someone needs to debug this thoroughly first.

  • rhysa95 Profile Picture
    rhysa95 5 on at
    RE: Posting date is not within your allowed posting dates...

    Did you ever find a fix for this issue? I am currently experiencing the same problem!

  • MichelleCA Profile Picture
    MichelleCA 47 on at
    RE: Posting date is not within your allowed posting dates...

    I ended up finding out the following, via lots of testing (as I wasn't allowed to preview posting on one of the affected orders for some reason) that it posted a "rounding" on one of the items from the order for the amount of 0,01 but it posted it on 1st of March! So it would make sense why the user wasn't able to post but I was (as I have allowed posting date from 1st of March because I'm still finishing vendor invoices for March)

    I currently have our NAV support company on the issue as I have absolutely no idea how this could be fixed or why it's doing it? I suspect it posts the rounding on 1st of March due to the general ledger setup (which is set to 1st of March until around the 10th where we officially "close" March) but why is it posting it on 1st of March? I would have thought it should have posted this 'rounding' on the same date the invoice is posted?? The document number seems to refer to the production order of said item I think (I am far from an expert on our production orders however!)

    See attached screenshot of the G/L entries for the invoice that I tested it on

    NAV-screenshot.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,802 Super User 2024 Season 2 on at
    RE: Posting date is not within your allowed posting dates...

    Hi, This is really a strange phenomenon, I believe there is nothing wrong with the Posting Date you set in User Setup and General Ledger Setup. I suspect this may be caused by other issues.

    So when this problem occurs, it is recommended to use the development environment to debug it. This allows you to quickly see which record is causing the problem.

    Hope this will help.

    Thanks.

    ZHU

  • MichelleCA Profile Picture
    MichelleCA 47 on at
    RE: Posting date is not within your allowed posting dates...

    Yes, these are set up to 01-03-2022 to 31-12-2022 and is not changed until a week into new month because we are still posting vendor invoices in previous month. This is changed to 01-04-2022 once we consider the month of March "closed" for posting on customers and vendors (after this, only 2 people have longer posting period for all of 2022, through user setup)

    The only people with a "special" allowed posting date via the user setup are 3 people from customer service who are only allowed to post in current month (01-04-2022 to 30-04-2022), and 2 finance people who have allowed posting date throughout 2021+2022. Everyone else follows the GL setup dates

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: Posting date is not within your allowed posting dates...

    Did you check the GL SETUP dates?

    please check those once

  • MichelleCA Profile Picture
    MichelleCA 47 on at
    RE: Posting date is not within your allowed posting dates...

    Hi Nitin,

    I don't think you understand the question. We do not want to change the allowed posting dates of the user. We are trying to understand why it will not let her post when the dates in the order are all within her allowed posting dates (everything in the order has date in April which is her allowed posting date)

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: Posting date is not within your allowed posting dates...

    Hi,

    Yes you are right users sometimes forget to change the posting dates back and again it’s a risk involves to post back dates entries in the system.

    To avoid this we have to options available one is enter the start and end date in gl setup and other is in user profile.

    unfortunately system will not allow you post the back entries if you set the monthly dates may be your requirement fulfill a small customization 

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans