Posting Date Outside Your Range in Nav 2016

(0) Share

Report

Posted on by Louis Li

In Nav 2016 CU6 or CU10, users are randomly impacted by posting Sales Orders, Item Journals etc saying "...posting date is outside your range..." By checking the User Setup area, it's for sure all affected users are set within the posting date range, yet only some random users experience the error. I delete the impacted users, and put them back, with the same posting date range, still same problem.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

Hi,

Are you using any localization? If so please check if the posting period is setup in the Journal Level.

Reference : tharangac-dynamicsnav.blogspot.co.nz/.../how-to-limit-posting-period-overview.html

Was this reply helpful? Yes No
keoma 32,729 on at

Like (0)

Report

in that case best you debug, to check the exact position, where that error occurs. otherwise it's a bit tricky.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

As per my understanding the users who does not have posting right (due to period block) can also post. In that case he might not be able to debug the code to find an error since system does not throw an error.

My suggestion is activate the debugger and try it with few users. As mentioned system throw error on random users so capture the exact position that system throw the error and add a breakpoints. Then debug the code for other users to find out why the system does not throw the error.

Was this reply helpful? Yes No
Louis Li 65 on at

Like (0)

Report

Good trial. I audited and verified all the 3 areas you suggested in the link. Journal Level posting date range is not setup. G/L Area is 01/01/2016 to 12/31/2016. User Setup for all users is the same 07/01/2016 to 09/30/2016. The error message comes up randomly even posting date for sure is this month 08/01/2016 to date. What I found out though, is by removing the posting date completely in a Sales Order or Sales Invoice, close the document, and put back a posting date, then the error message will disappear. I suspect Nav 2016 is not reading the "Allow Posting From" "Allow Posting To" fields in the User Setup table properly? We're on an NA (North America) version, and all of our desktop computers (mixed Windows version 8.1, 10, 7) use the same date format MM/DD/YYYY.

Was this reply helpful? Yes No
Louis Li 65 on at

Like (0)

Report

How do I start a debug session? I am not familiar with the process. I checked many areas in my Event View of the Nav 2016 Server, nothing came up showing errors from Nav 2016.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Louis,

The easiest and quickest way to find which code is causing the issue is to run the debugger, below is the link of a video which will show how to run

msdn.microsoft.com/.../dn833405.aspx;MSPPError=-2147217396

Once you run the debugger, place the screenshot of the code where it is causing the isssue.

Was this reply helpful? Yes No
Suggested answer

Indikauk 1,759 on at

Like (2)

Report

Hi Louise

This is Error is due to the Average Costing and it is Trying to Post Adjust Cost Entries to the Future or Past Date from the Date Allowed for the Users.

Things You can do.

1. if you wan't you can remove the Date Range from the users and allow him to Post

2. if you need to know exactly what items just go to the sales order and see the items that are selected in the sales order item ledger entry find what purchase date transaction are selected in the sales order and accordingly you can select the allowed date range for user and let him post.

3. Run the Debugger and post you can find exactly what item is giving posting date problem and you can find out reason by going in to the item ledger entries.

4. if you don't want to post any entry to back period then you need to introduce the inventory period and when ever you finalized monthly accounts you need to close the inventory period so that no item adjustment entry will be post to the back date.

Thanks

Indika

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

We have experienced the same issue with one of our clients. Try and check the allow posting from and to in General Ledger Setup and see if it is different compared to the user setup.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

If this is valid: "What I found out though, is by removing the posting date completely in a Sales Order or Sales Invoice, close the document, and put back a posting date, then the error message will disappear." - then I guess it can be only debugged, as it is not a standard behavior, even the one mentioned by Indika.

Was this reply helpful? Yes No
Louis Li 65 on at

Like (0)

Report

Hi Allan, thanks for the suggestion. I've already verified this area to be ok.

Was this reply helpful? Yes No