Currently on my test item I have made 2 transaction for the item to test the average cost.
The first transaction is from the Vendor to our subsidiary MPCN, purchasing the item at $10. The second is MPCN selling the item to our other subsidiary MPUK (my primary and the parent subsidiary) at a markup to total $100.
I've created a saved search to find the average cost of the item and as I had hoped the average cost appears to be tied to the subsidiary and not a mix of the two. The saved search is currently telling me that the average cost of the item is $100 and not $55 or something.
If I make a PO for the same item from MPCN to the vendor, the suggested price is $10, so it appears to have stuck the cost to that subsidiary but I'm not sure if this is the average cost? As when I view the item info, even in an MPCN role that doesn't have access to MPUK, the item information tells me that the average cost is $100 and not $10.
I'm trying to understand if the price on the new PO for $10 is indeed the average cost or something else. Ultimately I want my saved search to pull the average cost for MPCN, not MPUK but I'm not sure how to define this criteria on the saved search.
Appreciate any guidance~