Dynamics Community Forum Thread Details

Unit Cost on SKU does not match Inventory Valuation

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

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:

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

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)

Quick Links

Leaderboard