Questions Single Stock Item from Multiple product sources
Here's a scenario I need help developing a solution on. We're using FIFO costing.
We make a Widget in our factory in the US. We also import the same Widget from another factory overseas.
We sell the Widget. It's the same Widget but the overhead/labor costs for the Widget are different with import vs. US built.
With our current system (not Acumatica) we have 2 different item codes for the Widgets and the sales people look @ inventory and determine which one we have enough of. Then they price/quote it out accordingly and use the item code that corresponds to the in house or import to sell it.
What makes more sense to me would be to have 1 item code since we sell them as "the same" but allow for different costing. Is there a way to identify the "source" item for what's being sold when it comes to the cost.
Will cost price per warehouse resolve this?