You’re offline. This is a read only version of the page.
5
We have recently started controlling our posting date ranges more closely and have run into problems with posting output and consumption journals.
The setup: The General Ledger Setup posting dates is set from 01/Jan through 31/Dec. The user setup is from 01/Jun through 31/Oct.
The problem: sometime when the user tries to post consumption on a production order, we get the error that the posting date is outside his range (his dates are set, for example, on 28/Sep). Following the error, we find that the system is trying to create a $0.11 value entry adjustment on the item ledger corresponding to when the item/lot was first received back in April. The adjustment value entry is dated to match the original posting date of the receipt.
So our posting date restriction seems to be working as we need, he shouldn't be posting during that period. My question is why is the system trying to adjust the value of the original receipt and how do we prevent consumption/output ledger types from modifying the value of prior ledger entries, receipt entries in particular? Additionally, such value adjustments potentially cause the problem that the item's value will no longer match invoices (not by much but enough to get an auditors attention).
Tom,
Adjust Cost Back Dating Transactions, while asking companies to run the adjust cost process, some people will report that they experience unwanted entries made to the previous accounting periods. Why? The reason is because the adjust cost process will always adjust to the date of the original sales transaction (unless specified otherwise).
For example, it’s 6/30/18 and you run the adjust cost process. If you haven’t run this process in a while, and there was a sales transaction that occurred in 3/15/18 that has not been adjusted yet, the resulting adjusting entry will be on 3/15/18. This will cause problems if you’ve already closed the books for March.
This is where the Allow Posting From field from the General Ledger Setup screen comes to the rescue.
If you set the Allow Posting From on the General Ledger Setup, any adjust entries that are BEFORE the Allow Posting From date will have same posting date as the Allow Posting From field.
In our example above, it’s 6/30/18 and you run the adjust cost process. In addition, you set the Allow Posting From to 6/1/18. If there was a sales transaction that occurred in 3/15/18 that has not been adjusted yet, the resulting adjusting entry will be posted on 6/1/18.
Setting the Allow Posting From should be done after you close the month out, NOT before. I’ve seen situations where the user changed the Allow Posting From BEFORE the adjust cost was ran. So all of the adjusting entries were posted in the current period instead of the period that they should’ve been in.
Hope this helps.
Thanks,
Steve
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 (
