You’re offline. This is a read only version of the page.
245
Is there any way we can restrict posting of item cost adjustment entries to current month in Business central?
This client processes assembly orders. Each month they restrict posting dates for users for current month. But the issue is there are some adjustment entries that need to be posted to previous month (July). Is there any possibility to post these adjustment entries to current month (August)? There are few items that need to be cost adjusted.
Hi Nirmala Karunarathna,
Thank you for posting. Gavin is absolutely correct.
The key addiitonal feature is the use of Inventory Periods. You can close an Inventory Period to prevent new Value Entries from being posted on or prior to the Close Inventory Period. The General Ledger Setup and Inventory Periods will be used to determine the cost adjustment date. If you have closed the July 31, 2021 Inventory Period, but the General Ledger Setup Allow Posting From Date is August 15, 2021, the system will record cost Adjustments on August 15, 2021 because it is more restrictive than the Inventory Period. As an alternative, you may have General Ledger Setup back to an Allow Posting From Date of July 30, 2021 to be able to record month end General Journal entries. However, cost adjustment will use August 1, 2021 because the Inventory Period is closed on July 31, 2021, so no further Value Entries will be created on or before the Inventory Period Close Date. These two areas basically provide some flexibility for managing cost adjustment dates. Definitely review Gavin's guidance on User Setup. User Date Range must not be more restrictive in dates, especially if Automatic Cost Adjustment is enabled in Inventory Setup with a setting other than 'Never', because the user must not only be able to post the transaction on the Posting Date but also be allowed to have the cost adjustment generate on the date defined by the rules just provided.
I hope this helps add additional clarification for you.
Best Regards,
Tom
Hi,
Its my understanding that the Posting Date for any adjustments is calculated based on the financial period dates in the GL Setup. Therefore I'd check the "All Posting from" and "Allow Posting To" in the GL setup in the first instance.
For example if the adjustment is relating to a previous period, the system checks the GL setup to see if it can post into that period. If this has a range that allows the adjustment to post, it will attempt to post into the old period and if the users posting has been restricted in "User Setup" they will get the message "The posting date is not within your range".
Although not your exact scenario I've blogged about my experience with this a couple of times here which may help
Hope this helps
Thanks
Gavin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (