Correction of expected cost, if shipment and invoice posting is in different years.

(1) Share

Report

Posted on by techreviews.digital

376

Hi Team,

Greetings!!!

I have posted the shipment in 2023, but its invoice is posted in 2024. This is why it is showing higher expected cost in inventory valuation report for 2023.

I wanted to decrease the expected cost, record the cost of shipped items in 2023.

According to my knowledge the cost is only reflected in the inventory GL, once the invoicing is done for the same. Otherwise, it only changes the quantity in Business Central.

Thanks & Best Regards,
Sheikh Muhammad Jawad

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I assume the best option would be to manually post the value between GL accounts in 2023, if the accounting period is not yet closed and all balances have been reported. Then do reverse posting of this value in 2024.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,986 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

According to my knowledge the cost is only reflected in the inventory GL, once the invoicing is done for the same. Otherwise, it only changes the quantity in Business Central.

That is correct if in the Inventory Setup Page you have Expected Cost Posting set to No.

If you have expected cost posting set to no, why do you want to change the expect cost in the inventory subledger? From the way I see it, its working as intended. When the item was received you have your expected cost, this cost as the name implies is expected, you don't know the actual cost. And when the item is invoiced, you have your actual cost. The two don't need to be the same, any variance is due to not knowing the actual cost at the time of the receipt.

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

Dynamics_Decoded_Gokul 483 on at

Like (1)

Report
Copy link

Link copied!

Hi,

As far as System standards i would recommend you to close the inventory period of 2023 before posting the invocie in 2024 later closing all the inventory period and accounting period post the invoice in 2024 this will reflect only in 2024 entries.

by this way we can keep the expected cost as accured value of interim for the 2023 year and the same will be reduced in the year of 2024 at the time of invoicing.

Thanks
Gokulnath

Was this reply helpful? Yes No
Verified answer

Jun Wang 8,208 Moderator on at

Like (2)

Report
Copy link

Link copied!

I don't see this as an issue. inventory valuation include expected costs. it doesn't have to be the same as actual costs.

I assume the expected costs have been posted to its own accounts and you could separate the expected from the actual?

Was this reply helpful? Yes No