Issue |
The problem we have is we might have one item, built in China, and if it's stocked here, our cost is higher than if it is stocked in our China plant. I was looking at the stockkeeping units to hold a separate cost for this one item in two different locations. Though in testing it, what I've found is that the average price changes per item, rather than per location (I've adjusted my setup in inventory to do the average cost cal. type to per item/location/variant, rather than just item.) Is this the way it is supposed to work, with avg. cost always per item? The setup seems to suggest otherwise. |
Solution |
This is how the cost by location works in Navision. Say inventory is stocked at China and Canada After Item 'A' is manufactured in China, Average Cost = $10/Unit Typically, the cost of an item would differ from one stocking location to another due to additional charges like, Freight, Customs Duty, etc. For Navision to maintain different costs at China and Canada for the same item, these additional costs incurred in the transportation of the item have to be assigned/apportioned to the item. This is done in Navision using "Item Charges." Once these charges have been assigned to the items which were received in Canada, you will see: Unit Cost in China = $10 The above process would have to be followed in order for the system to maintain two different costs for the same item by location, along with the Setup Parameters in the inventory setup as you described. |
Stockkeeping Units - Cost by Location Print
Modified on: Mon, Dec 12, 2016 at 2:57 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.