Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

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

editSubscribe (1) ShareShare
ReportReport
Posted on by 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!

Categories:
  • Community member Profile Picture
    Community member 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 32,714 Super User 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 59,873 Super User 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 20,984 Super User 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 20,984 Super User 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 

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans