Share
Report
15I 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)
All responses (
Answers (
