Every now and then, someone will contact us regarding a “Dynamics Business Central posting date is not within range” error like the one below.
What happens when Dynamics Business Central posting date is not within range?
While most Business Central users may be familiar with this “Dynamics Business Central Posting Date is not within your range error,” the cases in question here are unique because the posting date is well within the user’s allowed posting date range.
It usually involves an ordinary looking sales order that for some strange reason refuses to post because it’s coming up with a seemingly random posting date somewhere deep in the system.
These problems are not due to a loose virtual screw deep in the heart of your accounting system but are instead the result of the inventory costing process going about its job. When inventory comes in, it is assigned a cost. This cost may not be the final cost and before all is said and done, it will often be necessary for adjustments to be made to an item’s value. While the mechanics and reasons for this are beyond the scope of this article, the system will try to post any cost adjustments at the date that inventory was received.
Herein lies the problem. Since inventory consumption doesn’t respect the arbitrary divisions of time that we use to keep track of money, it is likely that some inventory cost adjustments are bound to occur on dates that have already been locked down. There are several mechanisms to do this in Business Central (Accounting Periods are not one of them). The ones that most users are familiar with are the allowed posting dates in General Ledger Setup and User Setup. The allowed date ranges in General Ledger Setup provide a default setting while the date ranges in User Setup allow each user to have their own allowed date range. It is very common for most of our Business Central users to maintain the settings in the User Setup screen and ignore the ones in General Ledger setup.
This is fine … except … there is one place in the system that uses the posting date range in the General Ledger Setup exclusively. Inventory posting uses the dates in the General Ledger Setup to determine what dates can be used with inventory cost adjustments. The problem is, these posting dates may not always line up with the user’s allowed posting dates and this results in the Dynamics Business Central posting date is not within range error.
This is where Inventory Periods come in. Inventory Periods work in conjunction with the Posting Date range allowed in General Ledger Setup to determine the date that cost adjustments will post to. Keep in mind, this only applies when the requested posting date is not within the range created by the combination of General Ledger Setup and Inventory Periods.
Value Entries and General Ledger Entries will be posted only within the range allowed in General Ledger Setup, even if a prior Inventory Period is open. For example, if the March inventory period is still open, but General Ledger Setup only allows posting from May 1st forward, inventory valuation adjustments will still be allowed for inventory transactions that occurred in March, but these adjustments will all have a posting date of May 1st, because of the General Ledger Setup restriction. For this reason, it is recommended that the Inventory Period and General Ledger Setup pages are maintained regularly and in coordination with one another.
Setting Up Inventory Periods
The Inventory Periods screen is simple to use. To create a new period, create a new line by clicking the “+ New” button at the top.
Before closing periods, be sure to run Adjust Cost Item Entries if it has not already been run. You will receive a warning message when closing the period reminding you to do this.
Next, run the Test Report. This will catch any potential problems before you find them during the closing process. In the example below, the open item ledger entry is a negative adjustment, which is creating negative inventory for that item. This entry will need to be applied to close the period since you cannot close an inventory period with inbound transactions still open.
Finally, when you are ready to close, select the latest period through which you want to close inventory and click “Close Period.” This will bring up a dialog confirming that you want to close. Click “Yes” and if there are no errors, your inventory periods will be closed.
If you ever have the need to post to closed inventory periods, they can be reopened. Just remember to set the Allow Posting From date in General Ledger Setup back as well. By maintaining your inventory settings, you can keep the number of strange occurrences to a minimum and while there is certainly no guarantee that errors won’t come up, the ones that do should be much easier to figure out.
“Dynamics Business Central posting date is not within range” or “Dynamics NAV posting date is not within range” error
If you are still using Dynamics NAV, check out our step by step instructions on walking through those error messages here. If you have any additional issues with the “Dynamics Business Central posting date is not within range error” or other posting errors, reach out to us so we can see how we can help you.