Hi all, I have a dilemma here with product cost. As we know that we keep the information about product cost in InventoryItem. But, I cannot really use the product cost from InventoryItem, since the cost there is not quite correct for some InventoryItem. Users sometimes typed in a wrong number or that kind of actions. What I need is a "Master product cost" somewhere which is related to Product. So, which way is better, extending the existing entity (Product), or create an entirely new entity to hold Product_id and cost? Any suggestion?
Thanks Lyyas Yasin