web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Adjustment Value Entri...

Small and medium business | Business Central, N...

Suggested Answer

Adjustment Value Entries affecting Prior Transactions

(0) Share

Report

Report

Posted on by Tom Apedaile

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).

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

General Ledger Setup – Allow Posting From

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.

Conclusion

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,857 Super User 2026 Season 1

#2

YUN ZHU 1,047 Super User 2026 Season 1

#3

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans