Skip to main content

Notifications

Announcements

No record found.

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

Unit Cost on SKU does not match Inventory Valuation

(0) ShareShare
ReportReport
Posted on by 15

I am setting up our company in BC and migrating from NAV.  We did not use stock keeping units before, but did value our inventory the same way (Average Cost - Item, location, variant). I start with an item that has no transaction history in BC and there is no inventory. I just copied over the key data from NAV. Unit Cost is 38.315. I have two locations: 10 and 99

pastedimage1680041184639v1.png

I purchased 100CS of this item at $25 to location code 99.  When I view the unit cost on the stockkeeping unit card, it correctly displays as $25.  However, when I then buy 100 cases to location 10 at $30 (where no inventory transactions exist), the resulting unit cost calculation looks like this:

pastedimage1680041239632v2.png

pastedimage1680041290376v3.png

The unit cost on the SKU card for location 10 is $27.50!  Even weirder, this doesn't jive with the inventory valuation report:

pastedimage1680041334143v4.png

Can someone explain what's going on here?  I think that the Unit Cost calculation on the SKU card is incorrectly self-referential.  It's taking into account the total unit cost in the cost calculation for this SKU.  What's worse is that when this item is added to a sales order, I get the wrong unit cost (27.50, not 30.00)

  • kevinrhee Profile Picture
    kevinrhee 15 on at
    RE: Unit Cost on SKU does not match Inventory Valuation

    I've run it manually as well.

  • kevinrhee Profile Picture
    kevinrhee 15 on at
    RE: Unit Cost on SKU does not match Inventory Valuation

    Yes.  This is my Inventory Setup

    pastedimage1680096963541v1.png

  • YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Unit Cost on SKU does not match Inventory Valuation

    Hi, I see that your Costing Method is Average, have you performed Adjust Cost - Item Entries?

    pastedimage1680048212060v3.png

    pastedimage1680048193538v2.png

    Hope this helps.

    Thanks.

    ZHU

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans