I'd like to hear any thoughts/suggestions anyone may have for what I'm trying to accomplish. In some cases, but not all, I want to display a different part number from the Item Name/Number of an inventory item on customer facing forms (quotes, sales orders and invoices).
I know the Display Name/Code field is designed for this but NS uses this value 100% of the time for every customer and every transaction. I need to apply this to only some customers and only for some items. I may need to use the alternate name for customer A but not customer B (this is why the Display Name won't work). Some customers may have a few dozen items this would apply to and another customer may have a hundred but not necessarily the same dozen the other customer needs.
A few thoughts I've had:
Kits. I could create kits with just one inventory item I wish to do this for but this gets tedious and kits don't flow as well as inventory items well in our downstream processes.
Create new items. I could simply create new items every time this comes up but I really don't like the idea of having more than one item created for the same actual part. This would make inventory a nightmare.
I guess ideally what I want is an "alias" item type. You create the alias and name it whatever you want but tie it to another inventory item. Every time the alias item is used, it uses the alias name on all customer facing forms but the actual inventory item is used "under the hood" for all purchases, inventory calculations and such.
Any thoughts/suggestions are appreciated. Thanks.