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

adjust cost item entries in business central

(7) Share

Report

Posted on by CU24031017-0

We have the following cost scenario in Business Central:

Purchase receipt posted on 12-Feb-2025 and purchase invoice posted on 13-Feb-2025 for three items

Sales invoice posted on 14-Feb-2025

Item Charge Purchase Invoice posted later on 25-Feb-2025, allocating additional costs to the above purchase entries

Adjust Cost – Item Entries batch job is scheduled and running every day

However, even though the batch job was running daily in February, the cost adjustment and the rounding entry were posted only on 01-Mar-2025.

✔ My expectation:

The COGS should have been adjusted based on the invoice posting date in February, because the item charge invoice was also posted on 25-Feb-2025.

❓ My question:

Why did Business Central delay the cost adjustment and rounding postings until 01-Mar-2025?

Why didn’t the COGS get updated in February when the daily Adjust Cost batch job was already running? but in GL adjustment posting date is 01-03-2025. why?

Looking for clarification on this behavior

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Business Central posted the cost adjustment and rounding entry on 01-Mar-2025 because the Adjust Cost – Item Entries batch job uses the posting date defined in Inventory Setup (often set to “Posting Date of the Adjustment”), meaning adjustments reflect the date the job runs, not the original transaction date.

Even though the item charge invoice was posted on 25-Feb-2025 and the batch ran daily, the system waits until all costs are finalized and then posts using the configured posting date, so COGS updates appear in March unless you change the setting to “Posting Date of the Original Entry” and keep February open for posting.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi, The following is a detailed explanation, which hopefully will give you some hints.

Design Details: Posting Date on Adjustment Value Entry

https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-inventory-adjustment-value-entry-posting-date?wt.mc_id=DX-MVP-5004336

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Namaste @CU24031017-0

Cost Adjustments are done on Posting Date not on transaction date of originial Purchase invoice . Hence the variaition gets added and it also impacts inventory valuation Report .

IF you want to see the impact immediately in preview posting , you can view cost adjustments as per below setup in inventory setup

There are various COGS is set on expected as sales invoice is not done . Posting date is key factor for adjustments

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

BC posted the cost adjustment on 01-Mar-2025 because February was no longer an allowed posting period.
Even though the item charge was from February, the Adjust Cost batch job can only post into the earliest allowed posting date.
So when February became blocked, BC moved all adjustments to 01-Mar-2025 automatically, exactly as designed.

That’s why COGS didn’t update in February despite daily runs.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
First, I would ignore the first post, it’s a post generated using AI because it's hallucinating about functionality that doesn’t exist in the system.

Second, the Adjust Cost – Item Entries batch job always tries to post the adjustment on the original posting date. But it checks the Allow Posting From field in General Ledger Setup first.

If Allow Posting From is later than the original posting date, the adjustment will post on the Allow Posting From date.

If Allow Posting From is earlier than the original posting date, the adjustment will post on the original posting date.

In your case, Allow Posting From in General Ledger Setup must have been set to March 1, so that's why the adjustment is on that date.

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