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

(1) Share

Report

Posted on by CU31050517-0

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

All responses (4)

Answers (0)

Suggested answer

Jun Wang 7,641 Super User 2025 Season 1 on at

Like (2)

Report

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

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?
Suggested answer

Tech_BC_Gokul 331 on at

Like (1)

Report

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

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
Suggested answer

Valentin Castravet 26,865 Super User 2025 Season 1 on at

Like (1)

Report

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

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/
KasparsSemjonovs 4,125 Super User 2025 Season 1 on at

Like (2)

Report

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

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.

Community site session details

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

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates