Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Change or increase in opening balance of inventory

(0) ShareShare
ReportReport
Posted on by 73

Hello everyone,

Hope all is well. I would like to ask you what is the effect of change or increase the inventory opening balance.

For more Clarifications. Now, I'm already posted the inventory opening balance in 1/1/2022 with an amount 8000000.

The customer started entry his transactions and make purchasing and sales transactions within the period and he need to increase the opening balance to 10000000 and this increase include some change in the unite cost and increase in quantity. So, can you suggest the best practice and the accurate effect in this case.

With highly regards

Thanks

  • Verified answer
    Basem Ibrahim Profile Picture
    73 on at
    RE: Change or increase in opening balance of inventory

    Thank you for your help, much appreciate your efforts

    Best regards,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,025 Moderator on at
    RE: Change or increase in opening balance of inventory

    If you can see that the cost of the sales transactions are adjusted then everything is fine.

    That is easier to see from the item ledger entries than from the cost calculation.

    So then it seems like you completed all steps successfully!

  • Basem Ibrahim Profile Picture
    73 on at
    RE: Change or increase in opening balance of inventory

    I can see the cost of sales transactions has been adjusted after the revaluation process. or you mean anther action ?

    The cost on my item card now is 24.53346

    Everything okay now or I missed some process ?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,025 Moderator on at
    RE: Change or increase in opening balance of inventory

    The revaluation looks fine. But did you run the cost adjustment yet?

    It looks like the cost is not adjusted for the sales transactions.

    And what does the cost on your item card say now?

  • Basem Ibrahim Profile Picture
    73 on at
    RE: Change or increase in opening balance of inventory

    Dear Mr. Inge M. Bruvik,

    Your guidance is very helpfull.
    Now, you can check that process with my screenshot.

    In this Screen, you can see all details before the process of revaluation

    pastedimage1665235474025v1.png

    After making the process of revaluation, I increased the unit cost from 18.75 to 25 and this is the result.

    pastedimage1665235514400v2.png

    Is this the correct effect ? 
    Best Regards, [quote user="Inge M. Bruvik"]

    If the inventory you had on the date of the opening balance is soled then the actual cost of these sales transactions will be updated when you do the item revaluation as long as you run automatic cost adjustment. If you do not run automatic cost adjustment you will need to run cost adjustment manually after you do the item revaluation.

    If there are still remaining inventory from your opening balance then the inventory value will be updated after the revaluation. Your purchase invoices should not be effected.

    Also make sure that when you run the item revaluation you have to select the option to calculate by item and not by item ledger.

    Also make sure to chose the correct date and i also recommend you evaluate one item at the time so you can check that you get the expected outcome before you move on to the next item. The will also make it easier to have a good audit trail for the financial effect of your transactions.

    pastedimage1665230162108v1.png

    Here you can see the effect on the item value entries after i first posted incoming balance and then reevaluated the cost at a later stage

    pastedimage1665230526423v2.png

    And here the effect on a sales transaction posted several months after the incoming balance was posted but still consuming the inventory that was part of my incoming balance.

    pastedimage1665230678188v3.png

    So the financial effect is all taken care of. But if your finance people have reported for the effected periods their reports will be effected as well. So you need  to have a dialog with them around that.

    I hope this was understandable. If not let me know. 

    [/quote][quote user="Inge M. Bruvik"]

    If the inventory you had on the date of the opening balance is soled then the actual cost of these sales transactions will be updated when you do the item revaluation as long as you run automatic cost adjustment. If you do not run automatic cost adjustment you will need to run cost adjustment manually after you do the item revaluation.

    If there are still remaining inventory from your opening balance then the inventory value will be updated after the revaluation. Your purchase invoices should not be effected.

    Also make sure that when you run the item revaluation you have to select the option to calculate by item and not by item ledger.

    Also make sure to chose the correct date and i also recommend you evaluate one item at the time so you can check that you get the expected outcome before you move on to the next item. The will also make it easier to have a good audit trail for the financial effect of your transactions.

    pastedimage1665230162108v1.png

    Here you can see the effect on the item value entries after i first posted incoming balance and then reevaluated the cost at a later stage

    pastedimage1665230526423v2.png

    And here the effect on a sales transaction posted several months after the incoming balance was posted but still consuming the inventory that was part of my incoming balance.

    pastedimage1665230678188v3.png

    So the financial effect is all taken care of. But if your finance people have reported for the effected periods their reports will be effected as well. So you need  to have a dialog with them around that.

    I hope this was understandable. If not let me know. 

    [/quote][quote user="Inge M. Bruvik"]

    If the inventory you had on the date of the opening balance is soled then the actual cost of these sales transactions will be updated when you do the item revaluation as long as you run automatic cost adjustment. If you do not run automatic cost adjustment you will need to run cost adjustment manually after you do the item revaluation.

    If there are still remaining inventory from your opening balance then the inventory value will be updated after the revaluation. Your purchase invoices should not be effected.

    Also make sure that when you run the item revaluation you have to select the option to calculate by item and not by item ledger.

    Also make sure to chose the correct date and i also recommend you evaluate one item at the time so you can check that you get the expected outcome before you move on to the next item. The will also make it easier to have a good audit trail for the financial effect of your transactions.

    pastedimage1665230162108v1.png

    Here you can see the effect on the item value entries after i first posted incoming balance and then reevaluated the cost at a later stage

    pastedimage1665230526423v2.png

    And here the effect on a sales transaction posted several months after the incoming balance was posted but still consuming the inventory that was part of my incoming balance.

    pastedimage1665230678188v3.png

    So the financial effect is all taken care of. But if your finance people have reported for the effected periods their reports will be effected as well. So you need  to have a dialog with them around that.

    I hope this was understandable. If not let me know. 

    [/quote]

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,025 Moderator on at
    RE: Change or increase in opening balance of inventory

    If the inventory you had on the date of the opening balance is soled then the actual cost of these sales transactions will be updated when you do the item revaluation as long as you run automatic cost adjustment. If you do not run automatic cost adjustment you will need to run cost adjustment manually after you do the item revaluation.

    If there are still remaining inventory from your opening balance then the inventory value will be updated after the revaluation. Your purchase invoices should not be effected.

    Also make sure that when you run the item revaluation you have to select the option to calculate by item and not by item ledger.

    Also make sure to chose the correct date and i also recommend you evaluate one item at the time so you can check that you get the expected outcome before you move on to the next item. The will also make it easier to have a good audit trail for the financial effect of your transactions.

    pastedimage1665230162108v1.png

    Here you can see the effect on the item value entries after i first posted incoming balance and then reevaluated the cost at a later stage

    pastedimage1665230526423v2.png

    And here the effect on a sales transaction posted several months after the incoming balance was posted but still consuming the inventory that was part of my incoming balance.

    pastedimage1665230678188v3.png

    So the financial effect is all taken care of. But if your finance people have reported for the effected periods their reports will be effected as well. So you need  to have a dialog with them around that.

    I hope this was understandable. If not let me know. 

  • Basem Ibrahim Profile Picture
    73 on at
    RE: Change or increase in opening balance of inventory

    Hello Inge M. Bruvik,

    Thank you for your support. Now, I would like to make sure for the financial effects in this case knowing that the costing method is Average.

    Based on the sales and purchase transactions that had been posted within the period. Will the system recalculate the cost of inventory after doing that process ( Item Journal and revaluation journal ) automatically ?

    or will effect the new transactions that will be post after doing that process ?  

    Best Regards,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,025 Moderator on at
    RE: Change or increase in opening balance of inventory

    Hi

    In my experience the best approach here is to use a combination of physical inventory adjustment and item revaluation.

    The first thing i would do is to use physical inventory to adjust the qty in the inventory to be correct on the date of the opening balance.  You can do that trough an item journal where you enter positive or negative adjustments as needed.

    Then you should use item revaluation to make sure you have the correct unit cost for the inventory of the date of your opening balance. I have added a link to my blog where i explain how to do item revaluation in Business Central.

    bc365.co/.../

  • Suggested answer
    Amit_Sharma Profile Picture
    2,547 on at
    RE: Change or increase in opening balance of inventory

    Hi,

    There are two option

    1. Item Journal- Positive & Negative

    https://erpconsultors.com/creation-and-posting-of-item-opening-from-item-journal/

    2. Use Physical Journal

    Regards

    Amit Sharma

    www.erpconsultors.com

     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 247

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 231 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans