Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Correction of expected...
Small and medium business | Business Central, N...
Unanswered

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

(1) ShareShare
ReportReport
Posted on by CU31050517-0 14

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:
Business Central
Business Central
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    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 Profile Picture
    Tech_BC_Gokul 295 on at
    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 Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    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.
     
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,934 Super User 2024 Season 2 on at
    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.
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans