Query Original value of Transfer order
We're trying to query the original value of a Transfer order. So it should be the UNIT_COST_AVERAGE value at the moment of creation of the transferorder line. Is there a link from INV_TRANSFER_ORDER_LINES to CST_PERPAVG_COST? We joined on inventory_item_id and cost_org_id, but I think we need to join on a deeper level, any ideas?