Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adjust Cost/Post Cost ...
Small and medium business | Business Central, N...
Suggested answer

Adjust Cost/Post Cost Posting Date Error

(0) ShareShare
ReportReport
Posted on by CharleneEThomas 5

Hello,

In my unmodified version of NAV 2018, my Inventory Setup is configured as follows:

pastedimage1574859678110v1.png

My General Ledger Setup is configured as follows:

pastedimage1574859745531v2.png

My User Setup is configured as follows:

pastedimage1574859815560v3.png

When I run the Post Invt. Cost to G/L - Test report, I receive the following:

pastedimage1574859906247v4.png

If I open up my User Setup to Allow Posting From 01/01/19, I do not receive any warnings, as expected. However, when I run the Adjust Cost/Post Cost routine, entries are being posted all the way back to January and not on 11/01/19 which is what is set in the Allow Posting From field in my General Ledger Setup.

How do I get all of theses entries to post in November?

Thanks,

Charlene

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Adjust Cost/Post Cost Posting Date Error

    Hi Charlene

    There two ways of limiting posting periods.

    1.Limiting Posting periods by Company - You use the General Ledger setup window

    2. Limiting Posting periods by User - Use the user setup window

    The system first checks the user setup if its blank then it checks the General setup. Now for your case since the dates are different in both user setup and general ledger setup, the system first checks user setup.

    I hope this suggestion  provides some insights.

  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at
    RE: Adjust Cost/Post Cost Posting Date Error

    Hi,

    The Adjust Cost - Item Entries batch job processes only value entries that have not yet been adjusted. If the batch job encounters a situation where changed inbound costs need to be forwarded to associated outbound entries, the batch job does this by creating new adjustment value entries, which are based on the information in the original value entries but contain the adjustment amount. The program uses the posting date of the original value entry in the adjustment entry unless that date is in a closed inventory period. In that case, the program uses the starting date of the next open inventory period. If inventory periods are not used, the date in the Allow Posting From field of the General Ledger Setup window will define when the adjustment entry is posted.

    Please refer to this link.

    docs.microsoft.com/.../hh169387(v=nav.90)

    I think you should open the Allow Posting from Jan. so that any changes happen for the last periods should be included in your inventory revaluation.

    If you find this information helpful, Click Yes to Verify the answer to share with other community members.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 430 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 302

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 291

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans