We purchase inventory in Location A, transfer some of it to Location B and sell from Location B.
We receive returned inventory in Location B. The RMA (stand-alone) is not linked to invoices because the latter are not determinable. If there's no inventory on hand in Location B, then there's no GL impact for the returned item which is wrong. What is the best practice here? Should we just use the Override Rate field (not preferred because it requires manual work)? If we can use the overall average cost or average cost in Location A, that'd be great. But it sounds doable only through scripting.