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)
I've run it manually as well.
Yes. This is my Inventory Setup
Hi, I see that your Costing Method is Average, have you performed Adjust Cost - Item Entries?
Hope this helps.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156