How to handle zero or old cost items in intercompany IR/ISO
We are in the process of rolling out intercompany IR/ISO. We have the entire process functioning as expected but I keep hitting a roadblock that I'm sure others have experienced but I can't find any discussion about it.
Basic setup:
- Oracle EBS 12.2.3
- Average Costing
Scenario:
- Mexico creates an IR for Part X and is sourcing it from the US
- Part X has either never been purchased ($0) or the item cost is very out of date (e.g. $50)
- The Mexico IR picks up the current cost ($0 or $50) and the US ISO shows a price to match ($0 or $50)
- US buys and receives the part for $100 (nothing was onhand before so item cost is now $100)