I have the following situation and I am exploring ways to handle it:
We manufacture an item from two different plants with different BOM and ROUTING, we want to be able to track the standard cost at the different plants, but I want it so when it comes to the customer orders, Navision treats the two items as the same. Maybe build in preference based on location, but overall I just want to be the same externally.
Our current process: We use one item number for all of the products produced, but we have different BOM and Routing. This method is a pain because we have to manually switch the BOM and Routing based on the location and it does not allow different standard cost for different locations.
I have received a recommendation from our NAV provider who is recommending a modification of the SKU card so everything will be location specific. The feature sounds promising, but the amount of modifications I imagine will require is concerning and it seems redundent to reproduce all the feature of the item card when the item card is already there!
The idea I’m exploring is just create two different items for the locations so we have all the features we need (no modification on item side), but manage this on the sales order level so when a customer orders item 123, we can ship item 123A or 123B. I am wondering about what functionality in NAV will support this, I am exploring kitting and cross reference. I imagine other would have encountered the same problem as me and I’d like to hear about your solutions. Bascially what I want is only to have item 123 on the invoice, but internally we can pick 123A or 123B. Are there any other feature of Navision that may support this?
Version V5 SP1