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

Adjust Cost Post to G/L Posting Date Issue

(1) Share

Report

Posted on by CU22102257-0

Dear Community Expert;

I'm desperately seeking for solution.
My client system NAV 2009 (R1)
All Items Costing Method setup as Average
Adjust cost Post to G/L setup to run every night (Nav Job Queue)

The issue is, user have posted Negetive Inventory Adjustment on March 2023, on the same night Cost Adjustment was partilly posted to G/L. The remaining Cost Adjustment was ported to G/L eight month later in Nov 2023. The finance team need explanation on this behavour. Question is why NAV did not pick up entire Cost Adjustment post to G/L on March 2023?

Thank you.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Jun Wang 8,188 Super User 2025 Season 2 on at

Like (0)

Report

Adjust Cost Post to G/L Posting Date Issue

There might not be a straight answer to why nav is behaving this way. Overall, there could be a timing issue with regard to those transactions. You need to look into such cases posted to Nov and analyze if the timing of the transactions is different from other transactions posted in march.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 30,066 Super User 2025 Season 2 on at

Like (2)

Report

Adjust Cost Post to G/L Posting Date Issue

There is always an explanation for what the system does; it’s not an unexplainable black hole that does things at random. Every single thing it does is driven by its source code.

To understand your specific situation, however, we would need the details of all transactions involved, including the negative adjustment transaction and the specifics of the transaction it was applied to. This is one of those cases where having system access to trace the transactions would help as anything we suggest here is just an assumption. For example, the system will post adjustments when a transaction is fully applied. Was your negative adjustment perhaps not fully applied until November? This would explain why the adjustment was posted then.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,438 Super User 2025 Season 2 on at

Like (1)

Report

Adjust Cost Post to G/L Posting Date Issue

This may also be caused by customization. Since NAV2009 has been out of support for a long time, you can ask your partners to investigate this issue together.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

Adjust Cost Post to G/L Posting Date Issue

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Adjust Cost Post to G/L Posting Date Issue

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates